Hi all,
I have a problem with discontinous Crosstab. This is the context:
Suppose I have a Time table with 2 column:
- date columns with values: 2016/01, 2016/02, 2016/03, 2016/04 ....
- last months column with values: 0 ,-1 ,-2 ,-3, -4, -5 .... the 0 value corresponds to current month, -1 : last month and so on
I have a Time dimension with two hierarchies.
- Date Hierarchy : populated from the daet column.
- the last 4 months of the year: M (current months), M-1, M-2, M-3, populated from the last months column
The users want to create dynamic report to compare for exemple the revenue in 11/2016 with the current months. So, they want to create crosstab with 2 members in the clumns: 2016/11 from the hierarchy Date and the M ( current months) member from the calculated month. The problem is when generating the report I get no data. I think because Cognos apply a fitler on time table like: Time.date = 2016/11 and time.last_month = 0.
I want to know how it can be done to display the two members in the same crosstab. Is it possible to make a change in the Framework the way that Cognso generate Or condition instead of AND.
Thanks for you reply.