Background:
I'm writing a data provider that SSAS will use to get data from a third-party system.
I wrote a tool that will build cubes, dimensions, measure groups and measures based on the configuration of the third-party system using AMO.
Now, in the Cube Browser, I am able to pull the members of the dimensions, however, measure data is never queried - I know this because my data provider will log all SQL queries SSAS requests from it.
So, how do I diagnose this? What are the configuration steps for measures (this is just a regular, 1:1 measure against a single-key dimension - VERY simple cube).
As far as I can tell, my relationships are the same as a working dimension and measure, and I don't get any errors from SSAS or the event logs, just silence and a set of empty cells in the Cube browser.
Thoughts?
I found my issue.
When I created the measure group using AMO, I never created a partition for it. Measure groups without partitions will deploy and process without errors, but nothing will be queried because the relationship to the fact table doesn't exist.