Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

olap cube live connection

Can I create calculatesd measures with live connection in olap cube with Analisys Service? Thanks
Need Help
bdarbonneau's avatar
bdarbonneau
Frequent Visitor
6 years ago

@simone74


You can create measures when live-connected to OLAP cubes by following the steps:

- create a report connected live to the OLAP cube on the ssas server. 

- publish this report to the Power BI service and share the dataset. If the server is on-prem, you will have to use a gateway.

- create a report connected live to the shared dataset. Then in this report, you can create measures using DAX functions.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Many thanks.

In this way I can create only measures not add column. Right?

  • bdarbonneau's avatar
    bdarbonneau
    Frequent Visitor
    6 years ago

    Yes. You cannot add columns, only measures. But you will also discover that an OLAP cube does not behave like a tabular one. In my experience, it's not possible to use time intelligence DAX functions, and when you refer to a column, you will need to refer to the key. I have used this feature to create dynamic title measures. Here is an example:

    Selected Month = IF(HASONEVALUE('Invoice Date'[Month.Key0]),VALUES('Invoice Date'[Month]),"Many")

    Another useful tool to explore the OLAP cube columns si DAX Studio.