on 01-11-2012 6:52 AM
Dear Masters in SAP BPC,
I am a newbie on BPC Netweaver, I am doing practices follow by SAP BussinessObjects Planning and consolidation (Sridhar Srinivasan and Kumar Srivinasan) .
At chapter 5 , I made a report as below:
create a report : click BUILD A REPORT USING A DYNAMIC TEMPLATE
select SUBTOTAL BY ACCOUNTS(TREND) and open it
I can not choose multi dimension and ALL RB Products, I chose 2009.TOTAL
and then : I choose CY7000, 2009.TOTAL
when I show reports but no value to show on report, I check on BI , data is ok
I ignore this case, I continue with other report, using EVDRE,
in colume: TIME,
in ROW : RB_ACCT
member set : SELF, DEP
but the result the same before report.
Please help me the way that I can show data on my report.
Thank you so much for you help
Best regards
Chinh
Hi,
The data which is displayed in the report depends on the page key range, and the combination of the row and the column.
If the data is not available in the report, then check the content of the cube created by BPC application. You mentioned that data is available in the BI. Have you checked the data in the cube that is created by the BPC application? Do you have data in this cube? If yes, select a data region, and use the same region in your BPC report.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you nilanjan chatte,
I check on BPC already and data is being there.
when i chose member set BAS and expand all then some month have data, but on Quarter is not yet.
Ex: in 2009.DEC have revenue : 80.000 but 2009.Q4 is empty, and 2009.total same 2009.q4.
So when I set member set is SELT, DEP then data have not showed.
Do you know why?
Thanks for your reply.
Regards
Chinh.
Hi,
There can be various reasons.
1. The total of the base members of Q4 might be 0, so Q4 is showing as 0.
2. If the acctype of the account is AST or LEQ, the value of the parent member is always equal to the closing period. Suppose, you are following a calendar year of JAN to DEC, then the value of Q1 will be same as MAR.
Hope this gives you some lead.
This is my data when I set memberset of TIME dimension:
TOTREV Total Revenue 28,000.00 72,000.00 20,000.00 80,000.00
REVENUE Revenue 28,000.00 72,000.00 20,000.00 80,000.00
REVADJ Adjusted Revenue
Edited by: Pham Chinh Thi on Jan 11, 2012 10:23 AM
Edited by: Pham Chinh Thi on Jan 11, 2012 10:24 AM
Dear All,
My problem is resolved. Data can not display because when I load data , I did not used right pakage.
I have to use Load infoProvider data with selection UI but I didn't do that. I selected load Transaction data from InfoProvider.
Now, I modified it already. It's ok.
Thank for your comment. I greatly appreciate your help.
Cheers
Chinh Pham
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.