Clever Geek Handbook

Why isn't SSAS loading dimension data for my cube?

Background:

I am writing a data provider that SSAS will use to fetch data from a third party system.
I have written a tool that will create cubes, sizes, measure groups and measures based on a third party system configuration using AMO.

Now, in the Cube Browser, I can pull out the dimension items, however the data dimension is never requested. I know this because my data provider will log all SQL SSQL queries from it.

So how do I diagnose this? What are the setup steps for measures (this is just a common 1: 1 measure versus one key dimension - a VERY simple cube).

As far as I can tell, my relationship is the same as working dimension and dimension and I am not getting any errors from SSAS or event logs, just silence and a bunch of empty cells in the Cube browser.

Thoughts?

+1


source to share


4 answers


I found my problem.



When I created a measure group using AMO, I never created a section for it. Dimension groups without partitions will be expanded and processed without error, but nothing will be requested because the relationship to the fact table does not exist.

+1


source


CALCULATE; the command was not present in the Scripts / Calculations tab. Solved and working



+1


source


To fix the calculations:

In the Calculate Cube tab, make sure you are in script view (as opposed to form view). Write the word CALCULATE in the script area. Return to the Browser tab to ensure that you now have your measurement data.

Thanks for the direction, Jan!

+1


source


For others:

  • Make sure CALCULATION; the command is present in the Scripts / Calculations tab.
  • Make sure to include the relationship between dimensions and dimension groups.
  • Set any related UnknownMember Visible properties.

More suggestions here and here

0


source






More articles:


All Articles