cancel
Showing results for 
Search instead for 
Did you mean: 

Lumira Designer - how to create variable a variable number of crosstabs based on 1 datasource

former_member206621
Contributor
0 Kudos

I created a universe which has the following result:

In my Lumira report I have to create a crosstab per category (in my example 2 categories, this is a variable number). How can this be done? If I create a new datasource for each category (via scripting) I always get the error "data source is not initialized".

Kind regards,

Lieselot

TammyPowlas
Active Contributor
0 Kudos

Hello Lieselot - I am wondering if an array might help? See https://archive.sap.com/discussions/thread/3889894

I am not using universes so this is just a guess

former_member206621
Contributor
0 Kudos

Tammy,

I am now using the following code in my script - I want to assign a part of the original datasource to each crosstab (with filter on category). But when I use ds_dynamic = DS_1 all properties of DS_1 are copied so only the last category is taken into account for all created crosstabs. How can I create a new datasource which is a copy of the original one but with a filter on category?

Kind regards,

Lieselot

Accepted Solutions (0)

Answers (1)

Answers (1)

josheuesden
Explorer
0 Kudos

Hi Lieselot,

Hopefully you have figured this out now but there is an example here which should help you do it:

https://blogs.sap.com/2017/12/19/dynamic-apps-in-lumira-2.1-iterating-over-a-resultset/

Kind regards

Josh