Hi guys,
I created value banding table for grouping my numbers to a specific ranges.
0 to 13 400
14 to 25 150
26 to 36 700
.
.
.
When I create the catalog and defined the joins I selected the outer join option on the value_band table to make all bands appear on the report even if there are no values that fall within them. I was able to do this in Impromptu.
However, when I created an IQD out of the report and used it as source in PowerPlay Transformer, when I generate the cube the bands without values in them are not included.
My question is is this how PowerPlay Tranformer treat categories without values or is there a way for Tranformer to include them even without values?
I created value banding table for grouping my numbers to a specific ranges.
0 to 13 400
14 to 25 150
26 to 36 700
.
.
.
When I create the catalog and defined the joins I selected the outer join option on the value_band table to make all bands appear on the report even if there are no values that fall within them. I was able to do this in Impromptu.
However, when I created an IQD out of the report and used it as source in PowerPlay Transformer, when I generate the cube the bands without values in them are not included.
My question is is this how PowerPlay Tranformer treat categories without values or is there a way for Tranformer to include them even without values?