on 05-19-2012 10:45 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.