Always getting #Missing as a result when working with smart view. Anyone knows how to solve it and get the right numbers? On the Smart view training the presenter could not solve it and always appears #Missing as result

Missing means 'null' or 'no value' for the combination of dimension values you selected. You need to check the values you selected for each dimension and ensure there is data for it.

Error Unable to connect to the provider while Installing the Smart view provider Hyperion/Fusion reporting

Error Unable to connect to the provider while Installing the Smart view provider Hyperion/Fusion reporting

Connection steps 

Go to General Account Function

Navigator >General Accounting > Period Close > Open Workspace for Financial Reports

The Shared Connections URL should be something like https://ZZZZ.fa.em2.oraclecloud.com/workspace/SmartViewProviders.

then press Ok.

In MSExcel > SmartView > Options > Advanced > Shared Connection URL - Enter here the above created URL.

Result