Hello Joel, The OBIEE version is 11.1.1.7.160119. Caching could not be an issue because the numbers are right but not the Grand Totals. Thanks DNK

If you are trying to put the analyses on the dashboard. Please create a dashboard prompt and you can search internet on how to create dashboard prompts in OBIEE Thanks DNK

Hello, Is there any reason you kept as Assumed answered.Do you need anything to confirm on this?If not please make answered and close the thread. Thanks DNK

I fixed this issue by adding a new field(State_County) in the base table (COUNTIES) and updated the Theme (THEME_DEMO_COUNTIES) using the mapbuilder and purged the metadata from mapviewer console.Then I could able to see the new field under layer key. Thanks DNK

Hello If your goal is to pass value from summary to detail which are in OBIEE why do you need to use gourl? you can simply put an action link on the field you want and put is prompted for the field in the detail report and you should get the right results. Thanks DNK

Hello, You can pull the Hierarchy itself to Presentation layer and create your graph from the Hierarchy itself (not the Hierarchical columns)then you would achieve the functionality you want. Below is the sample screenshot Thanks DNK

column Reporting line? what do you mean by that. Can you explain Thanks DNK

Are you sure the presentation server and http is running? Thanks DNK

May be you would check the other application roles related to consumer not the content author.content author will give privileges to create and edit analyses. Thanks DNK

It would be easy if you can attach sample xml and template so that we can try to help you. Thanks DNK

Please use Dashboard URL for this and pass the prompts as presentation variables.It should work. Thanks DNK

Thank you So in 12c you can edit that field? Thanks DNK

Hello, thank you for your reply. I have got to select only from the drop down(can't edit to concatenate).So, that means need to update the key from the mvdemo tables?.Not sure which tables to update. Thanks DNK

Hello, I have created a hierarchy in rpd and created analysis with 2 fields State and amount and filtered for one state in the results I got the result. when I clicked on the State it drills down to all the Counties in table view with Amount. But when on maps it is showing all the Counties from all states with same amount…

Thank you ! Yes, I was talking about Maps. Sure will fix the RPD with Hierarchy set up on that dimension and will test it. Thanks DNK

Thank You Gianni! for our reply. Actually, I did not have any dimension hierarchies setup in the rpd as of now. Do you think setting up dimension Hierarchies with right logical level keys will fix the issue? Thanks DNK

I did the samething as you mentioned earlier!

Thank you Asim, I figured myself last night! BTW, Can you help me how to close this discussion? DNK

Thank You .This is not straight forward.Actually I am doing a Sum after the Count of some condition on that row is happening. Something like Sum(Count(Case when Condition)) once I get the total sum, I can filter that for that row by other rows. This is more like a transactional report so no Hierarchies are properly…