cancel
Showing results for 
Search instead for 
Did you mean: 

I can't choose multi dimension member for report and summary by quarter

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thanks nilanjan for your help quickly,

Acctype is INC

Former Member
0 Kudos

Hi,

If its INC, then Q4 = total of its base.

What is the data in the base members of Q4?

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

It is very hard to read and understand the data which you have posted. Can you please format it and repost?

Former Member
0 Kudos

Here my data, please ignore last post

Total Revenue 28,000.00(2009.MAR) 72,000.00(2009.APR) 20,000.00 (2009.SEP) 80,000.00 (2009.DEC)

Revenue 28,000.00(2009.MAR) 72,000.00 (2009.APR) 20,000.00(2009.SEP) 80,000.00 (2009.DEC)

Former Member
0 Kudos

Hi,

Please correct me if I am wrong.

The issue is that you are able to see the data at the month level, but you are not able to see the data at the quarters?

Lets take the example of Q4. What are base members of Q4? Oct - Dec? Please validate from the time hierarchy.

Former Member
0 Kudos

Yes, you're right. I can detail

I am waiting data dispaly like as :

2009.Q1 2009.Q2 2009.Q3 2009.q4

TOTAL REVANUE 28000 72000 20000 80000 the same revenue

because Q1: (JAN-MAR) Q2: ARP-JUN, Q3 : JUL-SEP, Q4: OCT- DEC

but now, my report show nothing

Former Member
0 Kudos

Hi,

If 2009.JAN and FEB doesnt have any data, then 2009.Q1 should be equal to 2009.MAR = 28000.

Can you try to process and optimize your application?

Former Member
0 Kudos

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