Home » Fusion Middleware & Colab Suite » Business Intelligence » Linking pivot tables in a dashboard (Oracle BI Answers)
Linking pivot tables in a dashboard [message #488998] Wed, 12 January 2011 16:16 Go to next message
j052018
Messages: 2
Registered: January 2011
Junior Member
I have two pivot tables in a dashboard & would like to know if it is possible to update both tables when selecting a page item in one. For example, Pivot A shows sales by region and Pivot B shows salespersons by region. If I select a region in the page section of Pivot A, I would like to have region in Pivot B page section updated to the same region. Is this possible, or is there a better way to accomplish this?

Note: I am also showing ranking across all regions in Pivot Table B. I tried using a filter to accomplish the purpose stated above, but found the ranking was then only for the filtered region & not across all regions.

Any info/assistance is appreciated.

Re: Linking pivot tables in a dashboard [message #489165 is a reply to message #488998] Thu, 13 January 2011 10:43 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
In version 11g you can (although i would have to test it in detail, but i am pretty sure it should work), in version 10 you can not.
Re: Linking pivot tables in a dashboard [message #489328 is a reply to message #489165] Fri, 14 January 2011 08:49 Go to previous messageGo to next message
j052018
Messages: 2
Registered: January 2011
Junior Member
Thanks very much, I believe we are using version 10.
Re: Linking pivot tables in a dashboard [message #489444 is a reply to message #489328] Sun, 16 January 2011 10:32 Go to previous message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Then the only option you have is to use a dashboard prompt on region.
Previous Topic: Can a hierarchy of columns from fact table be constructed?
Next Topic: Dim and Fact tables for a Banking domain
Goto Forum:
  


Current Time: Thu Mar 28 14:41:49 CDT 2024