InventValueCube's calculated measure and KPI's not showing

(0) Share

Report

Posted on by xain

504

Hello All,

I have deployed a cube named "InventValueCube" but its "Calculated measures" fields are not showing in excel which are pre-built ? what i am missing in this? Please help? Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Do you see those arrows? Can you expand those? That should allow you to use fields in the pivot table.

If not, can you please explore your Cube on SSAS server to make sure if structure was created successfully, as you deployed the cubes.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Have you processed the cube already?

Best regards,

Ludwig

Was this reply helpful? Yes No
xain 504 on at

Like (0)

Report

Hi sohaib yes i can see those arrows? that was my point that "Calculated measures" fields are not showing in my deployed cube as shown below . this screen shot is from another environment.

actually we have moved to a new environment so we had to reconfigure this cube to the new environment, so i tried with updating the connection in new environment, but as soon as i change the connection, the data get lost so i guess i had to create a new connection and configure the fields but when i do that i only see limited fields as shown below

is it possible that cube in new environment is not deployed correctly and that's why it is showing limited fields?

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

How you have changed connection in the new environment?

Do you know you can change that from connection string in SSAS Database? Also you can change the string on the Visual Studio if you have opened Cubes project in VS.

Was this reply helpful? Yes No
xain 504 on at

Like (0)

Report

i am trying to change the source for excel, so i am trying to change from change data source button in Analyze tab in excel which is also visible in screenshot above.

Was this reply helpful? Yes No