Fixed Dimension values in the report

[prachisangewar]

Hi,

I want to make a report which has a fixed template e.g. I have dimension as Category and another is Reporting Attributes

Every category has its own Attributes which should be should irrespective of whether the Fact has the data for them or not.

Also some Attributes exist for more than 1 Category.If I select the "Show All Values" I am able to see all Attributes but then on selecting any other filter like Transaction Date or Country from the List box only the relevant Attributes having data are shown.

I want the template to be fixed,If there is no data the measure should be a blank or zero.

Report 1 for Category 1

Attributes   Att Detail   Amount

A1              d1              10

A2               d2              -

A3               d3               5

A4                d4              2

Category 2    Att Detail         Amount

A3                     d3a              7

A4                     d4a              9

A5                     d5                20

A6                      d6               25

Please help to suggest.

Thanks a lot!

[Digvijay_Singh]

Similar explanation here as well -

Show all values in Pivot/Straight Table (irrespective of current selection)

[prachisangewar]

Hi Sreeni,

The solution does not work when the calculated dimension has ablsoultely no data for the selected filter.

Eg IF I select Filter value F1

Report1 for Category 1

Attributes   Att Detail   Amount

A1              d1              2

A2               d2              -

A3               d3               1

A4                d4              2

but for Filter value F2

Attributes   Att Detail   Amount

completely blank.How can I fix this.Even if "Category 1" does not have data for any Filter value F2,

It should show the structure

Attributes   Att Detail   Amount

A1              -              -

A2               -              -

A3               -              -

A4                -              -

Please sugget if any ideas.

Thanks a lot!