Passing prompt values from dimensional model to relational model.

[Ann]

Hi Guys,

I need to pass prompt values from dimensional model to relational model.

Eg: I have region prompt which is a tree prompt in main report. In my drill through report I am using detail tables for region(relational model). So I need to pass the region that was selected in main report to drill through.

any clues?

[MFGF]

You have the option when defining your drillthrough of passing a data item value or a parameter value (amongs others).  From OLAP to relational, it should sort things out in converting the dimensional MUN to a relational value automatically if you choose the data item option.

Just be aware that in some cubes, the identifier of each member in the MUN is different from the caption of each member which is displayed in the report, so you will need to make sure you are filtering on the correct value in your relational target report.

Best regards,

MF.