Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Column Group Drill
I created a column grouping to show a group total e.g. A =100, B=1200 and the group in AB - Total =1300. Using action link l can drill into another report and see A & B seperately but when l click on AB - Total l get no resultscbdcd150323941673__@@#$__cbdcd150323941673_g1
I am using OBIEE 11.1.1.7.1 31017
I am suspecting there is something l need to do on the column filter.
- 8 Views
- Categories: Answers/Dashboards (Presentation Services)
- Tags (edit):
Answers
-
Hi,
I have the same problem when I created manualy SUM for columns.
I don't remember which version it has been entered, but you can automatically turn on the drill for a grand total:
0 -
I tried that and it doesn't seem to work. Thank you though for your response and we're on OBIEE 11.1.1.7.1 31017
0 -
It doesn't work? Maybe, can you write something more? What doesn't wokr? Some error?
I use this option in a single analysis and working properly on 11.1.1.7.131017
Short description: BI Direct: OBIEE 11g Release 11.1.1.7 – Navigation from the Total or Grand Total in a Table or Pivot Table View
0 -
I created a Column Grouping giving me a sum of the items in the group. I can click on the items individually to an action drilled report but when l use the grouped name l get the error as shown below
no results cbdcd150323941673__@@#$__cbdcd150323941673_g1
0 -
HOW did you create your group?
0 -
Using the New Group icon in the results section
e.g. Dep A = $100
+ Dept B = $250
then Creating Group for Dep A&B Total = $350
Having an Action linked report, l can drill on Dep A and see the details but when l drill on Dep A&B Total l get the error
no resultscbdcd150323941673__@@#$__cbdcd150323941673_g1
0 -
You are creating that group at run-time (after the query data has been retrieved) and the BI server doesn't have keys (logical or physical) to perform the drill at that point ...essentially drilling is based on the concept of granularity of data not on the grouping of data ... so if you need this group to be drillable, you need to build the relationship of the group to the details in your data.
USE of information DRIVES data model DESIGN ...
0 -
Besides doing dimensional hierarchies on the rpd, how would l set relationship between a summarized report and it's action link drill? Plesae advise
0 -
Master-detail, navigate to BI content, drill, etc ... all are predicated on real data ... adding your own groupings at run-time is a disconnected (for lack of a better term) approach to the underlying data (whose relationships are maintained in the storage of data; your sales amount is stored with a date key and a customer key and a salesperson key so that you can relate amounts across time, customers & sales reps); Making you own grouping of sales reps = 'my buddies' is great and all and should be used to make informative decisions; but navigation / drilling is based on keyed relationships within the underlying data.
0 -
That makes sense, thank you on your advice - l will work on this and will keep you posted.
0