Using TM1 Cubes in Report Studio

[ComplexQry]

I need help understanding why if I make a List Report based on a query that I get blanks and zeroes and what I can do to get around that.

Lets say I have a query that is Product Type, Product, Quantity.  If I have a, unfiltered List with all three of those items, data comes through correctly.  If I make a list of only Product Type and Quantity, I still get values.  But as soon as I filter on specific Products, the list of all three items is still correct, but the list of just Product Type and Quantity is now blank.

I need help understanding this behavior and how to get around it, it is very problematic for a report I am attempting to create.

[tjohnson3050]

Can you supply a little more information about how the TM1 cube is structured?  Are product type and product in the same dimension?  What are the levels of dimensions involved etc.

Also - is this report studio?  If so, are you using MDX filter functions in the data item definitions, or are you using the detail or summary filter panes?

[ComplexQry]

Well I was just using Product Type/Product as an example that is commonly used.  What I am really doing is using a 3rd party mapping tool (Vantage SpotOn).  And how that map passes filter logic as you work through the map is only by using detail filters.  Nonetheless, I have been able to resolve my issue by using shortcut queries to force the aggregating to be done on the Reporting Servers and not the TM1 Server.  Not ideal, but it works.

To answer your question though, this geography dimension is Region, State, County.  And to reiterate, I am not using MDX Filter Functions, I am using Detail Filters because of limitations of how the tool passes those filters.

[tjohnson3050]

All you need to do is use the supress nulls/zeros function on the tool bar.

The reason that it is happening has to do with the nature of dimensional versus relational reporting. 

With a relational report, your filter would remove the detail rows, then the content of the data would be used to determine what data is displayed.

With a dimensional report, the filter only filters the measure values, not the dimensional items being returned.  To filter the dimensional items, the MDX filter function, or the supress nulls/zeros function is required.