Displaying Missing Columns from Cube in Crosstab

[BlackDuck]

Hi,

I hope I describe this issue clearly.

I have a report with two crosstabs one above the other.
Each crosstab looks at the same MS SSAS Cube but filtered differently.
Most times it displays correctly if data is presented but there are times were the second crosstab may not have data for a column and so the query returns a missing column because there is nothing for that column and if that is the case the columns move to the left and therefore the two crosstabs misalign.
If the bottom crosstab has the column titles hidden (boxtype = none) because it is meant to look like one crosstab using the top crosstab columns, if the second crosstab is missing a column you are unsure which column is which.

Question: is there a way to display a column if there is no data or if the cube does not return one?

I have tried format / Missing Value

Remember if the cube returns no data it does not even display that column.

Have I successfully confused you?

*Quack*

[CognosPaul]

Can you give more insight on how your query is built? In theory a cube shouldn't automatically suppress empty members (by default at least, there's is a setting for it in SSAS).

It sounds like you're using detail filters in the query. If I'm right, then that's probably what's suppressing your data. There's really no reason at all* for using detail filters on an OLAP query. Can you shed more light on what's going on in your query?





* Not entirely true, the only exception for my NO DETAIL FILTERS rule is for drilldown reports. That's just due to a limitation in Cognos which I hope they'll fix some day.