This content has been marked as final. Show 5 replies
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 :)
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