Month names on SAP Lumira when no values

[Former Member]

I am trying to replicate Webi charts to  SAP Lumira , I have Month dimension in 1 Query and merged TIME dimension from another query  to get month names on X-axis even though there are no values for months. Wanted same in Lumira, so linked with Month dimension from 1 data source to another data source  with Month from TIME dimension and used to Month from TIME dimension on the Chart, but I don’t  see months where there are no values.

[former_member155146 · Accepted solution]

Hi,

This is currently possible with Line Timeseries chart.

Thanks

Pramila

[Former Member · Accepted solution]

Can you explain in detailed..

[former_member155146 · Accepted solution]

Hi

We get all month names on X-axis even though there are no values for months by using any timeseries charts , it takes the date value or date hierarchy as continuous axis and creates the chart . Currently this is not possible with columns chart.

Ex:-I have the data for Jan ,Feb,Mar,Jul,Aug,Sep,Oct,Nov and Dec, But I don't have the data for Apr,May,Jun, It is possible to render all the months in the chart on X-axis., Find the screenshot below for the same.

Thanks

Pramila

[Former Member · Accepted solution]

When there is no value its breaking in the line, User needed to show 0.

So, I tried something like this in the calculated measure,

if {Measure}= 0 then 0 else {Measure}

but still breaking in the chart(see attached)

[former_member155146 · Accepted solution]

Hi

Try if IsNull({Measure}) then 0 else {Measure},

We have to use IsNull, The reason is empty values are null values not '0'(zeros)

Thanks

Pramila

[TammyPowlas]

Cristina:

Would you please share more details:

1) version of Lumira

2) data source - universe?

3) Screen shots of how it looks in Web Intelligence and how it looks in Lumira (use the camera icon to upload images)

Thanks

Tammy

[Former Member]

Version 1.30, Data source - universe

[Former Member]

Try changing the Month Dimension to Detail