on 01-13-2015 7:07 AM
Hi,
We are using BPC 10 in that as per the Client requirement for Consolidation we created a new Time Period 2013.00 (Opening Period of 2013)
Now when we are extracting the report I am unable to see any aggregated data for entire year from (2012-2013) inside 2013.00
As I can only see the data at Base Level and not for any Members & Children.
Now I want to see the proper aggregated data with proper hierarchy what changes are required in Time dimension or any other changes are expected?
Please help need your guidance.
Regards,
Ravi
Hi Ravi,
Please, show the screenshot of the TIME dimension in the administration!
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi,
As suggested by Vadim, create 2013.Q0 with parent 2013.TOTAL and child 2013.00
The values for member 2013.00 and 2013.Q0 in calender (HIERARCHY) is 2013.Q0, 2013.TOTAL respectively
Your dimension members as bellow (members highlighted in red color)
ID | CALENDER |
2013.01 | 2013.Q1 |
2013.02 | 2013.Q1 |
2013.03 | 2013.Q1 |
2013.04 | 2013.Q2 |
2013.05 | 2013.Q2 |
2013.06 | 2013.Q2 |
2013.07 | 2013.Q3 |
2013.08 | 2013.Q3 |
2013.09 | 2013.Q3 |
2013.10 | 2013.Q4 |
2013.11 | 2013.Q4 |
2013.12 | 2013.Q4 |
2013.Q1 | 2013.TOTAL |
2013.Q2 | 2013.TOTAL |
2013.Q3 | 2013.TOTAL |
2013.Q4 | 2013.TOTAL |
2013.Q0 | 2013.TOTAL |
2013.00 | 2013.Q0 |
2013.TOTAL |
Shrikant
Hi Shrikant,
Thanks for the detail reply.
But here is where I am getting confused my report contains data of 2012-13 i.e from 2012 April to 2013 March.
Also as per the guidance I have been suggested to add it as "2013.TOTAL"
Currently I am aware that my period which is been defined as 2013.00 has calendar "2013.TOTAL".
So should I change it and include it as "2012.TOTAL" ?
Regards,
Ravi
Hi Ravi,
Why do you require 2013.00 as opening period ? any specific requirement?
Bellow is the standard structure of TIME dimension having 12 months , 4 quarter, for 1 year .
ID | PARENTH1 |
2013.01 | 2013.Q1 |
2013.02 | 2013.Q1 |
2013.03 | 2013.Q1 |
2013.04 | 2013.Q2 |
2013.05 | 2013.Q2 |
2013.06 | 2013.Q2 |
2013.07 | 2013.Q3 |
2013.08 | 2013.Q3 |
2013.09 | 2013.Q3 |
2013.10 | 2013.Q4 |
2013.11 | 2013.Q4 |
2013.12 | 2013.Q4 |
2013.Q1 | 2013.TOTAL |
2013.Q2 | 2013.TOTAL |
2013.Q3 | 2013.TOTAL |
2013.Q4 | 2013.TOTAL |
2013.TOTAL |
If you want to add 2013.00 in total year then assign parent 2013.TOTAL to it.
Shrikant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for your reply.
As per the Consolidation activity requirement all the data will be moved to the Opening Period of 2013.00.
But when we are looking at the Consolidation BS Report for Opening Period 2013.00 there is no Hierarchy and I can only see the data at Base Level i.e GL.
Below is the config for 2013.00
ID | Description | Base Period | Level | Month Number | Period | Time ID | Year | Calendar |
2013.00 | Open 2013 | 000 | MONTH | 1 | OPEN | 20130000 | 2013 | 2013.TOTAL |
I am very new to Consolidation so please suggest what changes are required in above period so that I can the Group level aggregated data.
Also we are extracting the Report for the Period 2012-2013.
So suggest the changes reflecting the respective year of 2012-13
Regards,
Ravi
Also to add the above information in SAP BPC 10 NW we have defined the Consolidated Model with Data entry mode as "YTD"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
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.