Large SQL generated when using #prompt keyword in Framework manager

[CM11dev]

Hi All,

I have a relational model setup in my environment and I have a single fact table in my schema.

When I try to create a report in report studio with olap functions by using 'for' keyword, the sql generated is a single query with one select statement.

Now I have updated my FM models to filter on one of the dimensions with #prompt keyword.
With this in place the sql generated is little more complex, cognos is generating T0 and T1 queries and doing a full outer join. T0 has the measures with aggregate functions and t1 has only dimensions.

This behaviour goes away and single query will be generated as before if the prompt in my framework is designed by using ?prompt? Syntax.

The issue seems to be with #prompt keyword.
Can you please help me resolve this?


Sent from my iPhone using Tapatalk