nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Column Group Drill

3195949

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):

Find more posts tagged with

Accepted answers

All comments

choracy69

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:

3195949

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

choracy69

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

3195949

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

Thomas Dodds

HOW did you create your group?

3195949

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

Thomas Dodds

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 ...

3195949

Besides doing dimensional hierarchies on the rpd, how would l set relationship between a summarized report and it's action link drill? Plesae advise

Thomas Dodds

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.

3195949

That makes sense, thank you on your advice - l will work on this and will keep you posted.