cancel
Showing results for 
Search instead for 
Did you mean: 

How to get all months for a Year in Web I Report

Former Member
0 Kudos

Hi,

We are using BO XIR3.1 SP3 enterprise version.

I need a report for current year from Apr to March.But for some selections the report is coming from May to March based on Posted Values in BI.

Please reply the below problems.

1)For some months nothing is showing.I want to show 0 in case of blank months data?

2)I need the report from April to march for every year even though there is no posted values for Apr or Some other Months.

Can you tell me what way i can solve it?

Regards,

Venkat

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Venkat,

You can check with options called as 'show rows with empty measures' or 'show rows with empty dimensions' for showing all the months in the year.

you can use 'is null' and then display 0 where there are no values.

Let me know if that is not helping.

-Ashish

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

   create Month and other related dimensions as different data provider, and then use merge dimension concept to merge the related dimensions. For eg: D1,D2,D3,D4 dimensions as one data provider and D1,D2,D3,D4 and Month as other data provider. this will help you to display all the months. if this is not helping you, i can give you the screenshots. Please let me know.

Thanks,

Murali.

vinay_lohakare5
Contributor
0 Kudos

Hello Venkat,

When you select the table, on left side you will have the table propertis.

In the properties select

Show rows with empty dimensions and

Show rows with empty measures

This should help you.

Thanks,

Vinay

Former Member
0 Kudos

Thanks Ashish & Venka,

2)Displaying 0 instead of null values has solved using Isnull Function.

1)But the above options Enable of " Show rows with empty Dimension and Measure", didnt give any changes in the displaying of all months in the report.

I dont think in BO InfoView itself it can be solved.

Can you suggest ,if i do any changes either in BI Qwery level or Cube level then i ll get the desired output in BO Report?

Or Can i get it just by doing changes in BO Report itself ?

Thanks & Regaards,

Venkat P

Former Member
0 Kudos

Hi Venkat,

It is better to change this @ BEx ot Cube level.

PLease ask this question in BEX forum (http://scn.sap.com/community/business-explorer)

THanks,

Raj