Drilldown Option in Calculation View

[mantrishekar]

Hi All,

I am creating a calculation view.

Now i need to implement a drilldown kind of functionality in Calculation View.

First i need to see Header Data and the respective sum of Items.

When i click on Header i need to show the detailed list of items and their respective price.

Is it possible to build this kind of functionality using calculation views or sap Lumira.

Please guide me.

Regards,

Shekar.

[former_member187410 · Accepted solution]

Just going thru the Demo Class Experience.. Requirement is Header and Item Level Material Data Display.

As per hana, if you do this drill down in HANA is better performance in comparison to doing at Reporting Level.

AUFK-PLNBEZ is material Header Data,

RESB-MATNR is material at Item Level,

Do the Union with same Fields- EX- AUFNR / PRCTR

** Create duplicate-columns for the Union Fields because union field will show all the values from two tables in 1 column -

**The duplicate Columns will show as header and Item level data.

** 2nd Screen shot shows the AUFNR, RSNUM, CLNT are used for union.

capture.png

capture1.png

[former_member187410]

Hi,

Yes you can do That.

Example,

BOM -

Header Material

Item Materials

This can be achieved in HANA Modeling

[D039507]

Hi Shekar,

this is not part of the data modelling, this you have to build in the frontend-Tools like Design Studio or Webi or something else.

You only have to provide a hierarchy in a calculation view that can be used in the frontend-Tool.

best Regards

Thorsten

[mantrishekar]

Hi Thorsten and benedict,

First am creating calculation view and exposing this calculation view in lumira.

Now could you please guide how can i make a drill down functionality in lumira.

FIrst do i need to provide the respectiv ehierarchies in Calculation view or do i need to do this in lumira.

Regards,

Shekar.

[BenedictV]

The calculation view is not a reporting tool. It is a database information view. To get a drilldown functionality you would have to use a reporting tool on top of your calculation view.