I have a report with an optional prompt containing Stores (there about 500 Stores) based over a Transformer Cube.
The [Store Hierarchy] is [Region] -> [District] -> [Store].
I have created a slicer as follows (I have tried multiple syntax variations):
#promptmany('parm_Store', 'memberuniquename', '[Store]','set(', '[Store] ',')')#
This works great when I select one or two stores, but the initial load (without any selections) takes longer than I would like.
If I just make the slicer on [Store Hierarchy] the initial load is very responsive, but I encounter other issues within my crosstab. I have to add detail filters to make it work correctly. I am somewhat new to Cognos (especially reporting based on Cubes) and I understand that this not the suggested methodology.
[Store Hierarchy] is a crosstab member cell with Drill Down/Drill Up enabled.
Is there a way to make this work better - Any suggestions would be extremely appreciated!!
Thanks in advance,
Adam.
Maybe we can get PaulM's ears burning.....he always answers these questions really well.
Honestly you can learn a ton by just reading his posts!!
In fact this post (http://www.cognoise.com/community/index.php/topic,19876.msg59358.html#msg59358) might be worth your while.
It looks like you're setting the default value to be the store level. Try setting that to the all member. By setting it to the store level, you're essentially telling it to create a calculated member which aggregates every single store.
PaulM...
That worked perfectly!
And thanks for the explanation as well as the solution.