This content has been marked as final. Show 5 replies
Instead you can create a separate folder as prompt in the presentation layer and place all the columns inside that folder.
Hope this helps you.
Yes we can create separate subject areas for dashboard prompt's alone. Here is a case
Say we need to create a constraint enabled prompt in our dashboard. So we bring in two dimension columns into the prompt.
When we run the prompt, the queries across these two dimensions go through a fact table (Because the only way two different dimensions can be joined is through a fact . This fact table is chosen by BI Server intelligently at run time and that can be set through Implicit Fact column also though). In this case there is a chance that some of the dimension rows might get skipped in the constrained prompt as all of the records might not be present in the fact table.
To mitigate this issue, we might want to create a separate subject area for dashboard prompts alone (using some fact less fact or by having a surrogate key in the 2nd dimension table etc).
Hope I am clear :)
The Question is not about seperate folder in the catalog,Its about the Prompt Performance.
You r perfectly clear..bang on.This is what i was looking out for.
But do u also have the steps handy for the process??It would be great if you can share some links regarding the same.
You can make a dummy fact table and join with the dimension in the physical layer as 1=1.
And make a separate subject area for these dimensions and dummy fact tables.
And you can use them in the answers.
You can also refer