Thansk all for your suggestions. So we are sying, it is not possible to achieve dependent prompt in OBIEE?

Thanks for your rsponce. I agreed with you.But we are using an OLTP query and thats why we are using DDR. Is it not possible to achieve dependent prompt in OBIEE? 

Thanks for your reply. But we don't have the model in RPD and we are creating a DDR. That's why we are using EXECUTE PHYSICAL CONNECTION POOL " ABC "."XYZ" in prompts. In this case how we can achieve it.

Thanks for your suggestion. We have an analysis of around 5 dimensions and 4 measure. We need to calculate a measure in this analysis with the rate(Measure*rate). This rate is the rate for the maximum period from the selected prompts. Period Prompt(Varchar) is having values like JAN-15, FEB-16, MAR-16. I tried it with a…

Hi Experts, Any Syggestion.?

Thanks.

Thank you. I am able achieve it. Joined relational database and cube in RPD and using relational column for commentry. Thanks,

I am working with Oracle on this issue , And will update this thread

Thanks, Any help on how t create a dimesnion in OBIEE cube? we cant extra dimesnion in Essbase.

Thanks for your response. I am not able to open this blog. Are you? On oracle support we found that we need to flattern measure hierarchy.But in my case, business dont want flatern hierarchy. So any other solution?

12.2.2

Hi experts, Anyone got any luck on this?

12.2.1.2.0

OBIEE 12C(12.02)

Thanks a lot, Its done.

any suggestion pls

we do have group by and measure area, where you want me to put sorting column.?

Thanks Gianni, We are using 12.2.1.2.0. i placed it before dim ,but no luck

Thanks Joel, Filters are at run time from presentation layer.

Thanks, How we can count number of ',' in presentation variable?