Hi,
By default, In WebI repots when we activate drill option; dimesnions and corresponding measures gets underline hyperlink.
When dimenion is clicked, it drills down and drills up through up arrow, irrespective of the number of dimenions used in the report.
If 3 dimensions have hierarchy, then all three dimensions' drill will get activated and measures against them will also get hyperlink. for e.g.
Dimension1 2 3 Measure
Clicking on individual dimensions will change the measure value depending upto how much level each dimensions are drilled down/up. Whereas, if measure is clicked all thee dimension will be drilled down for that measure.
Our requirement is as follows:
1) Clicking on measure should not drill down all the 3 dimensions but we need to configure which dimension should drill and which not. Clicking on respective dimension is many click event, user wantst to have single click to get results.
2) Measure has subtotal and total. Can total and subtotals be drilled up or down? By default, any SUM doesn't have drill hyperlink activated. Are there work around or solutions?
3) I have Region hierarchy (Region > Country -> City -> Town) stored as seperate columns in DB in single table, as follows:
Location id Region Country city town
location id is mapped to town as town are not repeated whereas other columns will have repeated values.
We have requirement to display all 4 values in single column in report, grouped as follows:
town1
town2
- City1
town21
town22
town23
- City2
-- Country1
-- Country2
Somewhere town will be missing in that situation aggregation ofr those towns will on City level and same at higher level. User has requirement to show data for few towns or few cities then we need to display all other data as others