Skip to Content

Can we apply filter on individual columns(measures) of crosstab in SAP Lumira Designer 2.0 ?

May 17 at 07:49 AM


avatar image

Hi Experts,

I have a requirement where, when user selects a 'Fiscal Period' from listbox(single select) then 'Budget' values(in crosstab) should come for all the periods while values for rest of the key figures should come for the selected period(from listbox)

Is this possible ??

My connection is Hana->Universe->Discovery->Designer

Thanks in advance.

capture-filter.png (35.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mustafa Bensan May 17 at 12:47 PM

Hi Manoj,

It sounds like your requirement is to display Current Period and Current Period Year To Date. You cannot achieve this by applying individual filters on columns. This type of requirement is achieved through appropriate backend modelling of the data source such that it provides cumulative measures as well as current period measures, with a variable prompt for allowing user-defined period selection.

Can I ask why you have taken the connection path of: HANA->Universe->Discovery->Designer instead of HANA->Designer ?



Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Mustafa,

Yes, the requirement is such that for some measures it should be Current Period and for rest it should be Current Period Year To Date.

I have used this connection path because we had to create some extra measures(calculations) and do some data preparation at front end. And also we had to leverage some of the features of Discovery(Interoperability)

Is there any difference/change in Designer behavior(features) if connected directly to Hana ?

We can create two crosstabs, one with Current Period data and other with Current Period Year To Date data, and if we can merge/union them then that might work. But don't know how to do this?