Dynamic Cube with Drill and Dynamic Prompt for Rows does not work

[eliza_jane]

I have a report with rows populated by one of many dimensions say Product, Region etc. using token prompt macro with the prompt on the report page. When we drill up and then select a different dimension to display the prompt does not get reflected in the report. Say we choose Product and then drill up on Product and then choose Region the report does not change to display Region.

This is against 10.2.1, Dynamic Cube, DQM.

[MFGF]

Hi,

My guess? When you drill up, the expression containing the prompt macro in your report is replaced by the members of the level above, so your crosstab no longer references the parameter the prompt is setting.

MF.

[adik]

try creating member sets (goto query explorer, set the property Define Member Sets of your query to Yes), them in the members set tab place your calculated data item. then go to the menu bar, data -> drill behaviour -> advanced tab select the data item and set drill-up and drill-down behaviour to replace expression

[eliza_jane]

Hi adik, That does not work. The prompt does not get reflected on drills.

MF, is there a way to get around this? This seems to be happening against dynamic cube data source but not against a DQM data source and also observed in Workspace against any dimensional data source.

[adik]

can you post the report specs of what you want to achieve?

[eliza_jane]

Hi Adik, The requirement is simple. Display a crosstab where the rows are populated by a prompt on the report page allowing users to choose between many dimensions. Provide drill functionality on the rows.

So the prompt contains values such as Product, Region etc. The rows data item contains a token macro prompt. this data item has drill enabled on it.

As explained the issue is the prompt works independently, the drill also works independently, the 2 together do not work. So if I select products, I see products on my crosstab rows. Then if I drill up I see the Product Line. Then if I choose to display regions nothing happens. The crosstab rows still display Product Line.