0:05 Hello everyone, welcome to Zarantech. In today's fast-paced business environment, effective planning and budgeting are essential for success. SAP BPC 10.1 offers a robust solution for financial planning, consolidation, and reporting. Let us dive into SAP BPC 10.1, a vital tool in the realm of enterprise performance management. SAP BPC 10.1 [music] stands for SAP Business Planning and Consolidation Version 10.1. In simple terms, it's a software solution designed to streamline [music] financial planning, budgeting, forecasting, and consolidation processes within an organization. SAP BPC 10.1 delivers significant benefits. A 70% [music] cut in budget cycle times and a 50% drop in financial close [music] times. This translates to enhanced efficiency with real-time financial insights. Decisions are made swiftly, driving strategic [music] growth. In this course, we'll 1:06 cover everything you need to know about SAP BPC 10.1 from its core functionalities to practical applications. We'll walk you through step by step. Get ready [music] to unlock the full potential of this gamechanging tool. But before we begin, please subscribe [music] to our YouTube channel and hit the bell icon to receive regular updates from us. Now, let us look at the agenda. Agenda one, overview of BPC. Two, strategy and road map. Three, modeling aspects in BPC. Four, versions of SAP VPC. Five, configuring environments and dimensions. Let's dive in. >> So, first of all, we'll understand what is BPC, how BPC come into existence, what are the predefined functionalities available before BPC and why SAP has taken BPC into picture. Okay. [snorts] So, first thing first, so 2:10 we'll see BPC. BPC stands for our business planning and consolidation. So business what kind of business it would uh ask for and how the business will work in the BPC scenario. How the plannings are work since in FI or if in BW also you we will have some kind of plannings and all interfaces. But why we are choosing BPC not BW? Why we are choosing means why [clears throat] BPC is a superior as compared to other planning modules and consolidation? Consolidation will deal about my interco company eliminations and journal postings as well as my ownerships and others. So why we are doing consolidation as well in the BPC part. So we will discuss this in our today's session. Our agenda for today's meeting is introduction to BPC and under this we will expl understand understand how this came into picture. What are the advantage? What are the disadvantage? How to achieve the our final goal with a BPC point of view. Okay. Under this uh 3:11 one we have some we have included some examples okay to provide a purpose in purpose scenario. Okay. So though it is not a 100% confirmed scenario so just we have tried to provide you an example okay of the via images and others so that it will work in our perspective in our direction okay so BPC stands for business planning and consolidation okay so I will provide an example okay suppose tomorrow we'll have a forecast or that tomorrow rain uh means thunderstorm will be there or rainy actually it's quite rainy Okay. And you need to step out to market to purchase your goodies or vegetables or something. So what are the first what uh what what are the first thing you will carry when you are heading to market? Do you have a forecast that it's a rainy season and you don't have an umbrella or you don't have anything to cover up? So what are the things which you will carry or what are the things which you will have in your mind when you uh think that yeah 4:14 tomorrow I need to step out to market and I need to purchase the goodies or vegetables. So first thing first what I told you is we don't since I don't have an umbrella or anything okay to carry. So what happened first of all the forecast will happen. Okay. So once the forecast will happen then means first of all we have we have planned that tomorrow I need to go to market and then I will I check the weather and then the weather the forecast that tomorrow is a rain so first what I will do first thing is like first we have planned first planning will come followed by the forecasting and since we don't have an umbrella then what we will do is we will allocate a budget that yeah I need umbrella for like $20 $10 $30 how what it is okay so first of all uh the planning will come. So under this planning we will do the planning for the forecasted versions and under the forecasted versions we will do the budgeting. Okay. So these are the basic three pillars of the BPC. Planning, budgeting and forecasting. 5:14 So under this uh this is my planning, budgeting and forecasting. Okay. So see there are different kind of planning as well. So if you are doing budgeting in any domain like in Oracle, in UI, in uh finance or in BW, in any domain, if you are doing any budgeting, first first thing what we need to see is our historical datas. Right. Right. Our historical datas, our historical figures that how the historical data, our historical figures are different and uh what are our predictions going forward, right? This is what we are planning, right? based on our historical data to forecast the values and based on those forecast figures we are doing the exact budget. Okay. So this is how BPC also works. Okay. So first the planning will take place and after planning the budget will come and the budget and then forecast will be there. Okay. So it is a single view of financial and operational data. So when I say a single view so what does this means? If you'll go from top up 6:16 approach or bottom up uh bottom down approach, it is a one specified solution to your input and output of the data from one end to other end from or from the last to the first. Okay. And the second question is why BPC came into existence? We have different different modules as well. Okay. Where we are using the data like Fury or BW or finance then why BPC come into picture? So since uh during introduction I heard that some of you guys from finance domain and record domain also. So we have these things also in different different system as well or different different client interface as well. Then why we are reading BPC on this one means why BPC is different as compared to other clients. So see there is a slight difference mean BPC uh means why BPC is like see everyone right now in front of us they want to see the front end right? We are not interested in our backend system. If someone will say I want to 7:16 see uh something like a report or something, I will not quickly go to BW and log into GUI and say that boss see this is my report how it looks like. We have 10 different different buttons. Okay, if you want to update anything, you can press this. If you want to reload anything, you can press this. If you want to do a process chain work, you can do this. Okay, so and this looks very cozy. If you will see the uh one where uh one screenshot which which is there over here in the chat. So in the chat also if you have uh shared me the install software one. Okay. So here if you could see uh the component release splinding up in a single frame. Okay. Means everything is there and I don't want this unusual information like SP level. I don't have any ID on SP level. I don't have ID on support packages. Okay. So all thing are coming in a single gateway and I don't need these things because for client I don't need this thing. I just want my values. I just want my dimensions. I just want my module or I 8:17 was I just want my interface. Okay. So BPC will provide you a flexibility that what data you are having it will come directly to your system. Okay. So let's take an example. So uh if you will go to different module you will see a b c d. So we suppose a b cde e and their values are suppose 100 and this value is 200 this value is 300 this value is 400. Okay but if you will go over here the patch number also written a1 and this patch number is b1. Let's example path number is C1 followed by this is G1 and different support values means ABC is something some values are also written in our uh BW1 okay or different different domain okay but if you will see this is our backend system or if you will see from client point of view client doesn't require these datas right so client is concerned 9:17 about this data only he don't want this data that I want to see this data how the patch version is working how the client interface is working and how the values are working. So what VPC will do is BPC will put a filter that what data you want to use. Okay, we will just filter that data and we will show that data to you according to your need. This is how BPC is. Okay, if you'll go to ECC and others, so you will have 10 different different columns. Okay, under those 10 different different columns there arely four to five columns which are for our use not more than that but we need if we need to uh open that and if we need to hit the target it will come like 10 different to 20 versions like thousand of record thousand of record and I don't have anything I don't want to see all the thousand of records at a time I just want to see like yeah was for this XYZ cluster like APEC cluster EMIA cluster or different XYZ cluster so what I will do is just I will filter APE cluster. So under this I will 10:18 see 10 different different reports that's it from my side. If I want to see EMIA cluster I want to see 10 different things that's my side. Okay. So this is how BPC will provide a flexibility. Okay. So before introduction to BPC what we are doing is we are doing reporting and all in BW format only. So under this BW format also we have variet kind of reportings and everything. But the thing is there is no flexibility. what is there in the system that is what is getting populated in our front screen and we don't and to be frank we don't want these values we just want the values which we are using so after that what happens so it will lead to like data duplication as well means lot of data different chunks of data and all so then BPC come into existence and under this BPC they say that yeah this is a front end one though BPC don't have a support system okay so it is fully relying on our BW1 okay that's why we are doing the mapping and all okay so 11:19 what we did is we like we have done the transformation like mapping that boss we want these datas only so bring those datas so that it would be good for me as well and for system as well so the advantage of BPC is first would be my memory okay so we we will use less memory okay and second one is my flexibility one is my time complexion so these are the means more important scenar scenarios while introduction to BPC like the memory suppose if you will see open any report it will take in BW it will take like uh 10 MB or 5 MB caches and all okay in BPC if you will made a filter and open a report it will probably take one or 2 MB of the values memories okay so the remaining CPU load will be get distributed as well 3 MB that's why BPC is faster as compared to my BW okay second one is my flexibility it provide you an additional flexibility to filter the values based on your requirement. Okay. [snorts] Or filter 12:20 the values based on your requirement on the columns as well. Time complexity. If you want to make any changes in the value with limited appropriate time, you can just change the value in the front end. And if you want to reload the value in BW, then you can push the BPC value to BW. Okay. So this is how BPC come into and these are the advantage of BPC. See uh under BPC in BW if you will go to BW we will have lot of uh columns and rows. Okay. So while hitting the rows and columns so it will show me all the existing values which are available in the screen. Okay. There is no filter in the data. Right? But in VPC while during transformation only if we made a filter that boss we need these XYZ values in my report XYZ report. So what I can do is if uh I put filter so BPC will pick up only those values and it will show the value with that combination only. Then what will happen the memory uh power 13:22 means earlier in BW it is taking suppose 5 MB of data 5 MB memory. Okay. Then in BPC it will take hardly around 1 or 2 MB of memory. Okay. So that's why it is faster and it provide me a flexibility as well on the data mean if I want to show the actual in a grade out version that we can't input any values. So actual would be in grade out version and planned if I want to show my planned value is in my uh edit ready version. So we can do that also in the report as well where different different formats and time complexion here it will take less time while executing the report as compared to my BW. So that's the case BPC is much more faster and flexible and these are the advantage of BPC as compared to different different modules that's why we are using BPC as a front end and BPC is that much popular over here. So this is a technical one. Okay. So technical guy will understand these parts very clearly. But from business point of view they will say I don't care boss I just need this X by Z thing. So 14:22 how you are maintaining whether you are maintaining in HyperD and Fury or BPC I don't care. I just want to this simple simple kind of data. Okay. So let me be clear on this point in functional view. If suppose business wants to lock any version locking we can't do any unlocking in our BW version directly but in BPC we have data locking version if suppose business want a value business change the value of a from 100 to 500 and business want that yeah boss I I don't want anyone to override this value so what business will do business will go to a will sell and he will lock the value like that so that no one will able to make any changes is whether any technical guy is there available or any functional one. Okay. So BPC will explain you this locking functionality and that difference different would be my version. So BPC if suppose you want uh XYZ version is there. Suppose there are 15:24 different different versions like actual uh forecast. So what we will do is uh if suppose uh we want to copy a version from actual to forecast in BW what we will do we will just go to actual we will copy the value and we will paste the value in forecast but in BPC with a one click or one short we can copy all the actual value to forecast and if suppose business want all forecast value business said that yeah I have posted some 5,000 lines of my forecast value I just want those 5,000 forecast value to convert into my budget value. So business will just go to forecast tab and it will just click on the tab it will just copy my forecast value to my budget value. Okay. And third one is my user point user perspective. So under this user perspective how the scenario is like business suppose business want a cost center planning. Okay. So under the cost center planning in BW we have we need to go to the we need to remember the characteristics or key figures that both these are my key figures. These are my characteristics 16:25 and these are my cubes. Under these cubes, the data is coming upon and this is how I am looking. But in BPC, we don't need to go to three four different different pages or understanding of different different scenarios that yeah this is my report manual or we just go to a connection. We will go to a cost center report and once we'll go to a cost center report, we will able to see the cost center report full picture in the system. Okay. Okay. And if suppose business want to look at in quarter basis, monthly basis, yearly basis, three-ear basis, they can just select the time for Q1 for quarter month means m y. So like that they will do it will show the data in it will adjust the same data in the same excel format which is available in your screen from functional point of view. So that uh business will not dependent on the technical user that boss I need to call a technical user so that they can change the report from month basis to year basis or year basis to week basis or like that. So BBC will provide this much flexibility to a 17:25 functional guy to understand how the reports are working and if they want to make any changes in the data they can able to change the data and if they don't want to post the data they say that key boss I have a meeting at 1:00 and I don't want to show my end to end data from ECC to BPC what it is coming because I want to change my BPC figures since these are not correct in BW then what business will do they will just edit the value in BPC and they can show it to the business and they can push back the same value from BPC to PW and ECC forward as well. So this is the functional understanding and it it provide a simplicity and the standardization of all kind of reports with a proper channel and format. Okay. So I hope I am clear on this technical aspect as well as the functional aspect of VPC. So uh what I mean is suppose we have a meeting and right now I realize that yeah boss the value of a which is coming from BW all the way from ECC to BW to BPC is not correct. It should be 18:27 in my record it should be 300 but uh right now it is coming as 500 because what the value is coming in BWBPC showing that value only. >> [snorts] >> So what we can do is we can create a posting means we can create a posting of minus 200 in BPC only and we can just execute the report so that in the report it will show 300 to my one uh my scenario and we can crossverify as well with the system with the business whether this is working fine or not. And if they feel that yeah this is the correct one then we can push back the same data means we can export the same data from BPC to BW and do the further adjustments as well because we don't have time to go to ECC and run the process chain and once this process chain will get complete then we'll go to BW again run the process chain and do the transformation in BPC via DMPS and all. So we can do it like that also. So these are the functional and technical aspects of BPC. The difference between 19:28 BPC and Hyperion. So first and important thing is BPC stand is a standalone system. Okay. But Hyperion does Hyperion is not a standalone system. Okay. So what what do we mean by a standalone one? under this standalone system what we can do is uh if suppose we don't have we have some data in our BPC we can use that data but in Hyperion it is very difficult to use that data until unless it will not go to the data library okay and BPC will have more BPC will provide you a more complex report scenario as compared to my Hyperion in BPC if suppose we have four members like A B C And I want a report for one user to exclude this A in my report means to hide this A and uh means to hide this A and show this report. But in Hyperion I can't do this thing. If suppose a 20:29 dimension override like B come B uh right now it is B for me but for you if you want to change it from B to K we can do a dimension override functionality in Hyper uh in BPC but we can't do a dimension override row override access override functionality in Hyperion in BPC we can use a drill down functionality but in a Hyperion we can't use a drill down functionality okay so this is what makes VPC different from a Hyperion as well though both are same versions mean both are having same kind of functionality but there is a upper edge in BPC as compared to my Hyperion scenario. BPC is more of user uh defined one and Hyperion is more of technical defined one. Okay. So if it will have a user flexibility so it would definitely have a technical fun flexibility as well but in Hyperion is more of a technical flexibility is not more of a functional one. So I hope I am clear the difference 21:30 between Hyperion and Oracle. Let's come back to the slide. Okay. So it provides a single view of financial and operational data and a unified solution which supports performance management process to adjust plans. Adjust plan is nothing but the values which I told you that if we can adjust those values in a different version as well means for one thing I am I was saying but we can adjust the values and we can forecast and we can budget and we can close the cycle as well in BPC. In Hyperion we can't close the cycle. So closing the cycle we need to go to the interface and then we need to apply the lock and then we need to close the cycle. But in BPC we can directly close the cycle. So this is this is what BPC is all about. BPC is having basic three pillars budgeting, reporting, planning [clears throat] and this legal compl uh compliance is a new one or we can say since it was predefined in BPC so we can't count this 22:31 as a uses. So we can do budgeting and forecasting in a ease way. We can do the reporting and we can do the planning. So we can make a planning report also to a report normal report as well in BPC. If you want uh the suppose XYZ a planning report I want what I can do is I can create a version one V1 and I want that V1 should be my report for view only. Then we can also create a planning report to a reporting tool as well. So these are the advantages or uh overview of BPC. You can see that it will align the organization values and it will increase the profitability. It will improve the organization values based on the technical and functional aspects and it will strengthen the productivity productivity as well. So these are the inbuilt functionalities in BPC. So we'll discuss one by one what 23:32 what uh are these different different functionalities in detail. First one is my strategic planning. So strategic planning defined about the version and time that what kind of planning we are into and how the planning looks like whether it is month-on-month level, year on year level, day on day level, week on week level or how it is flowing. Okay. So under this strategic planning we will have a cost center planning, finance planning, revenue planning, budget planning, forecasting. Okay. So under this strategic planning different different kind of planning scenarios will come. Okay. So which will rely on M basis, YUI basis, day on day care means weekly basis. Okay. or under this strategic planning we can do a planning on granular level to a broader scope as well. So it depends if I want to show it to my 24:34 CEO one report to my CEO I will not go to a granular level and show that boss this is these are my values I will just show the higher values that yeah these are my value these are the allocations and how these allocations are working this is how uh we are working on this interface so this is what about strategic planning on a broader scope as well and strategic planning on the granular level it depends user to user so this is about my strate strategic planning and one more thing which I forgot to tell you under 11.1 we will have a patch version which will guide you as well that what are the things which are important while doing this planning as well if suppose for cost center planning we will have GL account cost center profit center then he will guide you as well that if you'll do y basis the report looks like this if you'll do month-on-month basis the report looks like this or if you'll do week one bas This is the reports look like this. So that uh business will have 25:36 an understanding that yeah if I will do like this and the value will get uh saturated by these values and value will get accumulated by these values. So like that. Okay. So these will come under my strategic planning. We have operations planning, business planning or XYZ different different type of planning. Suppose we have five six type of plannings available. Okay. So these will come under my strategic planning only and it will depend how we want to proceed a report whether it is on month- on-month basis, year-on-year basis or how it is. Okay. So for one planning we can show report on three different different format month on month, quarter on quarter, year on year. We can show it in a single frame as well, single report as well or if we want to divide the load we can show it in different different sheets as well. So it depends. So going forward we will see how we want to create any report or how we want to do any strategic planning. So today what we will discuss more about the theoretical part. Okay. So once I will get once you guys will get familiar with the theoretical part then we will start the 26:37 uh practical understanding and I will again explain this part also that yeah this thing what we have learned earlier. So this is why we are utilizing this and how we are utilizing this. Okay. So I know uh so while while I was saying that this is strategic planning these are the things the things will come into your mind that how these things will work in my system right now in the theory part it would be easy to understand but in the system part how the values are like that so no need to worry so I will show you that as well that on month-on-month basis on yearon-year basis how the things will be okay the second one is my budgeting so under this budgeting uh what we are having we are having different different budgets like P&L budget, balance sheets uh and for cost and the plan budget and different different budget. So under this we can do the budgeting on threeear basis, five year basis okay and yearly one as well reporting. So uh the budgeting uh budgeting reporting forecast they will also come into a planning perspective 27:38 only just the names are different though the functionalities are different that's why they are the different built-in functions available in SAP BPC okay so uh these are the key benefits which are provided by BPC so it allow the user to make better business decision okay by supporting what if analysis and allow to perform scenario based planning so like I told so what are the bas Bas on the scenario we can do the planning itself on that time particularly in the BPC. So BPC will provide me that much flexibility to upload the value or to change the value to reiterate the value or to design the value on a proper time frame. It allows you to collaborate data and thus increase accuracy. So what it will so the accuracy of BPC is more than 95%. So what it will uh do is it will provide collective data what we are using in the system and how we want the system to looks like or how we want a report to looks like or planning report to looks like. Okay. It help in aligning 28:40 your plan with strategic goal and decrease the cycle time. So decrease the cycle time is nothing but my uh month-on-month basis Y or year on or week on week basis or day on day one. You have an option to choose the versions. See PPC is basically into two versions. First one is my classic version. What we are learning we are going to learn on classic interface and second one is my embedded version. So under classic version what we are doing is we are doing the transformation and conversion. Okay. Under this transformation and conversion we are uh mapping the values from BPC to BW and we are fetching the data from BPC to BW. Okay. And if any conversion is there then we are doing the conversion as well to show that in the report. But in embedded one since it's a runtime system. So what is there in my uh BW screen is the same in my BPC screen as well. Okay. So in embedded one uh we can 29:41 use embedded while using RS plan. Under this RS plan we will have a planning scenarios. we learn different different planning sequences and also while running those we can use uh embedded one. Okay. So right now what we are dealing with is my uh standard one not the embedded one. So the key benefit that can be achieved by BPC is reporting business reporting analytic report forecasting budget planning predictive analysis improved compliance consolidation and BPF. So uh BPC um since BPC uh till uh before introduction to SACE BPC is a advanced go tool for using predictive analysis. But as soon as S sec introduced in the system, so the use of predictive analysis in BPC is becoming quite less because in SACE we will have a flexibility to use predictive analysis in our ways how it would be and system will also recommend 30:43 in SEC but in BPC uh the use is a very [clears throat] less since it's a new feature if you can compare in BPC but in SEC this is the older one okay so BPF will basically deal about your process owners and templates so what it will give you end to end picture though if you don't have any technical guy available in your available around okay so what you can do you can go to the BPF BPF will have two scenarios owner and receiver okay if you are the owner you can you can make changes in the report you can edit the report you can do anything if you are the receiver you can only view the report then What what it simply tell you that first you need to go to start open XYZ report. Open this template. Under this template you suppose it is in build phase you can make the changes. If you want to change the worksheet means plan or if you want to change the font or anything you can make changes in those things as well. Okay. So this is how the flow defines. Okay. So suppose that uh 31:46 uh report will connected to three different reports. So what you will say that once this uh process flow will complete then only I will start the another. So we can connect this four five reports to one process flow and then it will complete to us full scenario report of the final output. Okay. So this is how process flow works in VPC. Like suppose we have a one report like we have suppose 10 reports for cost center planning and we have a one bigger report for cost center planning which we need to [clears throat] show it to the director or CEO or CTO for further approval. Then we will not go and uh say that yeah these are my 10 different different report just do have a look. So what we will do is we will just in the first report we will check the cost and then we will check the trail balances we will check the values we will check the administrative values XYZ for XYZ scenarios we'll suppose have eight reports so just we will use the while BPF we will use the BPF and based on the BPF we can accumulate all the values in a single big report. So that is how BPF 32:47 works in BPC. So if suppose any step will be missed the BPF will get failed. Okay. So we can do it uh via uh means cluster level as well or we can do it via via version level as well or we can do it via year level as well. Okay. So this is about BPC. [snorts] So yeah this is uh the capabilities of VPC we can say unified planning and consolidation. Okay. Second one is Microsoft office and web reporting. So what we are doing uh what we are reading in uh standard one we will do it in MS office only and we'll do the web reporting as well in MS office only and the reports via web console. Third one is my budget and forecast. For budget and forecast values we will do the planning as well in VPC. Fourth one is my built-in financial intelligence. So built-in financial intelligence is nothing but my values uh like suppose uh user security locks and all. So this will come my this will come 33:48 under financial intelligence values like security how the security looks like like user team owner reviewer locking work status. So work status is basically we'll explain you about the lock status of a report. Okay. Whether a sender or receiver only need to unlock based on the output what he is having. Okay. So based on the output work status will work. How the reports look like if you make any changes in the entrant if you log the value. Okay. Then legal and management consolidation. Under legal and management consolidation we will have ownerships. We have intercomp elimination. We will have uh consolidation journal. We will have IC allocations, we will have US eliminations and different different scenarios and then SAP S for integration. So see what we are reading is like BW for uh BPC. Okay. And we have S for integration as well. So uh SAP 34:49 11.1 uh means BPC 11.1 will provide you flexibility to integrate it via S for HANA integration scenarios as well. And then come hybrid planning by SACE. So under SACE we will have a regression testing. We will have a hybrid planning for complex scenarios via story creation, canvas creation and different different data locking mechanism will work under SACE. So SACE is like a having an upper edge or you can say it's adv advanced version of SAP BPC. So these are the core capabilities like planning, budgeting, forecasting, consolidation as well as legal and management reporting. So these five are basically my uh core capabilities of BPC. So we can plan the value, we can do the budgets, we can use the forecast figures, we can consolidate all different different accumulated values under one and we can do the management reporting and analysis and for variance calculation as well or reconciliation as 35:52 well we can use BPC in a broader picture. See for this is for 10.1 uh means release plan. So uh 10.1 is mainly comp uh compatible with PW for HANA. Okay. BPC 11.1 also will come under this scenario only. Okay. And this is how the road map of release plan is BPC. So what we are reading is like net we one analysis uh service will be there but analysis is unfortunately come under advanced version means embedded one. It will not come under my standard one. BPC is my front end. There is nothing data will not get stored in the BPC. BPC is my front end. What data you want? We can take the data from BW and we can show it in BPC. BPC will not store any data. What data is there in SACE or any different different module as well. Now Fury, SACE or different different module. We can use BW only means HANA only. Dimensional data means master data will relate in BPC only. I'm just 36:53 talking about the transaction data. Since master data is like a limited data, right? It's not like a huge data. So it's like if suppose you have created 10 master data if you want a change you can just change two or three or five or 10 you will not change all the thousand of records at one site. So the master data is there in the VPC one web console I'm talking about the transaction one. So the transaction data what is there you will take it from HANA only. We not taking it from VPC or if you want in analysis we even we don't have any master data as well stored in analysis for office. In analysis for office what we will do is the what the data in uh BW4 HANA system we can just take the data we can just take the data via CDS or via aggregation view via composite providers and we can just use the data and we can just do the calculation on the fly and get the data give the give back the data again to the S4 system. So for analysis for off analysis services what you are saying so we will use those analysis service in our embedded one not in the standard one. So in the standard 37:55 one we will use EPM. So under this EPM we will have a connection server. So under the connection server we can use uh the master data while having different different uh models and dimensions. So strategy and road map. Okay. So under this strategy uh BPC strategy uh let me clear about this. So right now since everything is moving into cloud and other interfaces right. So BPC will also have some uh means uh scenarios which are moving into cloud as well like what we are using in SACE SAP analytics cloud. So there are high chances that most of the BPC functions or scenarios will get move in SA cloud in coming 3 to four years time frame. There are high chances because cloud will have at least right now cloud will have something like 5 to 10% of BPC acquaintance means what is there in BPC 38:57 that 5 to 10% will be there in cloud but while the introduction of cloud or patching of every 3 three months there are high chances that most of the BPC scenarios and process will get moved into SACE SAP analytics cloud though BPC Right now also BPC will have an upper edge. BPC will provide more flexibility and broader scope. Cloud don't have that much broader scope but SAP is planning to move all different different scenarios in BPC into SAC. So BPC will cater our two need. First one is my business plans and second one is my consolidation that is in central fin. So what SACE has uh what SAP has did SAP divided this BPC into two parts. This consolidation and central finance will move under group reporting and the planning full end to end planning will come under SAP analytics cloud. So SAP also divided BPC into two parts and they are doing their future ready for 39:59 planning and consolidation. But right now as well BPC is a single tech platform where we will use the planning and consolidation under one time frame and it will enable our organizations to strategize and plan different different scenario and analyze the scenario as well as optimize and close the results as well. But in cloud we don't have this in cloud will become like a da kind of scenario mean it's a full box under box you need to play what you will play around in the system but BPC will have a broader scope so since cloud is also developing so going forward after 3 to four years the cloud will also become a uh planning kind of scenario same as the BPC this is what I assume or SAP is assuming under it latest press note in February 2024 so BPC uh will enable organizations to better uh strategize and plan and optimize as well as close uh and disclose results to increase the revenue 40:59 and profitability. Okay. So here in BPC the profitability margin is bit higher as compared to other different different scenarios. So why it is because BPC is a single stop solutions for my planning as well as my consolidation need mean it will cater my planning as well as my finance under one roof. No other model in SAP will cater these two things at the same time. That's why BPC is having an upper edge. Second one model in the moment model future opportunities and update plan to seize new opportunities collaborate in context for better alignment and accountability. So it will collaborate with different different versions and modules for having a better uh means better alignment for the system data and configuration though we will have some duplication as well in the system but yet that will also get covered and [snorts] base planning on live transactional data. So live transactional database planning is 42:00 nothing but in my BPC embedded one. We we are not using the live transactional data format in my standard. We'll use the live transaction data in our embedded only guide the business. So it gain live insight into financial and operational metrics and simulate the impact of potential actions like various different different scenarios we can cater in the BPC uh based on the potential how these things are working on and how it will get impacted in the system. Discover what's profitable and what isn't to improve the bottom line. So we will think and uh we will understand that what are the scenarios which are important for us to work on and how the scenarios will work going forward in the BPC for a broader point of view continuously account accumulate consolidation and report to close faster with fewer errors. So there is a advantage of consolidation in BPC. So what is that advantage? If you will do 43:00 an ownership or IC elimination, it will reduce a few lesser error as compared to your FI as well. If you go to FI or CO, you you need to create latch items for doing the consolidation process. But BPC will not allow you to create any latch item. They will do direct end to end GL account IC elimination or consolidation based on the ownership ratios or ownership values. Provide realtime visibility during the period to act improve results. So yeah uh real time uh visibility means it will provide you a visibility of doing the uh values on m and yi and to see the results uh during that period and improve if we have any issue in the scenario. Right now we are in we are now entering into the tech technical aspects of BPC. What are the strategies? How the road maps are defined? Okay capabilities. So it uh it will streamline uh we have a streamline planning uh the key capabilities of BPC. 44:01 So I discussed this thing earlier like as well. So it is a streamline planning forecasting consolidation and reporting process in one environment. So how BPC is looks like I will show a glimpse like suppose this is my Excel. Okay I am omitting this for time now. Like suppose how the BPC functions. First one is my environment that this environment we will have different different uh dimensions and models. Then we will go to models. Then we will go to dimensions. Okay. Under this model and dimensions then we will go to reports creation reports planning and budget. Then we will go for BPF and work status. And then we will go for security. We'll go for security and then we will go for Excel uh for transaction data. So in Excel uh we will 45:05 have different different things like we'll go for package and then uh transactions uh means uh transaction files transformation files. Then we will uh we will have conversion file as well. Okay. And uh after conversion file we will have a list link list and then we will have after link list we will have reports reports. Okay. So I will explain. So model is basically my character uh means so this is my whole BPC interface BPC plan. So this is what we will read going forward in the technical aspect as well as the functional aspects as well. So uh here uh for mapping from BW to BPC we will do the mapping t from here only for 46:07 transformation file we will do BPC to BW mapping version also BPC to BW BPC only not BW package is nothing but uh my we will write process chains we will call the process chains in list is nothing but for my transaction data transaction data process chain. So this process chain will show me my clear one my update you suppose any new values are there clear update change uh then refresh. So this is my package one. So these are inbuilt functionalities in the package. Okay. This will come under my MD and under link list transaction data. Okay. And we we under transaction data we have run package as well. The run package we will have we what package we are running we can able to view those package in this one and those package will see whether 47:10 it will have a status as finished or not and if it is finished then [clears throat] we'll able to see the data in the report or planning and do the planning as well. So this is how about BPC planning looks like. calculation script will come after once we'll complete this report then this calculation will come if we do calculation on this so this is uh I didn't told about calculation because right now I'm just doing a transfer mean normal transfer from my master data and transaction data and showing it in report if you want to do any calculation we will write logic script so what logic script is there it will come after it will come here only okay this will come under this web console. I showed you this thing uh the model dimension this thing this will come under web console. So BPC will have a web console. So this will come under web console and what I showed you this this thing. So this will come under my Excel EPM for EPM. 48:12 [clears throat] So this is how BPC structure looks like here. Report means we can use the report via web console as well. We can execute it will show me the this report only. If you want to open it in Excel, we can use from here. But we will recommend users to open those reports from here only. Okay. So this is how a web console looks like in a VPC. So VPC will provide you enough flexibility and it will help you for a streamline planning, forecasting, consolidation and reporting process in one environment. It will increase the organizational agility like uh run multiple what if scenarios in real time and automate calculations allocations manual process for shorter cycle times. Uh it will have benefit from a businessowned and managed own solution and manage solution. It will leverage best-in-class for Excel plugins. Excel plugins is nothing but my uh EPM and analysis. It will improve the accuracy 49:13 of plan and financial data reporting and uh the plan and consolidation in single application built-in finance. So we can use this it will reduce the cost of ownership with single platform with realtime insight from S4 and BW4 HANA. So BPC direct update method you can see what we discussed. So what SAP has did is SAP has divided BPC into two parts planning and consolidation. The planning part will go to this one SACE and the consolidation part will go to group reporting. So under this consolidation we will have different different kind of scenario for IC elimination, ICMR, US elimination, GA, GAP, ownership ratios and under this planning we will have we will discuss we will have all the plannings which is available in BPC to SEC but the functions are very different and I personally feel BPC is much better as compared to SAC because I worked on SA group reporting SA BPC as well but BPC will have a broader scope but right 50:14 now SAP is a plan SAP are in a plan to wind up this BPZ solution going forward in 27 or 28 I guess I'm not sure because earlier it was for 22 or 23 but uh still it's running so it will be like 27 28 or I don't know whether it will increase also so there are four different versions of BPC first one is my BPC 10.1 net fever standard on HANA or Oracle IBM DB2 so BPC we can integrate BPC with Oracle as well via Oracle SQL as well via RFC connections. Second one is SAP BPC 10.1 native or embedded on HANA. So embedded is nothing but my realtime system. Optimize as for HANA is my native HANA. Fourth one is my 10.1 Microsoft version as well. So these are the different different versions of SAP BPC available in the system and these are the advantages and disadvantages. Planning, reporting and consolidation solution based on BW technology. It uh 51:16 we can design it designed to be used and maintained by business. BW and BPC integration need to be established. No full integration like same transformation and conversion file. Additional BPC software and license need to be purchased for reporting purpose. Embedded create a BPC flexibility to BWIP. So we don't need uh uh means uh means a connection. We just need a live data interface. BW and BPC integration is deep and real time. No interface needed to be developed. We don't need any interface for here. The embedded version is ITdriven and required depth technical understanding because see right now what we are using earlier SAP had decommissioned BWIP. IP is integrated planning but again they came they write it BPC embedded. So this is nothing but my BPC BWP only. So they just introduced it with a new name for BPC uh embedded one. That's it. The embedded version is strongly ITdriven and required in depth technical knowledge. Maintenance will be done by IT but finance own and change some 52:16 objects like uh composite and aggregations and other values. Planning will be done with BW master data. So what is there in master data? So it will just check those data since it's a right runtime real time value for 10.1 support package 09 consolidation is supported in embedded one it uses same consolidation so we can use it RTC realtime consolidation in uh embedded one embedded is having a much upper as compared to the standard reporting is done using business object analysis addition of Microsoft office and additional BPC software also will be needed. This is a comparison between standard and the embedded one. So here uh ask uh someone is asking about the client one. So analysis for office is dependent on this one analysis uh embedded one only. So for net view we we we do if we don't need HANA also we can use it we can use okay but in embedded we definitely need a HANA server or system for a proper function. Excel 53:19 client would be EPM addin. We'll go to connection server and we will uh just log into EPM and do the work. Here in the embedded will be analysis for office modeling will be here for account model. Okay. And here it is key figure model. Uh BW connection is partial model key. There is no not enough connection like transformation conversion. That's it. And here everything need to be mapped. Modeling is web client. So here the modeling would be web client and as GUI. So mostly we are preferring GUI in embedded one. Like we have a t as RS plan. Under this RS plan, we can do the different different planning. Local master data and hierarchy not needed. We need to create but here it it is created by default since it's a realtime system. Scripting here we are using script logic but there we are using fox formulas. Data locking is the last win concept and here we have also data locking on the pessimistic law. Pessimistic law query is like MDX engine query and here we have an analytical query which we call asex query as well. This aggregation will work only on BW1 HANA and ER 54:20 embedded it is work all time. So BPC optimized version for S4 HANA. So under this we have this is HANA multi-tenant under this cash management accounting BPC optimized for BW embedded one and BBC standard for the net one. So this is how BPC optimize version. So we'll come to our version BPC 10.1. So here planning, reporting and consolidation solutions will be based on my SQL server technology. How the SQL will uh means work. The same scenario will we will use for scripting and all. This version is designed to be flexible interface with different source system can be established. Then different source system can be established by RFC connection and the application can larely be maintained by business. So here the more of most of this application is maintained by a business interface only. How the business will work on this interface? So BPC decision tree. So this is very important one for BPC decision tree. So SAP platform 55:22 planning and consolidation running. So BW net on HANA SAP BPC optimized for S for HANA and net for HANA will have 10.1 netw standard and 10.1 net embedded. So what we are using is like standard one right not the embedded one right and under no platform no SAP platform we are using planning and consolidation so this is 10.1 Microsoft so this is so we are using very less over here uh means we are not using BPC 10.1 Microsoft in most of the cases okay so these are all about the versions and others and then we will now we will switch into the technical aspects of BPC. So this is what I explained you about the introduction to BPC, how BPC is working, what are the interfaces, what are the advantages, what are the disadvantages, how BPC will have its future ready, how the things are going to be in BPC going forward and 56:24 how the values are yet to be performed in the BPC. Okay. So if that is clear then we will move into the technical aspects of the BPC. What is inside BPC standard? So, so we have different different modelings in SAP BPC. First [snorts] one is my environment. Environment we can environment is nothing but the plot or area you can say where we are doing the where we are starting our construction means we can take an example of a baron land. Okay. And there if I want to build a five-star building means uh build a five floor five-story buildings. So what we will do the baron land we will first cover it with concrete or make a proper foundation. So that is my environment. Okay. So the proper foundation is my environment. So under environment we will add some pillars for technical 57:26 support of that uh pillar of that building. So that will that will be my dimensions. So dimension is nothing but my building block in a BPC. So under the dimensions the collection of all the dimensions will come under model. Okay. So first one is my environment. Environment is my basic plot. Dimensions are my pillars and model are nothing but the collections of all the dimensions which are available in the system. Okay. So yeah one uh so yeah one dimensions uh different different dimensions can be also used in one model or one dimension can also be used in different different models. So it is not specific that yeah cost center will you we will use cost center in cost center dimension only we use profit center and profit center dimension only. Okay. And models are also with different different model also can be get integrated into different 58:27 different dimensions or different different models interfaces as well. Okay. And in different environment we need to create it from scratch. We can't use the previous dimensions and model in the another environment. If we are in one environment, we can use that model and dimension which is available in respective environment only. So BPC road map versions. So BPC uh see you can see uh BPC 11X 11.1. See this this came in 2021. Okay. And right now this is the latest one only. And this 10.1 it came on 2018 or 17. So that's why I am saying that key we can use uh 11.1 as compared to 10.1. And uh this also we will use till 2027. earlier in earlier time frame it will be for 2024 or 25 since SAP has increased the time frame from 24 or 25 to 27 because right now they are 59:27 shifting the scenarios from BPC to SACE and GR. So this is how the road map looks like basically we are in the first one only. So under this net vaver version so what the thing is like we will uh so uh it will have an integration with SACE right now means after 2027 the plan for SAP is to accumulate all the SACE features means BPC features in SAS so that BPC will get wiped out and we will use SSD for our near future because right now the number of users are getting lesser as compared to the previous years. So that's why they had a plan to remove this one and use the uh SACE one. But I doubt that it would be very difficult for them to remove this BPC because most of the business means high level business or approaches are using the net one only. So it would be very difficult for them to get uh means go ahead to remove this 1:00:31 one till 2027. So it will get also extended till 29 or 30. This is the BPC road map and version. So BPC 10.1 Microsoft version is a successor of SAP 10.0. So the version is relevant when SQL server is your BPC platform. Okay. So you know that what BPC why uh in BPC also we are using JavaScripts as well. And if anyone knows then can they tell that where we can use the java scripts while using logic scripts we are using the java scripts in VPC. So it's uh syntax would be like x dim member set xyz for dimension xde this and that. Okay where loop for loop in as if else. So we are using the same uh in uh logic scripts and the same we are uh the same javascripts we are using in sec as well but the name different as data actions 1:01:32 and they are pretty same means 99.99% same just the uh means page uh flow will be different apart from that everything is similar this is what in between BPC and sec for javascripts okay and in BPC we will also have a BPC uh we will also have a SQL server. So do you know how we are extensively using the SQL server as well while doing the integration we are using SQL servers in our database platform like for organized package link list and all we will have SQL server only we are which are connected by this way we are using SQL server as well in BPC database and you know one thing we can use Hyperion as well inside BPC also via SQL RFC connections. So if we can make a RFC connection we can use uh that uh Hyperion as well in the BPC interface. Though the functionality of BPC is not uh will not work but uh we can view the same under one system only 1:02:33 means under one roof in the BPC uh one we can use the Hyperion and we can use BPC as well. But Hyperion functionality will not work in the BPC means uh some functionality will work but not the whole one. So BPC 10.1 embedded is a pen ultimate model. So it is the most uh uh successful model we can say of a BPC embedded one. So right now it's like uh if um suppose we have a share of 100 so out of 100 90% share of BPC will go into go into embedded one only and remaining 10% will rely on my standard one because it is a R3 ECC system. Okay. So what is the difference between embed and standard one is in standard we need to upload the master data we need to create everything we need to upload master data and then we need to do mapping and we need to create packages and then we will what we will do is we will go to report and do the report creation in embedded what and 1:03:36 that also the data is like if suppose data is available in BW then only we can view that data only in the standard one but In embedded we can view the realtime data. What data is there in PW? Suppose it's 217 AM. What data we are viewing in 217? The same data we can view it in embedded in 217 only. But in standard we won't. And the second thing is in embedded uh we will not go and map everything. We will just input the reference from ECC where ECC and then it will use our BP BW warehouse. Okay. We will just use the integrated planning package and we'll just integrate it from package. And now my BWIP interface is ready. So BWP interface will get ready within 5 to 10 minutes. But for BPC standard, [clears throat] it will take like 1 day to make a connection. It's not one day it will take something like 3 to 6 hour 3 to 4 hours at least because we need to install EPM. We need 1:04:37 to see the flexibility. Then we need to connect to the server and then create uh and once connection we'll able to see whether it is working or not. Then we will uh check the log on screen and then only it will get started. But in embedded one. So once we have all the credentials, we will just quickly go to analysis for office. We'll just log in and it will get start. What data is there in the embedded one? We can use that and we can view queries as well in embedded one like what we are doing in Eclipse like in BWE queries. So does anyone have any idea on queries? So BEX queries are nothing but query which are creating different data source. So under B query we have different different kind of characteristics and key figures. Okay, we call it directly in embedded one but standard won't have that physibility to use B queries and uh in BPC 11 and in BPC embedded also we must uh have as for SAP HANA component which is underlying in the process of BPC uh 1:05:40 embedded one. Okay. So I personally recommend BPC embedded one is a faster one. and it's a growing age as compared to my standard interfaces BPC road map and version. So BPC standard version for SAP net standard model it's it is a successor of 10.0 net and prior version. So the latest version which is running is in BW 7.5 and it is relevant when SAP ECC [snorts] R3 and BW 7.4 or higher are already in place. SAP BCS BCS or BPS need to be replaced. It is like business process and simulation BPS. So earlier it was process and simulation. So it is replaced and right now they came with a PAPM performance analysis and profitability management. So they also divided BPS into different parts. So PAPM so that is what we are working in means uh right SAP BPC 10.0 on net is a 1:06:42 current version used within the organizations third party consolidation software need to be replaced and SAP so software so earlier what happened so SAP will have a planning software but we don't have SAP have don't have a consolidation one so what they did is uh with the introduction to BPC they will uh have a consolidation as well uh means relied under BPC only so earlier they are using uh means a third party software for consolidation for management futures or management reserves. Okay. But after introduction to the consolidation one that things become easy and it would be uh quite uh important for them to use going forward in the BPC scenarios. So that's it from this one. So this is about the introduction glimpse of BPC. How this BPC will work and how the BPC functions are like how the BPC come into existence. What are the advantages, disadvantages, and how the scenarios are like to be? 1:07:45 >> All right, let's test your knowledge. Here's a question for you. Which of the following is a key feature of SAP BBC 10.1? Option A, real-time data integration? Option B, mobile app development? Option C, workflow management. Option D, predictive analytics. Take a moment to think and when you're ready, choose the correct option. Remember, each choice holds a key to unlocking the answer. Good luck. Type the correct answer in the comment section. Hey there, ready to dive into the world of SAP VPC 10.1? Our course is your ticket to mastering supply management all at your own pace on our platform. In this course, we'll unravel the mysteries of SAP BPC 10.1. Think of it like a Swiss Army knife for planning, ensuring we've got enough goodies and getting them where they need to be. From the basics to expert tips, we've got you covered. Crafted by seasoned pros, this course delivers the 1:08:45 goods. Your mentors, top-notch veterans in the feed, ready to guide you through and tackle any queries you throw their way. And hey, [music] don't just take our word for it. Our students are singing their praises. Folks just like you have found this course a game changer. Best part, it's easy on the wallet. [music] Learning doesn't have to cost a fortune. Ready to become a SAP VPC 10.1 [music] maestro? Enroll now. For more details, visit Zarantex website. >> Yeah. So this session is basically divided into two PPTs. First one will will be our environment model and dimension management. Okay. So under this we are having different we will study about the how what environments are what kind of environment we can make and what are the models how many types of models are available in the BPC [snorts] and what are the dimensions what are the basic prerequisites dimensions which which is must in a model and how the model will behave uh with or without dimension okay so environment uh what 1:09:48 are the environment environment is basically uh we we can consider implement is a playground area where we are uh creating a BPC uh where we are creating BPC models and dimensions and all kind of scenarios. Okay. So uh what are all kind of scenarios? It will be like our BPF flow, our securities, our teams, our users. So uh it depends based on the user. So how they want to create they can they can create environment for different different types of planning as well separate environment or under one environment also they can create different different types of planning. It [snorts] totally depends on their uh u mean requirement how they want to proceed since environment uh as per environment. So environment will have multiple kind environment will give you multiple kind of options to create different different models and different different dimensions. Under that you can create different kind of planning scenarios. How the scenarios are going to be how it will be work in your 1:10:50 existing reports, models, projects etc. And how it will going to affect your different kind of stories which uh was earlier pre earlier you can preview it in BW1. Okay. So an environment consists of primarily of models and dimensions. Okay. So since in I uh since we can say environment is our playground area where we will start our uh technical analysis. Okay. So under environment we have different kind of models and dimensions. Okay. So models are a collection of dimensions and dimensions are the basic building block and dimension can be used by any model within an environment and uh the delivered environment is called an environment shell. Okay. So uh environment is there. So we we need to create an environment and under the environment we need to uh input the model and dimensions. So once done we need to activate that. So that we call as environment shell. Okay. So once we 1:11:51 uh activate the environment shell. So all the uh each environment will have basically four models. Okay. By default four models. We need to decide what models we are looking for or what models we can choose. Okay. The environment shell has four models each with their own associated templates and packages. So these are predefined SAP scen things. So which will be available while installing the environment. So under uh environment we will have uh four different different we will have different different delivered models. Okay. So just pay attention in details. So we have four different different models. Okay. So here your uh technical journey for BPC will start like first will be our consolidation where we where we will do our uh income statement and balance sheet data consolidation. Okay. So it will contain our income statement and balance sheet data planning. So that will also by default uh SAP will provide you a report for income statement and 1:12:52 balance sheet format. So that it it depends on you how you want to create it across. Second one is our ownership. Suppose one company had different different ownership like 10% in India, 10% in UK, 30% in Japan, 40% this. So for that all SAP will have a privilege to create a different uh model as ownership. Third one is my planning. So basically planning is the most used uh model. So under this planning we we will use all different different kinds of planning and scenarios. Okay. [snorts] So currency translation also we can use over here. And fourth one is our rate. So rate will store the exchange rates means forex exchange rates and it is assigned to the financial and consolidation model as a supporting one. Okay. So the major models would be my planning and consolidation only. But uh right now what we are doing is we we are doing all kind of scenarios in planning only and if some IC uh and balance sheet plannings are there then only we are 1:13:53 using consolidation. Okay. So basically uh we are creating different different dimensions. Okay. So there are basically five dimensions which needs to be mandatory that is C E A T R. C is for category, E is for entity, A for account, T for time and R for rate means currencies. Okay. So these are the basically five important dimensions. If rate is also not there then we can suffice but C would be the mandatory four dimensions which should be available in across all the dimension uh all the models. C for category, E for entity, A for account and T for time. Okay. So, uh category uh would be like your actual forecast, planning, budget. Okay. Budget one, budget two, etc. Okay. P is for entities like uh you suppose you have multiple entities or multiple company codes. So, that will come under this. A is your account like your account are basically four types. Asset, 1:14:55 liability, expense and income. Okay. and uh non-financial [snorts] account will also cater this one and uh it is your time. So you can input your time in Y mm format. Okay. So these [snorts] are the basically means basic four dimensions which should be available across all the models. Okay. And apart from that there are means some add-ons also. So it depends on your choice how you want to create it. But these are the basically four dimensions which should be available. So you can add date as well. So y mm and dd as well. So it depends how you want to check it up. If you want to show it in hierarchy format, you can make it in hierarchy format as well. Means it uh SAP uh means BPS will provide you enough flexibility to use dimensions based on your needs. Okay. If you want to create time in two, you can create in two. If you want create time in 10 different dimensions, you can create 10 different dimensions. But in a model we generally prefer 14 to 1:15:56 15 standard dimensions uh which will make our work easy means more than that will lead to uh means the time complexity time issues and other scenarios. So it will be always better if we could use like uh less than 15 mean 12 to 15 dimensions only. Uh once I have system I will show you everything. BPC [clears throat] will have all kind of flexibility like uh if you want to do it in period like in Q1 period Q2 period so we have Q1 Q2 so under Q1 we will have 1 2 3 4 5 6 so like that you can uh easily uh make changes in the period means you can easily do your planning across that and under GL also we will have GL we will have name [snorts] description and uh GL account uh means parent as well and afterwards means account type. So these four field will be mandatory for account. For category we will have member ID and description. For entity uh for entity also we will 1:16:56 have member ID and description. And for time we will have uh as I told y Y mm as ID only or if you want to create hierarchy. So just go to SAP uh BP means go to the time hierarchy only mean time dimension and in the right side you will able to see uh that create hierarchy. So it will by default create header key for 2022 23 24 like that. If you want it to create via period level just you can uh select create via period. So it will create via period for particular year. If you want to create via days so we can create for each one we will have one hierarchy. For each two we will have one hierarchy. So likewise as well mean it totally depends on your requirement how you want to proceed in the environment uh in the main dimensions. Okay. So under dimensions we'll have the master data. Okay. So we will focus more on the master data for [snorts] your learning purpose and just uh once you take the dump of the data create at least six to seven basic dimensions 1:17:56 which you want that your model uh your model should have. Okay. And first of all create in planning one and then create in the consolidation. Your consolidation will deals with all kind of balance sheet and P&L. So under balance sheet and P&L you have cat will be the mandatory one rate will be mandatory or if you want to create any uh asset uh different asset dimension then you can create if you want to create any userdefined dimensions like cost element or profit group or profit center or cost center uh or WBS. So you can create as well under users user defined dimensions as well. Okay. So in VPCs the dimension types are used to identify the role of each dimensions in the consolidation engine. Okay. And the entity uh dimension is used to determine the local currency. So under entity you will have a local currency. So this is how your BPC page looks like. Okay. So 1:18:57 first of all in the right side if you will go to right side we have a setting. Okay. So after setting we will have a name means username. Okay. And after that uh if you will click on this one scroll one so you will able to uh see the environment name. Okay. So once you will see the environment name just go to the top left. On the top left you will go to administration. Okay. Under administration we will have dimensions and models. Okay. So [snorts] under dimensions uh you can create dimensions like uh what is there. Okay. uh so actually they will uh there will be like some dimensions available in the system as well like predefined SAP prerequisite okay and if you want to make any changes in the data and everything you can do that as well so suppose account so once we'll go to account so under account we will have uh means like five six excel tabs are there means columns are there under that we can input master data 1:19:57 [snorts] ID and description the uh advantage The disadvantage of having this dimension is we need to input the values manually for master data. Okay. Or we can copy or paste the data. There is nothing as such flat file form. Uh there is nothing as such this format uh means I can say CDS format to upload the data via uh means what data is in S4 we can upload that data. So every time if you have a new data you just need to go to some part that particular dimension in which dimension you have a data you just need to go and you need to add the data manually of your own or you can copy the data. Okay there are some cases. So uh when you are running uh a package it will give you error so that the uh means member ID or member is not available in the particular dimension. to make sure you can have a regular check on the dimensions that if any new data is pop 1:21:02 you can uh create that data as well in the system. Okay. So member ID should be must and description you can change it once you are once you are done. So once you are done with the uh dimensions so you can just save. So once it will once you uh click on save so it will state that start processing. So once it will start processing so the status will come as processed. So once it is processed means your dimension is ready. Okay. So like like this you you can create. So click on new and uh under new you can input the ID what ID you want. So you'll have these types account audit category currency entity subtables. Okay. So select your respective uh mean type and under that you can just create the dimensions. Okay. So basically how many dimensions are available uh means how many dimensions you are planning to create in this system. If you have a plan or that 1:22:02 ready then it would be uh good you can check it via type as well and you can create it as well the dimensions. Okay. >> Okay. >> So these are the dimension types like account. So type is A, audit is D, category C, currency R, entity E, scope G, inter company I, subtables is S, [snorts] time would be T, U, uh, userdefined would be U. So under user defined, you can use cost center, WBS, profit center and measures means uh if you have any measures in EPM1 like amount, percent, so you can add that as well. Okay. So, account will contain your chat of account values. Audit [snorts] will audit will identify the origin of values such as input, manual entries and elimination. Category are basically the version such as actual budget and so on. Currency will contain the currency value in which company does business. Entity 1:23:04 contain your business entities that are included in the consolidation process. Scope contain your scope. Scope will contain consolidation group members. Okay. Uh though we are not using scope [clears throat] actually this is out of scope only. So scope we are not using uh inter company will contain your IC ids uh for the entities like trading partner and others and flow as well come under inter company. Sub tables will refer to your flow or dimensions. Time would be your time period which is where you want to store the data. User [snorts] defined like additional dimension for your understanding and measure are amount, percent, weight, anything what you want to input. So this is how you can create new dimension. Go to dimensions. We'll have a new. So under that new you need to input the ID then description and the type. You need to select the type as well. So under 1:24:06 dimensions uh under that dimension if you want to use one dimension in different different one user dimension link [clears throat] with another uh type of dimension as well you can do that as well. So go to that dimension then ID and if you want to input use another dimension under that you can use that as well under uh this options. Okay. So we can do modeling options vary with different different dimension type as well. Okay. [snorts] Under user type dimension we can add account type and entity as well. But under entity you can use account type user data like that. Okay. So these are the basic properties of dimensions like adding properties to model adding properties. Okay. dimension features and adding property dimension in consolidation ownership and rate models modifying properties. We can add property values as well [snorts] and we can remove dimension properties as well. 1:25:07 If we uh we can uh we cannot delete the system generated properties. So some dimensions will automatically by default have system generated property. So we will not able to delete those properties in the system. configuring environment and dimensions. So system generated properties are like this like description would be there calculation if any calculations are there then we can use calculation that hir will be my header keys like it will uh it will store our basic basic hierarchies for particular dimensions. If there is no hierarchy, we can keep it blank as well. But hierarchy, I think in uh GL account, if suppose hierarchy are there, so it will be recommend to provide hierarchy for a top- down view. Okay. So we can uh use dimensions for property validation also and account dimensions can only the rate type such as AVZ for average. Okay. If the rate exist in reference 1:26:08 dimension. So under reference dimension what is happening means uh if suppose we have a dimension and we have another dimension so we can call one dimension property from other dimensions okay and validate as well. An entity dimension can use a currency such as euro if the currency exist in referent dimension enter company uh dimension can be linked to entity member if it exist in the reference dimension. So these are the different dimension like dimension account will have a reference type account property as a rate type and validation as average rates or so on uh category will have a time property is year and validation is see not or anything what you have entity would have a currency property would be currency and validation would be local currency intercomp would have entity property would be entity and validation would have trading partner So till this are you clear? Okay. So this is how the dimension internal 1:27:09 structure of a dimension looks like. So in the top in the uh top we have add delete revert. We will have recent deleted member. We will have apply hierarchy order display and export to CSV. Okay. So ID would be there in the left followed by description. Account type is much for account dimension. Offset it depends on you. Input IP depends on you. Inter company depends on you. Rate type would be depend on you. Means the rest these things are depend depending on your requirement. If you want to add you can if not no worries and uh you if you want we can export the dimension also in the CSV format. And if you click on apply hierarchy order if suppose any hierarchy is maintained we can see the hierarchy in hierarchical view. Uh we can see the dimension in herical view. There is no uh there is nothing as such to upload via flight file. You need to create the you need to 1:28:11 copy or paste the values manually in the system itself. If you want to add something, you can you need to go to add just you will get a column uh row and under row you need to input the values and click on save. That's it. There is nothing as such uh input or flat file or anything. We can have just copy and paste. Uh so this is how means if you can copy five lakhs account as well. So as BPC won't have any so it will get copied for five lakh account as well. So there is no worry about copying and everything. You need to create a sample of data like this and uh we can copy uh the same account dimension type. So under account dimension we have different different properties. So uh what you what you saw in the right means after dimension after account type these are our properties like offset account type input type input type inter company 1:29:12 rate type scaling uh scaling and also these are my rates or means these are my elimination properties okay for a particular dimension it depends on us uh what kind of property if we are using or if we want to delete we can delete as The must have property which are available in account type is uh account dimension is account type. It is required to input the account type. Okay. So why we need account type? So it will basically we can use account type for having control in the sign display and aggregation behavior. Okay. Like uh asset liability will have a sign income expense will have a positive negative sign. So we can control like that. Dim list. So dimish properties are used as selection criteria in business rules. Elimination account is basically used in US elimination process to identify the offset accounts. Group is used to classify accounts such as P&L balance sheet. Is input is used for report filtering. Rate type is required in 1:30:14 input forms. Okay. What kind of rate type it would be? Uh scaling is used to display value in thousands or uh lakhs. Okay. uh like formula based scaling type ele basically elimination account type properties like uh means we have control and prevent so we are not using this control and prevent aggregation if we have multiple uh account with having quarter to date and year to date value that this account we can use in QTD and MTD or YTD then we can use this otherwise we won't use this prevent aggregation so account type properties we are having basically four account type properties available like [snorts] asset, liability, income and expenses. These are the sign, these are the report, these are the aggregation using periodic measure. So the dimension structure will look like this. Okay. If you want any differential integrity then you can input uh fixed value as rate or 1:31:16 if you want to input any hierarchy then standard or in uh then here they put standard as parent H1 and enter company as parent H2. So this is how your sub table means flow type dimension looks like like under H1 we'll have a flow like F to under tot different different scenarios for flow type flow type properties. So under this flow type we will have id and description and flow type. So flow type is must while having the property. Okay. To make sure to input the flow type property when you are uh when you have a dimension as flow type. So it is used to distinguish the opening and closing flow. Okay. Like f__101 for opening f_02 for closing. So like this you can use for flow type as well. And f01 is my opening. F 02 is my closing. So like that if you could input if you could uh just uh put a filter on opening and closing uh all the calculation like sum or differences 1:32:16 would come directly in your report. So no need to go and just check one one to one to one mean. So it will come directly over here. And by the way we can create multiple uh custom defined property as well in the dimensions. If we want to delete one property and add different property, we can do that as well in the dimensions like maintaining consolidation dimension like entity type. So we can maintain entity type like ID, description and currency and if you want uh we can input owner and all. So why we are inputting owner you know means uh if we have any security okay where owner only need to where admin only need to update the entity then we need to input the owner type as well that what uh for what owner we are giving access to make the changes read or write or both. So configuring or 1:33:18 maintaining the dimension as well maintaining [snorts] consolidation dimension for intercomp type. So this is the id description and you we can input uh entity as the property for the company is the uh basic basically the page page is same. So it depends on us how we want to create the particular dimension like for category type dimension we have actual budget forecast IFRS US gap uh then draft final publish and simulations. Okay. So category for OP is used in the balance carry forward. Okay. For uh difference it is effect difference only. For source it would be FX source category. For rate it would be rate underscore category. Period would be rate period rate year and start month which are user currency translation simulations. 1:34:19 Opening period is used to specify for a particular month. Okay. EI is used for planning scenario to control user input. If year is not used, the category n member can be used any type. Okay. For group type [snorts] uh means uh for group type also we will have like uh this kind of scenario like uh wild will uh have a parent under this world we will have Africa, America, uh Asia, Pacific and Europe. Okay. So, so world will be a parent hierarchy key. Under this we will have this member ids. Under this member ids, uh we will input the currency type since each one will have different different currency type. So like this how our group type dimension will get configured in the system for audit type dimension. This is how it looks like. See this is how time dimension look like. Y mm. Okay. And if you input for uh quarters 1:35:21 so we can use like this. Okay. So we can define the level as well like uh for uh quarter it will be like quarter, year and month in the uh report as well. So hierarchies so hierarchies can be defined for any particular dimensions. They can be loaded automatically or they can be created manually. It depends on us how we want to proceed for different different hierarchies in the system. Okay. So they are used for basically expansion, rollup and member selections. We can create multiple hierarchy like uh uh means uh BPC will have like uh we will say will give you privilege to create three different hierarchy only for each dimension. Okay like H1, H2 and H3 that's it and then child. So uh it depends like for time uh means for account I think we will have multiple header keys but for other BPC will give us privilege to create only two or three header keys only at once. If suppose we have like 1:36:23 five head suppose let's suppose we have H1 H2 H3 H4 H5 okay if you will input H4 right then what it will happen H4 H3 H2 H1 and child will come okay then you need to write that uh remove leaves node then if you will remove leave node then your particular hierarchy H4 will come like how you are doing in Hyperion okay so there are some time dependent hierarchy as Well, so this is uh means this this is a screenshot for EPM report. I don't know why the input so it will give you a confusion only. [snorts] So don't focus on this uh one. So we will discuss it once we will go for EPM reports. So uh once you will create we need to click on save and process under save and process we can uh it will ask do you want to say uh take the environment offline. So what does this mean? If you will click on yes. So if suppose someone will work on the environment so uh it will not work for 1:37:25 them. So it will make environment offline. So what changes they are doing so they will be stick to that only the previous one. Okay. So always make a habit when you are having when you are creating a dimension uh if this message popup will come do you want to take the environment offline just click on no. So that if suppose someone was logging into your system or means in the BPC system so they can also work and you can also work at the same time otherwise uh if you will click on yes then uh you and they both need to wait for like uh a minute or so. So once you click on no then it uh then this pop-up will come the dimension have been processed and once you click so you will see the status has processed. So once it is processed means all kind of master data or BW reports are available in the system. So now your system is ready to uh create reports or various inputs. So these are basically the dimension members 1:38:27 uh which are used in class. Okay. So we will discuss this also once we'll have system. So I will show this how this will work as well. So I guess this is all about your configuring dimension and models. So uh uh if you have different different kind of suppose act for cast version as well available in your system you need to create that as well like f_sub_1 f_sub_2 f_sub_3 till f_sub_10 mean how many you have so basic not have a userdefined dimension saying that versions and under that I have draft 1, draft 2, draft three and when I load the data I'll use that uh intersection to load. Is it not possible? uh it's possible but see as I told you earlier only we have basic we need four dimensions are mandatory >> yeah 15 is limit right 15 >> 15 is a limit and four are mandatory dimension under this category is the main dimension also so we can't just bypass the category and create a user defined as version if category we are 1:39:28 using category in other dimension as version and we can use like that as well So under this what is happening if suppose we have different different uh mean suppose we are getting data from BW to BPC okay so what it will do is if uh we have two kind of things okay first one is my transformation okay and second one is my conversion for time being just forget about conversion so first we'll focus about transformation okay so what are transformation so transformation information files are those files okay where we need to uh map the figures okay so here mapping simply specify the left hand side would be your left hand side would be BW dimension okay and the right hand side would be your BPC dimension okay so it will have 1:40:31 three columns first would be my options okay uh under options it's like uh there are four five lines which are predefined only. Okay. And after that we we will have mapping. So it will divide into three parts. Options, mapping and conversion. Okay. Under options we will have like five to seven lines which are available. The text size will be this. Delator would be XYZ and like that. Okay. mapping will have my BW to BPC functions or dimensions and conversion. If suppose in my BW my time would be like 20 uh 12 uh sorry 2 0 to 10 204. Okay. But in my BPC the format would be like y mm. Okay. Means y mm. 1:41:31 Okay. Then what we will do? We will just input in the conversion we will input time.xls. Okay. Under here conversion suppose for 2024 you want to convert then you need to write every means in conversion we have internal external and value. So under internal you need to write all the time which you want to cop which you want to uh make changes. Okay. Like this one. So you can input this like 0 to 10 20 4. Okay. And if you want to convert it to like uh this like uh uh 2024 uh here you will write this y dot mm and here the value will come like 2024 dot 1. So like this you need to pick up this value data transformation page will 1:42:33 also look like this only. So under this transformation you can call it in uh based on your understanding how you want to call it in the system but uh most of the cases these transformation values are getting calculated. In some cases these transformations are getting called as well and there are some users who they don't want any transformation then what they will do they will create a separate file in BW and they will load it via process chain only by DMP. DMP is nothing but my data manager package. So under data manager package we need to input the name of the process chain. So once the process chain will get triggered automatically my data will get triggered in the system that is advanc BPC scenario. So yeah we'll see if that thing suffice uh in this one because in most of the BPC projects that will not work but uh if that thing will work under this then I will show that as well but for that we need uh have a updated 1:43:34 version of BW and updated version of BPC as well. If anything would be failed then we will unfortunately not able to do that. Let's see how what system we will get and how the scenarios are. 11.1 is the most updated one and 7.5 [snorts] 7.5 would be my BW version. So under uh the transformation so once I will create the transformation and conversion then what I will do is we will have a DMP okay like uh like packages like organize link list and then organize master data like organize CC key. So we can what under this we will have a scripts. Script means like advanced formula that once uh user will click CC hierarchy script. So what it will do? It will replicate you to CC dimension and under that CC dimension it 1:44:34 will search for that particular member and it will input the hierarchy by default. Okay. So those are mean later stages once we will have system. So it would be easy for you to understand and I think this it for the dimensions and now we'll proceed with the another one. So once the dimensions are completed then we need to uh assign dimensions to a different different models. Okay. So how the model works is model are basically the combination of dimension. Under this model we will have n number of dimension but as per SCP uh it would be good if you could have 14 to 15 dimension at once in a different uh in a model. Okay, more than that also won't have any issue but SAP will say that it will lead to system complexity or time complexity. Okay, we can add 20 as well or 30 as well. there is no issue but yeah uh your time taking uh means it 1:45:35 will take enough time to open the report because data loading will take enough time so we'll start with this so can anyone tell why we need flow type dimension it is basically for the opening and closing ones so uh we can use flow type in the planning as well and then how we can use that flow type in the planning planning means planning model I think there are some guys for finance as well like so They should have this answer if they can speak. Suppose we have a cost center planning. Okay. So my FAB month got a closer. Okay. So uh suppose I am doing month end activity MEC activity for particular FAB month. Then my closing I need to transfer my closing balance to my cost center planning opening balance. Okay. So what I will do? I will go to flow type. I will create a flow type or if suppose a flow type is created then I will just input the flow type entity as 1:46:36 opening and I will run the package. Okay. So what what it will happen the closing value uh of my flow type which is earlier predefined so it can be converted into the opening value. Okay. So this is how I can transfer my flow type closing balance to opening balance in a particular planning model. Okay. So what I am telling is suppose F underscore 01 would be my opening. F_02 would be my closing. Okay. So, so I want to transfer my closing balance to next month opening balance. F_03 would be again my opening. So what I will do is I will create a copy of f__02_1 1:47:36 as my opening and I can write a logic uh where x dim member set flow is equal to f underscore _ 02 s_1 s f__03. So what is x member set? So it will it is saying dimension having a member set flow having ID as uh f021 as f03 means it will convert my 0201 value to my f3. So that my 02 means the replica of 02 will get converted to my opening one. Okay. And once uh I wrote this so I just need uh I just need to input it in my 1:48:37 package list. So once I will just run the package means the master data package. So it will get refresh and my closing balance for that particular planning will come under opening balance. Okay. And uh there are uh and uh there are some scripts as well where you can create one flow and you can just uh replicate that one only like how I did right. So you do like that also. If you can create one flow only you can use it in opening and closing. You will need to specify the particular time like for January you need to specify that for till 31st January the closing would be my uh February opening. So like that also it will work. So you just need to uh write it in the logic and what will happen you just need to uh mean put a timer on the logic that yeah on that particular time it will start like how the process chain is working right we can do as well this uh this will be in script logic. So uh can can anyone tell 1:49:39 what is the difference between my entity and flow because flow will also have the entity. So why we are using entity? We can use flow only to have entity because entity is also a property of flow right. So rather than using two dimensions it would be easy right? If you can create one dimension and use the property as entity in flow. See flow will have entities. I will tell you this as well. So this is also a technical one. Suppose we have a flow as opening and for entity like uh we can say UK okay let's suppose UK is an entity and let's suppose APAC is an entity let's suppose uh IMIA let's okay so for example flow one will have opening balance Okay. So if it is connected to UK, APEC, 1:50:42 I emaile and Latm. Okay. They're having different different time zones, right? Like suppose suppose uh it's like uh 2:00, 2:00 a.m. in UK. In EPC it would be like 3:00 a.m. In EMIA it would be like 6:00 p.m. 6:00 a.m. In LAM suppose it would be like 10:00 a.m. Okay. So if you will just do the uh means what I told you like via script if you will just do the opening to closing. So it will hamper all the things if suppose some country or entities which are working on that particular type the existing flow will get replicated once you run that scenario. Okay. So that's why we will have a part different entity type and different flow type. So we will not use the entity for that entity property in the flow type. Okay. See for flow dimension we will have ID. 1:51:42 Okay. FID we will have a description and we will have entity. Okay. So this third entity is not a mandatory field. Okay. It depends on us whether we want to input or not. Okay. Let's assume that we have inputed and we have another dimension as entity. and description. So if we define f01 assigned to these particular entities four entities then uh what I told you earlier that we need to update a process chain right we need to update a script logic that whether x dimension type f-01 for this okay and it should be have a particular timer and suppose that particular timer for us will meet a working hour in IMIA. So what it will happen it will just replicate [clears throat] the values existing values and input the new value means your existing settle value will get deleted and your new value will come on that particular system. So that's why 1:52:44 we are not using entity as a property in flow type while creating report we that's why we are creating a separate entity dimension. So my question was why we are using entity in flow type. Uh why we are having entity dimension as a different one if we have a entity in property for flow type. The answer would be if we are using a flow if we are using entity in this flow type or if we are mapping the value then there are chances that value will get replicated if suppose some particular entity is working on that particular time. So that's why we are using entity as different dimension rather than using in property of flow type. Okay. So this I will also explain in the system. I was just explaining this uh how it is behaving in the here. Okay. Okay. So let's start models. So we are having different different models for creation. Okay. So we are having 1:53:45 different different models. Okay. So uh basically we are having four models in the system. First one would be my consolidation then ownership then our planning and then rates. Okay. So once we create all the dimensions we need to define we need to club those all dimensions into a particular model for our proper working. Okay. So for [snorts] simple consolidation we uh for consolidation we will have ownership. Okay. So what are ownership? Anyone have any idea on ownership? Why we use this ownership? Ownerships are the values which are predefined for a particular company. Suppose we have Intel. Intel head office is in US. Okay. So Intel is basically divided into all the continents across all the continents. Okay. So what Intel will do? 1:54:45 Intel will take a ownership means 100% to its Intel US. Okay. But the business will come from different different parts of the uh means across the globe. Okay. So what Intel will do like my 20% revenue will come from India, 20% will come from Japan, 30% will from UK and remaining 20% would be for XYZ reason. Okay. So once we define the ownership values then what it will happen it will just replicate the same value and while budget allocation based on the ownership we can define a predefined budget as well for a particular cluster or particular reason. So this is how ownership will work. See it depends on the company organization structure how they want to divide the ownership values. Okay. If they will divide in if suppose US is a entity and they will divide us into like 10 different 1:55:45 different parts like uh Texas for one Dallas for one California one New York one so like that uh they can also have a ownership if they want if not then for particular cluster wise and there are some organizations which will take full 100% ownership for its base location only because end of the day you will able to get the P&L and balance sheet report right for all particular clusters. So there are some uh mean there are some clients which are not defining any ownership. So they are taking 100% as their ownership only and uh they can validate the same via P&L report. So for simple consolidation process with 100% ownership you can use the finance or rate models. Under rate we will do the currency translation scenario. Consolidation type model can use all the business rules. So uh see this is getting more technical. So yeah once 1:56:47 we'll have system. So I will first show these things then only I will proceed with other steps. Okay. So right now just understand that business rules are basically the rules which are which we are using for consolidation or carry forward scenarios. or posting any journal values. Finance type model can't use a consolidation monitor but it can use all the business rule except elimination and adjustment. So finance type will not use a consolidation monitor since it's a part of consolidation only. You can use delivered model or create your own. So uh since SAP have SAP have provided [snorts] a bunch of model so we can use that model or we can create our own model as well. The consolidation engine can be used for either consolidation type model or finance type model. Most model consists of 10 to 15 dimensions. Every model type 1:57:47 uh category account time entity and some require more. So category account time entity is basically for planning and for other like rate and others rate and consolidation uh we need uh rate as a dimension as well. So this is how we can create models and this is how your model screen will looks like. You will go to the uh navigation page under this three lines. You will go to uh you need to go to models and then we will have this consolidation and this management consolidation. So I don't think this management consolidation is there but I don't know I think it seems to be earlier one ownership and rates under we don't have management consolidation we will have planning in place of management consolidation. Okay, for creation of the model, first we need to input the ID. We need to go to new, then input the ID and description and then 1:58:48 click on next. Okay. So, it will ask you whether you want to create a model from scratch or you need to use the existing one. Existing means the SAP defined one. So, if you will click existing defined one. So under existing defined one we will have everything like uh standard uh uh script logic as well. If suppose any currency translation or anything will happen. So we will have that thing as well or we will have business rule. We will have business process flows, process templates and everything will be there. We just need to explore that. Okay. So we will select a blank one and under existing we will see all kind of dimensions and script logic dmps and others. Okay. So based on our need we will decide accordingly when we come into this one. And then for creating new model the step three would be uh whether it would be of three parts. Okay. First one would be my standard. Standard would be my no other model will be involved. 1:59:49 So under standard it will be used for planning only. Second one is finance. Finance is used for only rate model and consolidation is my ownership and consolidation model. Okay. So right now we are just we will just use finance and standard. Okay. So under this also we will have some uh drivers or rates and we will define that what are the key figures, what are the ID length, what is ID, whether it is in string car data type. Okay. So data entry mode. So this is for YTD model. Okay. So we can input data like cash cash equivalents, sales revenue. This is not needed for periodic. Yeah. [snorts] For data entry mode in standard one. So we will have basically these four dimensions. And for col uh for financial we will have C A T R where R stands for 2:00:50 my currency or rate. And for consolidation one we will have C Audit group inter company subtable and currency. And for creating model we just need to select the dimensions. So what dimension you want? You can just click on that uh tick mark on that dimension and it will get selected. If you want to copy a dimens copy a model from any existing model which is available in the system then you can uh write you can use like this as well. copy from source. So what will be there in that particular model will get copied from there to this one what you're creating and afterward we'll have a review and create. So once we'll click on review and create a model will get created. After editing the uh after uh means creating the model we can go to edit and we can edit the model as well via settings. So under this edit model we'll have this kind of general settings like large key figure, normal 2:01:51 key figure, work status, enable command, command length and source data and feature use within a model like whether if we are using a work status. So what work status will do? Work status is basically the data log state data log. Okay. So under this data log we have owner and reviewer. So owner will view the data and reviewer will need [snorts] to input the data log. So they two have the access. Owner is my super user and reviewer is my basic user. Then data audit. Okay. So data audit feature will also enable in the model. We can select then my data audit will work. So under this data audit if suppose anyone anyone will make any changes in the data you can able to view that via data audit catalog. Okay. If master data will get changed or ID will get changed, you can have a track of that as well that yeah on that date that uh means that ID has changed 2:02:51 this data or manipulated this data from this to this. Okay. Then journal templates only relevant for reporting model. So general templates are relevant for only reporting one. [snorts] Then enable command. So select this option to use command. So if suppose in the input report if you want to input any value or any uh means command you can use this one and use as a source of data means if you it you can use as source of data for external application means this process will work when you are taking data from S uh means SQL or any XYZ RFC connection. So this is this we will see once we'll create. So I don't think we need to create all different model because we have limited data only. So let's see what models we and so I will create means we will create all models. Okay. And we'll see in which model we 2:03:51 are we will work. Okay. So uh these are the basically environment. So environment is a main uh means playground area. Under this we will have dimensions and under the dimensions are the basic building block and under dimension we will have rates um we will have uh models like rate model consolidation model and ownership model. Okay. So this is how your model and dimension will come into existence for SAP BPC. Just while creating environment we need to activate and under environment if everything is created it is ready for use. Just click on save, save and process. So this is our first technical one which we have completed based on the model uh how to create model and dimensions. Okay. So uh this would be uh the third topic would be my DMPS like data manager packages. So this is a very interesting and important topic in BPC point of view. So 2:04:54 this is like means uh once we create so we will come to VPC and once VPC will get mean once VPC will start working and then we need to just create the DMP packages. So DMP packages are basically the lifeline you can consider of a BPC without DMP BP system will do nothing. So this is the most important part okay for data transfers and all. So we are using DMPS. So under this you will able to understand about the configuration and user use of DMPS. And once we are done with it then we will close today's session and we will uh start uh next session. Okay. Uh in coming days. Okay. So dmp is a package which will you which we are using to import, move, copy, transform, manipulate and clear the data from EPM addins. Okay. So under 2:05:55 those EPM addins we will have these much functions to import the data. So how we will import the data? So first uh we need to create a transformation and then conversion and once we will do that and then we need to create a DMP data manager package. So under the data manager package we can take the data from the system itself. Okay. We [snorts] can import the data, we can move the data from one place to another, we can copy the data, we can transform or we can manipulate or clear the data as well. It provide basic extraction, transformation and load. So yeah, BPC worked on ETL principle like extraction, transformation and loading principle for advanced business users. Okay. It allow to modify package prompt and script logic files. For example, DP 2:06:57 are created against delivered BW process chain. So what is uh process chain for BW is the same for TMP's data manager package is for BPC. Okay. So data manager package are basically the uh process chains in BPC. So what is available in BW package can be bundled into package links. So each package will have different different kind of package links. Okay. And they are different from each other. Package and package link can be executed from BW process chain. So what it will do? So we will input the package list. Okay. So once we have the package list, it will show the it will uh once it we will trigger this. So what happen in the BW side? it will trigger the process chain and uh we will get the data in the BPC. So this is how DMP tab will looks [clears throat] like. We need 2:07:59 to go to organize. Under organize we will have three things. Organize package list. Organize package link list. Organize delta initialization. Organize package list will have all my master data. Organized package link list will have all my transaction data process chain. Organize data initialization. If suppose if you want to change only some transaction data then we need to run this one organized data initialization. Okay. Below this we have transformation file. So as I told you we need to go to new transformation file and create a new transformation from scratch. And then uh we need to go to manage. If you want to make any changes in our transformation then we need to go to manage transformation file. Once we are done with manage and then we need to save and we need to validate the transformation. Once it will get validated and then we 2:08:59 will go to conversion files create conversion manage validate. Okay. Right now how I am speaking like this. So it is not this much that much simple. So we literally need to understand how this thing are working in the system. So once we'll have the system and some amount of data then we will directly go and check and do this one and under this run package. So we will go to run package. So it will show different different process chains different different package link list. So once we'll click uh we will able to see the status in view status. Okay. And in run package also we have two type of things. Once you will start run package it will direct directly run. And the second one is if you will start run package it will ask you for prompts that for which prompts you want to run the package. Okay. So it depends how you want to uh means create the package link list. If you want to create it via 2:10:01 prompt then it will ask for prompt. It will if you will ask if you want to run it directly then it will run directly as well. For data manager tab we have two ribbons. First one is my connection. Second one is my data manager group. The connection ribbon is the uh place where we define the web service connection where we need to reach the data manager feature. And the data manager group is where we can perform [snorts] all business planning and consolidation access data task like run package or package links, view package or package link, upload flat file, download flat file, preview flat file, organize package link, package links package and delta initialization. Create and manage transformation. create and manage conversion files and this is about our security part data 2:11:03 manager and security. Okay. So we can define tasks that uh who will do this data manager task and who will do this task. So if you if we want uh that owner should uh run only admin packages then we can input run admin package and once we will click so we will get we will assign owner name over there. If suppose we want someone we'll need to only edit the package then we can do like that also. Okay. Okay. So we can apply locks as well and we can apply security as well on different different task and their task profiles. So uh these are the profile descriptions like run admin package. It will view and run package which is set in admin package and user package list. Second one is run package. It will view and run packages set to the task type 2:12:04 user package. [snorts] Third is edit package. So it will edit create or delete package or change package type or add transformation and conversion file. It cannot change the file name. Edit transformation will edit create and delete the transformation files. [snorts] Edit conversion file. So edit conversion file will edit, create and delete the conversion files. Cancel any user package. So it will cancel other user package only net provides the capacity means uh uh means provide the ability to cancel means if suppose you have a package which you have outsourced uh from one system to other so you can cancel it. Edit package schedule for any users. Here you can view logs and change the 2:13:05 schedule for any kind of package and then edit package links. So you can edit, create or delete package link, upload data. So you can upload the data as well by flat file. You can download the data as well and you can maintain the delta initialization settings as well. If needed, you can run it as well. [snorts] So package groups are defined into three types. First one is my data management, second one is my finance process and third one is my system process. [snorts] So under data management, we will get all the master data. Under finance management, we will get all the GL accounts and other data. Under system management, we will maintain the hierarchies and different different types. So if you upload suppose if you have a 2:14:06 flat file, right? So this is the package what we are talking about for upload. So this upload function uh will work for transaction data only not for master data. So data man DMPS are basically the process chain. Okay. So so how the process chain will work is like start load data and import into model. So this is how our BPC data manager package is working and uh see these are the things which will come under data manager package like first one is our organize package list. So under this we need to uh go to add package and we need to input uh the package name whether you want to copy transaction data. So [snorts] just click on the copy transaction data and add that's it. So our copy transaction data will package will get created. 2:15:08 If you want to run the copy transaction data. So we will just go to organize or if you just go to run and we'll just uh write copy package. So it will run the copy package transaction data what we have just created now earlier in the above slide. Uh so under this uh we will provide a path for process chain also. So once we will do once we will add now so the second option modify package will trigger. So we'll just click on that and we will just provide the path for process chain in BW. So what data is there in BW? It will get that data from BW to BPC. If we don't provide as well it will also uh don't have we don't have any issue because we already we are already doing the mapping in transformation and conversion file. Okay. So the copy data manager package will start run. So uh under here if you will go uh so that is what I have 2:16:10 created. Okay. So under that if you want to copy a data copy transaction data for XYZ particular uh entity then we will have a prompt as well over here. Okay. Like copy transaction data. If you click on copy transaction data it will ask for a prompt that uh means if you want to input a prompt you can input a prompt or you can select all. [snorts] Okay. Okay. So once you select it will ask you for a transformation file or means copy the entry. You can input the entry and then you can just run the package. So once we'll have system I will show you step-by-step scenario how we are creating data manager package and how we are running this DMP. So you will get more familiar with this. Okay. Right now don't panic that uh yeah these things are there. So once we have system then we'll do yeah just remember one thing that if we have any work status available in the system or if work status is applied 2:17:12 then it would be very difficult to run the package because what happen work status will lock the particular cell. So if it will lock the cell then your process gen means uh package will get failed because it will not allow you to write any value in the cell. So once it will not allow then it will force the package to get fail. Okay. So make sure that when you are running the DMPS your work status needs to be open. It should not be closed. Okay. So these are the silly things which we need to take care of. So once we run the package and it is getting failed continuously then we need to check the work status as well that whether my work status logic is open or closed. Okay. So after conversion file now we will have a option of work status. If you go to data now we will have a tab as work status. If you'll just click so it will say that open or close. Just check it is open. That's it. It is in data. So 2:18:14 we have home in the Excel you we have home insert page layout. So in the data we will have work status. So once EPM will be there. Now if you'll click on EPM now you will able to see the work status. That's it. So you can lock it via model as well and you can lock it here as well. So it depends if you will lock it via model means admin rights you will have you need to must have admin rights. If you will lock from here you need to must have user rights. Okay. So admin can lock it from there also. So if admin can lock so then you need you will not able to input anything over here. then you need to remove that lock and make sure that both locks are in sync only. If one is working, if one is lock and one is open then it will not work. If both are lock or both are open then only it should work. So this is how we can view the status and we can view the status of packages that are currently running 2:19:16 and packages that have been completed. Select view status and under view status we can see. So here we can see view status as well. So yeah after run package are you able to see view status here you can see view status one after run package. Uh so once you will run the package under this one so uh it will you can able to see the uh status of the package whether it is successful or fail. Okay. under this view status one. So this is what it return uh [snorts] select view status and then view status the package stat dialog box a resume of various packages. If you want to view the detail log or under this view status if you want to see a detail log whether what kind of report I mean what data I have filtered and what was get loaded in the system you can able to check that as well and schedule status uh means package status displays the result of 2:20:18 package that are executed already. So under that when you open the view status now we will have lot of packages uh successful fail successful fail. So it will show my existing packages which we run in the system itself. Okay. Schedule stata displays the schedule on which various package are set to run. See this is how my view status will look like. So this is uh the succeed. So once you click on this succeed one you will able to see the package logs. Under this package log how many records are transferred? How many records are not transferred? What is the reason for not transferring of records? You will able to see everything each and every details and data update option are also available. So after importing the transaction data uh there are normally subsequent update in the source system that also need to be imported. when importing transaction data multiple time 2:21:18 uh there is also a chance of data duplication. Okay. So always and always when you are trying to or when you are going to import the transaction data make sure you need to run the clear package first. So once you run the clear package it will clear all data and then run the copy transaction data so that it will copy your data from fresh otherwise in BPC it will over it will not override that function it will just add the function. Okay. So you need to take care of this as well. So when you are copy the transaction data you first need to clear the existing data and then only you need to clear the existing data via clear package list in the master data and then only you need to apply that copy transaction data otherwise it will uh just to double up the values. 2:22:21 Okay or when you will use the delta data manager package. So what it will do is it will provide it will definitely you need to definitely input any prompt without prompt it will not allow you to run any data manager package. Okay. So in data manager package there is a least chance of having data duplicacy available in the system. Okay. So example is after importing the May flat file on June 1st you received the adjusted file on June 2nd with all of the same record with two exception actual benefit have increased from 1500 to 1,600 or there is a new record uh for actual direct labor for 160. So there are two main uh options run a clear first. So what I told run a clear first then import the flat file transaction data and then run that package. So it will not allow you to have a 2:23:22 duplicate entry. You can schedule the package as well like how you are doing in process chain. So we will just go to uh means if you want to schedule it once, twice, daily, weekly, monthly. So we can do like that also for copying of uh uh flow type means opening and closing we are using this approach only and uh we can able to see the process chain as well in the BPC that when you click on this DMP data manager package which process chain will get triggered in the BW and for what time it would be for checking the process chain in the BW screen we will have a t as RSPC So just click on that RSBC and you can able to view your selected uh process chain and you can view it in data manager package as well. Data manager as well. Okay. So if uh process chain start from 2:24:23 if there is a process which we are using in BPC so we generally start it from BPC only like you can see clear transaction data, copy, export. So these are the DMPS. So what DMP we will create? It will create a process uh there back in the back end as well. Okay. Yeah. So uh based on these three we have completed the models, we have completed the dimensions and we have completed the data manager packages. Okay. So this is how uh we will again once we will have system we'll again go through this thing like creation of model, creation of dimensions and the data manager packages. Okay. >> All right. Let's test your knowledge. Here's a question for you. What is the primary data source for SAP BPC 10.1? Option A, flat files. Option B, relational databases. Option C, SAPBW or 2:25:23 SAP Hannah. Option D, Excel spreadsheets. Take a moment to think and when you're ready, choose the correct option. Remember, each choice holds a key to unlocking the answer. Good luck. Type the correct answer in the comment section. Hey there. Ready to dive into the world of SAP VPC 10.1. Our course is your ticket to mastering supply management, all at your own pace on our platform. In this course, we'll unravel the mysteries of SAP VPC 10.1. Think of it like a Swiss Army knife for planning, ensuring we've got enough goodies and getting them where they need to be. [music] From the basics to expert tips, we've got you covered. Crafted by seasoned pros, this course delivers the goods. Your mentors, top-notch veterans in the feed, ready to guide you through and tackle any queries you throw their way. And hey, [music] don't just take our word for it. Our students are singing their praises. Folks just like you have found this course a game changer. Best part, it's easy on the wallet. Learning doesn't have to cost a 2:26:23 fortune. Ready to become a SAP VPC 10.1 [music] maestro? Enroll now. For more details, visit Zarantex website. >> So, uh when it comes to BPC, okay, that is business planning and consolidation. Okay. And as you are going to work on 10.1 and this is 11.1. Okay. So hardly there's a few like you know some difference cosmetic difference right that also we will cover. Okay. But other than that functionality logic everything remains same. Okay. Now when it comes to BPC business planning and consolidation SAP has released this tool. Okay. Having three components. One is like this web planning. Okay, which you can see right now on the screen here. What one can do whenever they will login into any BPC server, this would be the landing page. Okay, there they can see home library, my activities. Okay, second would be EPM which is 2:27:27 enterprise performance and management. Okay, you would be once you have EPM installed on your system, you would be able to see one additional tabs basically two additional tabs. One is EPM, second would be data manager. Okay, what's the use of this? How we can work on it? Right, that we will cover later. But so this is the second area. Third would be you know your back end how your data getting stored. So here we have BW for HANA. Okay. So these are the three components which covers your PPC tool completely. The SEP loon pad which you can see here right once you'll be log right into this one. This this would be because it's 11.1 so which runs on BW4 HANA 10.1 runs on BW 7.5 but what you have to do what actions you will do those are most likely same. Okay. So here as well in the back end it's of BW 2:28:30 plus you would be able to see BPC as well that we'll show you. Okay. Basically these three areas which covers your BPC application. Okay. Whenever any project comes whenever any opportunity comes for planning okay then you know when it comes to work as a consultant what one will do they will log on their BPC web link. Okay. Once you will login on your BPC web link. Uh so 10.1 screen would be little different that would be much uh straighter. Here basically you are in my activities uh tab. Okay. So in 10.1 you would be able to see uh right now you can see go to my activity but there you would be able to see environment. Okay. So what is environment? Okay, environment is basically you know what what you are going to create your application whether it's planning consolidation right that's a shell 2:29:30 environment shell by default it's a SAP thing which which covers your overall application so whenever you will be log into any new system you would be able to see environment shell okay so here how to access that go to this click Click on whatever environment you can see and this is the environment shell. By default in any new SAP BPC system once you log in. This would be the environment which you will see here. In a layman term you can understand environment is nothing. It covers your overall application. In one environment you can create many models. Okay. So this is a practice uh this is a practice server. Okay. So where you know different different uh requirements we are having. So for because of that we have created it as a embedded but you would be able to see only standard okay in your company server as well as to any BPC 10.1 11.1 classic version or 2:30:34 standard version okay so around the globe mostly standard one is the most you know uh most kind of a common and preferable server which any client goes for right because that's much uh straighter and that's good for planning The difference between embedded is that embedded is mostly for BW consultants. So when it comes to embedded so mostly BPC consultants get rely on BW consultants because of lot of B BW dependent functionality that's the reason standard one uh is the most you know common one and the popular one. Okay. So for a time being you can ignore all the other environments which you can see but whenever you will be able to login into a new system you would see environment shell that is the first thing you would observe in any VPC system. Okay. Now the thing is that uh this is environment shell. Okay. Now there are two things uh which uh you 2:31:34 know I think I can cover but uh like can you help me to understand that any of you is going to play a consultant role or only a user role you are going to play in your company because the activity which I'm going to discuss that is more about consultants since you have mentioned that like most of you would be playing consultant roles so let me show you this exercise so when you will be able to see a new system okay so Right? Now you are in environment shell. Okay. Now what you need to do you know that okay you have to create a planning implementation right you have to work on implementation for planning let's say then you need to have your own model so that you can design the system accordingly. You can although create your models and everything in environment shell but that is not uh recommended because environment shell is the environment uh shell which is very common having lot of you know libraries and all which is mostly 2:32:36 technical. So that actually helps you when you do backup and restore of your application. So what you can do when you are working uh so normally when you start as a consultant you would see three instances. One is development, second is quality, third is production. So when you do in development system you do the development in quality you do the testing. Once you are ready with your application, you move your application from development to quality. Okay. When you move then you get many issues right during that activity. So to avoid all such things and to not to you know modify or having a negative impact on standard environment shell what we recommend to create your own environment shell so that you can easily move for example ROA is having a different server and you are having a different server okay so it's better to create a different different environment uh not for every model but at least if there's a you know different server or having 2:33:37 other dependency so that anytime you feel that you want to move it to quality, you can move it. You don't need to depend on other uh team members whether when their application would get ready only then you can move it. Okay. So how to do how to do that? So for that go to environment. Okay. Click on environment. Right. Here you can go manage all environments. So this screen would be exactly same to 10.1. Click on environment shell. Okay. Click on copy. And there you can give any any name. Let's say planning. Okay. Planning. Any any suggestion, any nomomenclature you would like to suggest. What you can do? You can uh you know give a name of your company. Okay. Or of your division here as well. So let's say I'll I'll I'll put it as like uh uh XYZ. Okay. For a time being. And 2:34:38 here you can just give a description or you can skip this and you hit on copy. Then what system does it will start copying the environment. Okay. Normally in a new system or in a company specific system because environment number would be less right system can create environment very easily but sometimes in practice systems although this is a one-time activity you don't need to do that but I'm showing you so that you it would be useful for you in future whenever you have to create it okay so whatever planning we'll be doing we'll be doing under this environment okay so let's try okay I hit copy sometimes error also comes because it's a copy it's a you know server it's a practice server so but don't have you know think that what's happening because this is the standard and only way to create any environment so you can see when we are creating the environment our own environment okay 2:35:38 which is nothing but we are copying the standard environment shell so what is a standard environment shell uh we'll discuss but you can see flow entity, category, account. Okay. Now, what are these? We will take uh later. So, some activities going on. 2:36:16 So that's in prog progress and it depends on the speed of the server as well. Okay. But it won't take much time. It will be done soon. Okay. So you can see we have created a environment our own environment which is planning_xyz. So this is the environment which we have created. Okay. Similarly when you are going to have a planning implementation or something this is the first activity recommended activity to do that. Okay. Now what environment does right so whatever activity we will do whatever application we will build reports dimensions our data everything would get reside under this planning_xyz so how does it plays a role whenever we you know move anything from development to quality okay you would see lot of time that it's recommended to always applying your environment right now you can see These environments are online 2:37:18 right you can see online online online right so that's a prime activity when you move any data I mean any any object from your development system to quality system and so on to production you always need to at least uh make it offline while taking the backup and restore that also we'll see okay so if uh if I don't cover this then for consultants sometimes it becomes a tricky area that okay what exactly needs to do because they never interacted on this area. They simply just log in and start building anything on environment shell and if environment shell is having issue your whole application everything comes under you know that area where you can't do anything. So it's always recommended to have a separate environment in case if anything needs to be changed or modified at least you have your safe environment shell. So is it clear right now? You can see it's online. What we can do just click on 2:38:20 this one and click on connect. Okay. So since it's 11.5 it's a little bit faster as compared to 10.1. So you can see now we are in our own planning XYZ environment. Here you can't see but in 10.1 you would see at the right bottom of the screen. Okay. But if you click on this one you can see planning_xyz. So far is it clear to everybody that what is environment how we can create it how we login and how we connect into it. So now we have our own area okay area I I'll refer environment shell or you know our own environment as our area our zone where we can do our planning. Okay. So what we have to do here some of the options are different as compared to 10.1 but they are just uh they are similar but just a look and feel look look and feel is little bit different 2:39:21 but the functionality remains the same. Here you can see administration but if you if you click on 10.1 when you click on uh top left corner you would be able to see models dimensions right security but here it's a bit different. So here we have administration. Okay. So for consultants this is the important area administration where what they do they create their own application they build the logic which works on the dimensions which works on you know particular model right they apply roles securities everything comes under this area. Okay, this my activities for the users which we'll discuss later when you define that what exactly what kind of activities one needs to perform so that whenever they login into this landing page they will see simply my activities or notification where they'll be approving or rejecting some request that's it. So that depends on consultants what right they gives to 2:40:23 other users. Okay. So this is the area which covers your overall planning and overall uh BPC application. Okay. Now here we can see dimensions and models. If I click on this I can see first dimensions then models. Okay. The master data but other than master data what does dimension covers? Uh so that is that actually answers that question what it covers. But what is dimension? So I'll I'll start on dimensions. So guys like uh in normally SAP module other than EPM. So this SAP BPC is related to enterprise performance management. Okay. If we keep it aside or you know keep uh some of the modules which are not the standard one. So if I talk about standard one modules of SAP those are SAP FICO MM SD right they all in in all 2:41:24 of them right what's the common thing is that when it comes to master data master data is residing under a particular table right as you as uh as you mentioned company code right so that is getting stored under a particular table right based on that a web consultant creates create some program logic or functional consultant does the configuration. Okay. And then you'll be able to see your screen which is good to capture any transaction which are happening at company level or at company code level. Okay. But when it comes to BPC okay so BPC is not a transactional system. Okay. This is a reporting system. This is mainly for the management for MIS reporting which fulfills MIS reporting needs. This is for the CFOs. Okay. Now if it's not a transactional system then how does it work right? 2:42:25 So any in any system in the world okay that is having two type of datas. One is master data second is transactional data. Transactional data is nothing just a figure which lies at the intersection of the master data. Similarly, if I talk about dimensions, okay, so in VPC, there's no standard tables which will capture a data for your business or for your client, right? So you have a dimension concept, right? So dimensions are like a info objects in terms of BW if I speak. Okay? if I say sorry. So that is like a info object right in BW but I believe if you don't know BW then again it's a kind of a different term for you. So I'll I'll explain it in a very very easy and common uh term. Okay. So doesn't matter from which place or which country anyone is. I believe 2:43:26 everybody is aware about the bank statement. So [clears throat] what does bank statement covers? Your name, right? Your bank location, your transaction detail, right? Your account number. So what's a unique information in your bank statement, your account number, right? Because >> a person with the same name, with the same entity is possible, right? But he can't have a same account number, right? He can't have the same multiple account number. Right? So account number is unique thing. So when I talk about account number, customer name, bank location, transaction amount, currency, time, right? All these are independent terms. But this is creating a a meaning to $100, right? Let's say a guy named Nick having a $100 who has done 2:44:28 transaction at so and so time from taxes location. Right? So all these informations form the bank statement. Similarly, what are dimensions? Dimensions are nothing but that covers you know your business, right? Your business. uh if I talk about business areas not like business area of SAP Eco but you know your I can I I can say like what is dimension okay see your profit and loss statement right if you see that okay what you would observe that okay my my income my expenses right what are the drivers for those right based on that you need to identify your dimensions and in in the end what should happen that your business for which you're going to plan for that everything should fall within your dimension. It shouldn't happen that okay something is 2:45:28 required for your business but that is not getting covered in that in your dimension if that is the situation you would not be able to plan your system I know right now it's hard to understand like okay what is dimensions because I'm not talking about any bookish term or you know any any anything it's totally related to practical right so I'll show you if you go to dimensions Okay. Now what you can see here account audit trail category entity flow input currency right so when you create a model right some type of dimensions you need to create okay so before that we'll see that what does it covers okay so for example if I go to account dimension this is standard dimension Okay. What it has ID? These are the 2:46:30 members. Okay. Which you will be able to see in your reports. At this level, you'll be able to do the planning. Okay. There's a description. Okay. This is simply like a SAP table. You can see right GL accounted stores. Now, after description, whatever column you can see, this is called or referred as property of a dimension. what you can refer it as a property of a dimension. Okay? Or in BW term you can say it as a characteristics of a dimension. So account is a dimension right which is very important dimension for any any BPC or any EPM tool. Okay. So by default system has generated couple of kind of properties which you should focus here which you should focus upon account type. Now what does account type suggest? It tells you about the nature of a 2:47:32 account. Okay for example balance sheet it's of asset type. Okay. So right now it's a standard one. So system has already created it. But when you'll be creating for any project or for your company right then you'll be able to fetch it from SAP system as a master data okay there if they have maintained it then you can see that else you need to maintain it manually or you can upload the master data from Excel sheet and then you have to check here that okay is it mapped against the against the correct account type or not right what's the impact it's having that we'll cover in our reporting area. Second is like you can see it's having like rate type by the closing average right so these are kind of a standard properties which are associated with the dimension called as account okay and this is having a hierarchy. So 2:48:35 there are two kind of a dimensions okay one is like you know the system generated one second is like userdefined okay for userdefined you would be see able to see this as user defined U1 okay and for all the standard one you can see easily type as account audit category entity and currency so that was about the base of a dimension now how to create the dimension what we can do on dimension that that we'll see in some time but before that is it clear that what is dimension how it works I mean how it works I'll I'll take it further but uh what is it that's about dimension but how to create a dimension right that's a major activity which keeps on coming at consultant's end okay now why does it keeps on coming because in any BPC planning project what happens you know You start to build your 2:49:36 application, you start to build your system, right? And during the build you realize that okay your data is also coming uh you need a data at so and so level. So for that that information is not getting captured in your existing dimension. So you need to create a new dimension again. So that's why you create a new dimension. In other tools like Hyperion, Oracle system doesn't allow you in between. in VPC you can do but some exercise also needs to be performed as a prerequisite that also we'll cover later okay so how to create a dimension okay click on new and create any idea uh any ID you can create it like uh I can create my own dimension by my own name okay I all I have to do is like I have to choose Choose what kind of a type this dimension would have so that associated properties standard 2:50:38 property I don't properties I don't need to create they will be created by default only I need to change it for example if I create it here as like planning let's say planning account okay now there are these type of dimensions I can see right type of dimensions category audit entity through currency subtables time and user defined. So which type of account dimension I should select from this list? It should be account. But in caseh if I don't want to create it for like you know as a standard one then I can go for userdefined. Okay. So for a time being let's go for account and I click on create. So this is the screen where we came now. Okay. What it has it's having properties as account type okay rate type scaling 2:51:39 scaling is just how you are showing in a report right now what it has okay it's asking from referential integrity for rate type okay I can select here right we will we'll discuss here uh we'll discuss later uh in our model part about this one but now it's saying it's it's asking for hierarchies. Okay, if you want to create any hierarchy, we can give any any name. Okay, like add and you can give like parent one. Okay, and save it. Any name you can give of this hierarchy. Go to back. Click on back. Now what you can see need to be processed. Okay. Select your dimension again which you have created and click on process. Do you want to take environment offline? 2:52:40 I know that. Okay. I'm not moving any object, nothing. Right? So I can select no. Now what it will do? It will process the dimension. But understand here when you'll be doing processing it's not uh you know uh that easy. Many times you would observe few errors. Okay. So you need to you know uh clear those errors then only you'll be able to see this process. But what about if it never get processed by this one then there's another way as well which uh will get covered into models. So this is how we can create our dimension called account. Now let's go into a planning account. Now what it's having it it's having nothing. It's a blank dimension which we have created. Right? We have a option of creating a cop creating a dimension with members by copying the dimension as well. Okay. Now we have created a hierarchy with the name as parent one. Okay. You can see 2:53:43 here we have we have given it name as parent one. That's why it's showing parent one as a hierarchy. Okay. Now how does it work? Okay. So now what I'll do I'll I'll create a dummy account. Let's say it is like GL 0001. Okay. And I can mention here any any description you can give it. Okay. Inc stands for income account. Okay. In parent I won't do anything. Okay. Now again I'll create a different account which is like GL00002. If I try to create a account with the same name, should system allow me? Definitely not. But sometimes you know when we populate the data or uh you know we we pull the data then uh you know we do some mistake by transformation file and all and then system won't allow us right? If you see here it would say like ID is not unique. 2:54:47 Okay. So it should be unique as I made it unique system has turned red into green. Okay. So now we have GL00001 002003 right. It doesn't have any parent all are children member or all are you know independent members right? But if I create another account uh the name like let's say GL and I put here suppose this is the this is normal member right but if I have to I want that 001 and 003 should fall under this one what I need to do I'll I'll mention here gl parent name Okay. Now what I need to do I'll click on save and process. Do you want environment 2:55:48 offline? Say no. So my dimension has been processed. Okay. So when you see this data okay whatever you can see under the dimension this under the column ID we refer them as a member. Okay. What is it member? It's a member of a dimension. Okay. What are the other columns? Account type, rate types. These are the properties, right? Property member inc. Okay. And to a dimension overall GL dimension, we call it as a master data, right? This is our master data. So you can see we have created it parent as GL00. Right? Now what does it do? Right? How we can see that? So if we go here and click on hierarchy, we can see a hierarchy view. If I expand it further, then I can see GL00001 GL00003. 2:56:50 If I have to change the structure, I can go back to list. So this is how you can create a member and this is how you can create a hierarchy. Okay, which will play key role in your reporting and in your requirement. Okay. Now here couple of things uh I need to share with you. Okay. So when you create a create a member ID. Okay. Always try to create a you [snorts] know a very straight one and easy to understand kind of a ID members. Avoid using you know many underscore in that because system won't allow you after some time. Plus if you have included capital letter here, right? Make sure because VPC is a case-sensitive tool. Okay? When you will pull the data from master uh from SAP, okay, when you will update any master data, any transactional data to a flat file, you would have lot of issues 2:57:51 because of this case sensitiveness. So always make sure you use the correct and the same name which you have used already in your members. For example, in order to create a parent one, right? I use the same name in the same case sensitive format, right? It's in everything is in capital letters GL. It would have been GL in small then it would not recognize it. Okay. Let's say you have GL 003 uh sorry not three 004 okay let's say you have this much of data okay what you can do either you can copy directly simply copy it go here and click on add and just paste it here right system would allow you to do copy Copy paste. Else what you you can 2:58:51 directly copy whole Excel in one go and just put your cursor here and paste here. Okay. Or you can upload the Excel file which you have. Okay. That that is known as flat file upload in the dimension that also you can do. Okay. Since we have like uh copied the cells so it's better that at least I put the properties and we can use it further as well for our testing. 2:59:45 Okay. So what we have done we have created few members. Okay. We have added property description. We are skipping for a timing. Okay. And then we have created few parents as well. Okay. We have tagged few members with the respective parents. And let's see how system goes. If I click on this. Do you want to take environment offline? Click on no. So this time IDE system shouldn't allow me. So you can see it's not allowing me. Now if I see the details what what you can see. So guys uh we'll be also taking all those try to you know take those issues which you would have have in your you know uh implementation days so that you would get some experience as well and because uh this training purpose is not just to covering the sessions right it should also give you some exposure right okay now what kind of error we can see first is like 3:00:46 start validating member formula and validating the member hierarchy. Okay. The member changes are allowed by BPC component so and so. So mostly it's related to and validating member formulas. Okay. Now can anybody tell me that? Okay. Because we have already created these as a members, right? Why system is throwing in the error? I'll make it more easy for you. We have already created GL00001 002 and GL 0, right? Then why there's error coming here? So you can see even this this sounds or when you look at it it looks very small issue but it can you know take a lot of time during implementation because you know there would be a lot of pressure of you know timelines or creating something then consultants miss this and they tend to lose time that okay system is not allowing you something is happening 3:01:47 right. So always make sure that you use the correct uh characters. If that's in capital letters, same should be maintained in in that way here as well in the system. Else it would give you error. Then again I'll come here. I'll click on save and process. Then system will again show me the same error. It won't take much time. So you can also cross check again here from in the same way while doing the same thing. Now this time should system would allow me. See dimension has have been processed. Okay. All you can always see the details here. Okay. Now we have created few more members. We have seen what role the list is playing. Now we have created more parents. Right? Let's see how our data looks uh looks now right now. Okay. So what we can see now we have three kind of hierarchies GL0000 GL00002 3:02:49 and GL005 okay if I expand it further I can see it's having 8 9 10 if I go here I can see 1 and 3 on further expansion I can see 6 and 7 falls into one and GL0 11 falls under tree and this is what so you can see that you know how this parent hierarchy you know creates a impact on your dimensions design which you creates. Okay. So that gives uh you know a better look and feel is as compared to the list view because in list view right it's hard to understand until you have experience right you you can't understand what's happening what's parent one right but when you see the hierarchy right although now you can understand it because you know the concept now but if you see here right 3:03:49 you can easily see because of this pictorial representation that okay 8 9 10 are the members or the children of a parent 002 Right now you know that okay how to create this dimension how to create parent how to create properties what role they play right now let's understand what's happening when I create a create a particular member as a parent others as a children right whom I'm referring to as a children those are falling under a particular parent node right so the parent node like GL00002 is a parent. Okay. GL00008 910 are the children of the parent. Okay. So, BPC is a tool or maybe mostly EPM tool would use such hierarchy. I mean uh such terminology which you would be able to hear like parent and child relationship or it's like you know or in terms of SAP roa I can say in terms of 3:04:49 fico it's like you know group GL or subgl also right but now what's the difference here is that if you will be able to or if you try to save anything okay if you do any posting any trans any transaction okay at GL00002 level or to at any parent level system won't allow you BPC system won't allow you to do that okay where you can save the data only at the children level okay that is 008 9 10 I know that uh you know you you are thinking that how what I'm talking about all of a sudden right because if you're talking about parent and child relationship then this is just to know later you will see and realize that okay how the system is working so in BPC you can't save the data at parent level right you can only save the data 3:05:50 at children level so that's why it's very important whatever you know uh report you are having or input form right you will be able to you are inputting the data at the base level or at the children level only else system won't allow you. So far we have seen that how to create a account dimension. Okay. Now if I have to create a customized dimension let's say. Okay. So for customized dimension I can take and I can create anything. Let's say I'll I'll create as a model. Okay. any any description and here you would select userdefined because you know that it's a customize as per your requirement you are creating so you need to create a userdefined when you will create it system would not create any standard property or 3:06:51 characteristic properties and characteristics are same characteristic I'm referring in terms of BW terminology property I'm referring in terms of BP PPC tool. Okay. So if I click on create now here what I can see scaling is just you know number of zeros which you can see in your report or that depends on your you know look and feel. But other than that you are not able to see any property here. There's no property. It's completely blank. Right? That's the difference between the standard dimension and in the userdefined dimension. For any requirement during any implementation phase or project phase, you feel that okay you want to have the data but you don't know under what category that data should fall. Okay. Then you create a userdefined dimension which is a customized dimension. Okay. later if you realize that okay some of the properties which 3:07:52 you need you can create it in your way or you can copy as well okay so this is my customized dimension I won't do anything here if I have to create like uh any anyone asked me that uh can we create a multiple hierarchies you can create multiple hierarchy as well okay click on Save. Now this is what we have created model. Right? Now what it says need to be processed. So if if there would be any error okay in the dimension when you created it even if you process it it and if it turned into red or in the same zone then it means there's some issue in the creation. how you can uh rectify that that we'll uh see later. Okay. But let's say if I have to process it what I need to do I I have to select it and 3:08:55 then hit process. Select no. Okay. Now it has turned to green. You can see processed. If we go there what we can see there's a blank dimension called as model and having two parents parent one parent two and let's say if I create a member okay you can also practice at your end by creating many dimensions Okay. 3:09:43 Okay. I hit on save and process. So my dimension got processed. And if I click on hierarchal view. So what I can see one ABC right now. This this this I can't see anything else. So I'll go again. >> [bell] >> Now why I'm not able to see it as a parent 10,000 as a parent. Now we are clear about the dimensions. How to create the dimension? Okay. Now we move towards model. So what is model? So functionally functionally you have uh very well uh you know articulated that uh our structure right. So technically what my structure is? My structure would be based on my dimensions. Okay. A model is you know uh I can say a 3:10:46 view or a overall area which will encapsulate my application right in environment shell it would be my model right. So my model would be dependent on would be created based on my dimensions. Okay. So I'll one thing more because I'll be referring model many time. I don't want you guys to get confused because of this one. Let it be. Okay. Now model. Okay. So if you have observed here right under administration the first thing you can see is a dimension because that's the first thing which one needs to understand what role does that play right what's the use of that and then only we can see models right so model is my structure of the application right which is made up of 3:11:48 my dimensions okay so I can create any kind of a model. Okay, for example, planning model, rate model, ownership, consolidation, you can see here, right? Now, what's the difference between these? Okay, in any EPM tool, right, uh when it comes to do planning, right, that's the most uh unknown part, right? And it it goes uh you know client to client that okay how one can do planning in what way right because there are n number of uh ways to do any planning but when it comes to consolidation consolidation is very standard uh pack which SAP has released right there are particular ways which you need to follow right correct so not like consolidation planning is very open area right which you can create it in your own way. Okay. Now what's the difference? 3:12:50 If I click on planning, this is the standard model. Okay. When you create a model which is a combination of the dimensions, right? You can see to the right side model containing exchange rates. Right? Here you can see rates as a model. Okay. If I go to consolidation, what extra thing I can see here? Other than rates, I can see ownership as well. Okay. Now, what is ownership and all that? We'll discuss during the consolidation part. But in consolidation, whenever you do consolidation for any company, right? Whether the company is having a subsidiary or holding company, that relationship needs to be defined. Okay? For that we have ownership model where there's a data and then we can use uh ownership we can create a ownership structure in our uh consolidation right so for that we have a consolid 3:13:52 ownership model as well okay similarly if I go to rates then I have a rate model as the name suggest rates it contains exchange rates so what kind of a dimension you can See category, currency, account, entity and time. These the combination of these dimension forms a structure. That structure refers that what kind particular kind of a model it is. So this is relative to a rate model because it's having a currency it's having a rate related accounts rate related entity time as well as category. Okay. Anyone having any idea about category? Okay. So category is a type of a dimension. Okay. So uh guys as I have suggested you you can you know login into your server you can create few 3:14:52 dimensions. There you will be see able to see that okay other than account there are other uh dimensions as well which are standard ones right what difference that is having that's the difference of the properties which you'll be able to see so category what does category contains it contains what kind of a data I have whether this data is actual data budget data or forecast data so basically nature of the data this dimension covers so we refer it as category. Okay. Now if I have to create my model. Okay. How I can create my model? There are couple of ways to create the model. Click on new. Okay. Any any I any anything you can you know uh give any name. Let's say planning is already there right? I can give like XYZ planning. This is the name of my model. 3:15:54 Okay. Planning model for XYZ. Click on next. There you can see under source model there are two options. One is my blank model which would be completely blank. Right here I can start from the scratch. Second is existing model. If I click on existing model, I should be able to see these four options, right? Rate, ownership, consolidation, planning. Why? Because these are the existing models. That's why I can see only these models. If I select rates and try to create then no matter what name I have given the type of model I'll be ended up is of creating I'll I'll be ended up creating is of rate rates type of model right which I don't want. So what I'll do I'll click on blank. Now go to next. Okay. Now what 3:16:55 I can see here I can see reporting. There are three options. One is consolidation. Second is financial. Third is standard. I know that I'm doing a planning. So I don't definitely don't need to do consolidation. Now comes two options whether standard or financial. What does the difference it makes? If I click on financial just observe to the right side. If I click on financial, did you see the change? It is showing the option of rates, right? >> Yes. >> Right. It's showing the option of rates. If I select standard, there would be no option of rates. Okay. By mistake consultants forget to select financial they just 3:17:57 hidden on a standard and select next when they create it later they identify that okay they don't don't have standard rate model why the rate model is not connected to my planning model because my model type is standard so always go with the financial ones when you have to go with the financial ones whenever you have the requirement of having a currency conversion. Whenever you your company is having operations running in uh you know many other countries having different currencies by doing this you don't need to again do uh again need to do any any script logic or programming to fetch the data from other models. Automatically your rates is associated with your planning model. Okay, is it clear? Always select financial when you need to select financial whenever you need 3:18:58 having a need of currency conversion or you need exchange rates. Right. Never forget to select financial. Okay. Now other thing what you can observe here is a key figure length. Okay. Now there are two options large and normal. What does it suggest? If you put here your cursor, you can see supports up to 24 digits before a decimal point and seven digit after a decimal in transactional data. So I believe you all are expert financial expert. So have you ever seen a transactional data of 24 digits which is required in any system? I never seen that. I still remember in you know back you know it's like seven to eight years back in one of the project right uh they selected normal but you know issues were coming SAP was not able to 3:19:59 support because of the large volume of the data then we had to select large right it resolved that issue for some time but then it it invited unidentified lot of issues again right So since then I never use this option. I'll again suggest you not to go with a large one because that depends on your hardware right on your sizing as well as your memory of the system that is been decide that is being decided and driven by your basis consultants correct who are taking care of the server. Okay. So go with the normal one, go with the financial and hit next. Right now for example, this is a practice server. There's not a lot of data. Let's say here maybe it allows me but during the implementation once it has lot of entries and all then it will throw me errors. Okay. But that you need to take 3:21:02 care of it while creating the model since start always go with the normal. Okay. If I go to next screen to the bottom of this pop-up, I can see in red. Right now it's coming in red because it's 11.1. Okay. But you will be implementing on 10.1. There you won't see it in red. Right now what does it suggest? You must select one dimension with the following types. Account, category, entity, currency and time. Or I should say you can't create a model in BPC without these five dimensions. These dimensions are must to have to create the model. This is a SAP certification question as well. This comes in the exam. Okay. What are the mandatory dimensions or sometimes it may happen or it might 3:22:03 happen again or maybe in future you will come across many BPC consultants who claim that okay they are BPC consultants. Okay. If you have to examine them simply ask them that okay what are the mandatory dimensions in the model. Those who have actually worked they can explain you. Those who never worked only theory concepts they have they can't do that because they either they they have learned it but they they won't be able to remember or recognize that right because they never created a model. Now these five dimensions are required. Why these are required? Because these are the five dimensions which gives some meaning to my model as well as to my data. without them data would not be completed. For example, I need a GL account, right? For any transaction, I need to tell the system what kind of a category, what kind of a nature of the data this is, whether it's related to 3:23:05 actual, it's related to budget or forecast. I need to tell the system this transaction is related to which location that's why entity is required. Then of course currency, right? whether this is USD, euro, INR right and time under which month this transaction happens right so if I select these five dimensions although these are the standard ones right but I'll I'll choose what we have created so what we will create whatever you will also create you'll be able to see here right you just need to drag it down you can see planning account this is what we created if you remember Right? See in standard model also you are telling system that okay what is your reporting currency okay so by default you can select it doesn't matter that you have only one currency you just keep it there right how that will make an impact I'll I'll 3:24:06 show you in the reporting part but yes that is mandatory to create then comes my category then entity and and currency. Okay. So for currency I can see reporting currency here as well. And I believe I saw input currency as well. So if you don't need I can unselect it. I can choose this currency as well because the dimension type is of currency. So as I selected the five required dimensions you can see it has turned to green from red. Right? because we have fulfilled the requirement and this is the interview as well as exam as certification question as well right what are the important dimensions to create the model okay now click on next copy from source okay before that I 3:25:09 would like to show you again >> XYZ planning now we have been you know talking and uh you know working on BPC front end. In the beginning I have shared that okay BPC covers three areas. One is like EPM which is for reporting. Uh one is second one is BPC web link. Third one is like my BW my back end right. So why did I stopped here to give you a realtime exposure how it will work? So what we need to do we have to go to BW for HANA. So, so guys this is BW for HANA right you are practicing in the latest server but in your company it would be 10.1 so you would be able to see only BW just double click here okay and then when you'll be able when you'll be logging into 10.1 okay where you will need to look at the changes which you are doing 3:26:10 at BPC right you have to use the transaction code as RSA1. Okay. Once you do RSA1, then you would be able to see info provider that detail here, right? But this is BW for HANA. This we won't use. We'll be using which one? We'll be using list cube. What is it? List cube. Easy to remember. A list of the cubes. Info provider. Okay. As I said model is something which consists of dimensions. Model is info provider. Dimensions are info objects. So that is why it's a very easy transaction code to remember list Q. Okay. Now in info provider if you go there right this is the list which contains my model 3:27:13 my dimensions which are either exist in BW or in HANA studio or in VPC. Here simply one thing more I would like to show here. See, you can see so many uh you know descriptions here but these are not related to BPC. How do I know it's not related to BPC? Because there's a technical naming convention which BPC follows. If anything related to BPC, right? That has to start with CPM. CPM is the prefix. Is it clear to you? CPM. This is also same in 10.1 as well CPMBB. The only difference is that in 10.1 you will be using the transaction code as RSA1. Okay. There you will be able to see a 3:28:14 info provider list. Okay. One of them would have this naming convention to the right side CPM. If you expand it further then you can see your environment shell. Okay. But since this is BW4 HANA right so here if we have to identify we can directly search the name right but before that uh I wanted to give you that exposure that how my data is getting saved under what technical name so always it's easy to identify which component is related to BPC just look for CPMBB is it clear to everybody See there are a lot of standard ones as well right but we don't have to do anything with those we have to just go for CPMBB1 the standard ones we can use it when we'll be deriving uh the data from SAP system clear so CPMBB would be the prefix this is the standard nomenclature 3:29:17 right so for example for time right if I expand it so this is the technical name for the time CPMBB B O D J H I K right so from CPMBB I can understand this is related to time okay now why we are here right >> I want all of you to know what we are doing in BPC front end we don't have to do the same thing at the back end we don't need to many consultants many clients are confused with this concept they think that okay we have to create it again in the BW as well no the answer is no we don't need to create it it will get created automatically okay it will be autogenerated by the system I'll show you how XYZ for a time being I just select XYZ 3:30:17 and I try to find it says not found that means It has not been created in VPC that's why it's not visible here but the moment we'll create the planning model there we will be able to see here okay so now we are going to see that the does the changes automatically gets replicated or not the exercise which we are doing same is applicable on 10.1 as well okay now I go here. Okay. I just click on next, next, next. Now here what I can see again on this screen it's revalidating review and create name XYZ planning. These are the dimensions and this is the type as financial. If for example by mistake if I would have been selected the standard I I can 3:31:19 go to previous again I can reselect financial. Okay. So always in BPC always review before hitting the final button. In this case create in case of reporting it would be execute. Okay. If I click on create system will start creating the model. So we'll see. So it says model has been created. If I go here, I can see these are the mo like these are the dimensions in my model. Category, entity, input, currency, accounts and time. Okay, is it clear so far to everyone? Now what I'll do? I'll go here. Okay, I'll select XYZ. I can see it's not found because that 3:32:20 pop-up window was already open. So I need to close it. Sometimes you need to refresh it. But let's say let's try again. I'll select XYZ. So what I can see now XYZ planning it was automatically created at the back end. Right? We didn't do anything. This is showing whether this is a cube, a characteristic I mean a info object or dimension or what is it? This is just a pictorial representation. Okay. For example, time our account, right? Model model we have created as a dimension, right? Correct. So whenever you'll be see model okay not this model the model which you create you would see this this symbol right all of the dimensions which I created they will be created as a info object so account product these 3:33:22 are the info objects okay and we call these info objects as a dimensions in BPC but here uh there's a difference right this this is just to you know link think what somebody refers in BW because your BPC is having a you know database as a BW. So to make BW consultants understand the terminology which we use here so that he can understand that okay what is dimension but I'll tell you what's the real difference between the dimensions of BW as well as B BPC as this in BPC you can actually create dimension based on client's requirement based on understanding and everything that covers your functional part as well but when it comes to BW based dimensions right those are just the info object which are nothing just a columns having the data of any legacy system doesn't matter whe whether that makes a sense or not they just create it okay so just to make backend team understand right we 3:34:26 explain them that dimension is my info object so that for them it's just a technical name that okay info object is this this this right but we understand because since we are the one who are driving who are creating the or you know planning or consolidation project how it should you know correlate correlate with them. So that's why just for explanation we explain them in that terminology as well. So is it clear model you can say right info cube as you can say info provider also you can refer right plus always you know uh avoid using say characteristic because characteristic is just a property of our dimension. Okay. So what we have done we have created XYZ as this our model. Okay. So you will come here on this screen you will select it. You can see that technical name was autogenerated by the system. We didn't do anything here. Now 3:35:26 what to do? Execute it here. Field selection for output. Click on it. Select all characteristics. All characteristics means those are the those which are important field right they will get selected right you can see we have dimensions like category entity currency account time as well as signed data as well we can see did we create assigned data yes it's system generated but why system is generated so remember whenever we will do any any you you know uh anything in BPC right any data we will save that will get saved under this head heading or header you can understand because since we this is the first class as a signed data sign data is nothing that stores our transaction amount okay request this is nothing you 3:36:28 can uncheck it click on click on execute Okay. And then again execute it. So you can see this is my database. Right? Now it's blank. This would be same for RSA 1 transaction as well. Right? The only thing is that in transaction in RSA 1 when you will be hitting for example if I show you. So such kind of a screen you can see in RSA 1. Similarly, same like this screen. The only thing is that here you would be able to see you will you will be able to see info provider okay by the name CPMV. So what you need to do you need to expand it then you can see XYZ and similarly you can you will double click on that part right and then this screen will come this one where you will be doing the selection and all. Okay, list uh it's 3:37:32 list cube and in 10.1 it is RSA 1. Okay. So right now we can see that okay we are in our cube. This is the second area. Right now it's blank. Right. As we do some transactions as we start working on our dimension members then only we'll be able to see that okay how my system is playing the key role right how my data is looking and all. Okay, I go back again to my model. So this is my model. Okay, which is XYZ planning how it's looking at the back end? I can see here right this is the technical name. Okay, these are the same dimension name what you have created same you would observe here as well. So what we discussed today what is dimension right? How that works? What type of dimensions 3:38:33 we have? How we can create models, right? How my model is working based on my selection as a standard or financials, right? What type of models I can create? How I can create whether blank or with the existing one, right? How my database is working. Okay. So this model and dimension is clear. I hope it it's clear at BPC weblink level right I'll refer it as a BPC web link. So at this uh in this component I believe this is clear and in BW I believe it's clear to you as well right that how my dimensions and model is looking correct remaining is this EPM. So how these three are interlin with each other why these three fulfills overall VPC application right. 3:39:34 So we have seen that what we are doing in the front end same changes have been replicating uh same changes are getting replicated to the back end as well right but what about EPM then right so that we will see now okay so far uh suppose if if we are in this hierarchy okay now here what would happen if I expand it further right if I understood your question correctly Right? If I have uh let's say 100 in this account, 100 in this account and 100 in this account, then you are asking me that at GL00002 like how it can have 300 would it be auto add auto auto rollup or do we need to any uh do any aggregation right? So okay so I'll be sh I'll be I'll be showing that in in this sheet I mean in the report but any choice to answer your question the thing is that since 3:40:36 whatever we if we maintain as a parent and child whatever child would have right that is getting autopop populated or auto rolled up at parent level so we don't need to do any aggregation for that in BPC that is automatically ally happening. Okay. So the parent would always be summation of its children. Similarly, if let's say I want to enter 300 at GL00002. Okay. And I want that what I entered here, right? System should allow 100 to each of my children. Right? That is not possible in VPC directly. Okay. But if somebody has to do it or having such kind of requirement right that we call it as a top-down planning okay normally we we go with a bottom up 3:41:37 planning but the scenario which I'm talking about is like a top-down planning. Okay. So how to achieve that? So for for that we need a ABAB consultant. Okay. Who will create a body program. Okay. That's a body. I believe all of you are very well aware about the body, right? The program, the announcement. So what he will do, he will create a write back body which will write back the data to its children from the top end. So this is what happens. Okay. So that's how he will do. So we don't need to do that. We can explain our requirement. they will use the standard enhanced functional modules and they can do that. Is it clear? It's only possible through body when it comes to writing the data at parent level and allocating to the children level. Not just in 10.1 even in 11.1 also it 3:42:38 goes in the same way. Okay, we are on this screen, right? Which is just a Excel sheet, right? Excel file. You can open any Excel file. I'll open it from the scratch. So, what I need to do, I have to go to EPM. Okay. So, there are two tabs before I log. Okay. One is EPM, another one is like data manager. Okay. Now, what does EPM do? EPM tab helps you to login or to open any input form or any report which you have stored in your EP in your BPC. Okay. Whereas data manager helps you to run and to execute any calculation. For example, in SAP standard you do F8, right? You do F8. Similarly, you can execute the program or I mean any 3:43:39 calculation through a data manager package. We will uh take it later as well. So this is the third component of BPC which is my EPM which is enterprise performance management. The look and feel is same like an Excel sheet. Okay. You have to login now before you log. Okay, you will have a connection thing, right? You have to go here. How to set up a connection? If you try to login, let's say by your credentials, okay, situation may occur where you will not be able to see your own created model. How you have to so what you need to do right because you created but you are not able to see here. So in your connection name okay either create duplicate or go to edit okay enter your credentials 3:44:40 okay now here what you can do first check what environment you are into so we know our environment is planning XYZ I hope everybody remembers it right planning XYZ so that's the reason we created our environment because everywhere you will be seeing environment I could have ended up that in 30 seconds but then later you will be able to you know you would be coming and asking that what is environment why we didn't cover that's the reason I I covered that and I created from the scratch so that you can relate it so what system is saying now select environment we select ed our own environment. Now we'll be able to see our own model else we can't see that for example would have been selected let's say zarent BPC and I could go for model and 3:45:40 I'll be ended up choosing a wrong model because I can't see planning model right so that's the reason select first your own model on environment under your own environment you can see your model Okay, I can create I can click on okay as well and next time then I'll be logged in. I'll be def I'll be by default login into my own model as well. But other other option what I can create? I can create generate connection name. I click on this. So what it's showing me XYZ planning planning XYZ. I know the name can be confusing to you, right? But this is just for an example we we created, right? I click on okay. As I clicked on okay, you can see now the connection name has been changed. So this is the important activity. Whenever you'll be logging into any EPM system, right? How to create a connection you should be able 3:46:40 to know else you will have you will be struggling that okay I'm not able to create my connection. Okay, is it clear? I'll again show you what you can see here is server URL bw4hana.st ST this /BPC this by default system would show you this BPC/ this and then HTTPS this thing you need to take it from your basis consultant or you know any IT head of your company they will share you the link or you can explore the same here as well this BPC link also you can copy here and you can paste here. Okay. Is it clear so far? So this is how you can create your connection. So once you can create your connection, hit on okay. Uh export uh export is not 3:47:44 possible. I'll tell you why. Because see uh we we create uh for example it's a server right? If I have created it, chances and possibilities that you know you'll be logging in from your your end from your ids and you'll be able to see the same connection. But when it comes to system, right? Every user first time they are logging in into the system, right? So by default that's the first activity which every user every consultant needs to create it at their their end. So far it has not been replicated but but in case basis consultant right says that okay they have single sign on facility then you might not need to go with it you simply click on log on and you don't need to see that but in that case also right that shouldn't be recommended because they don't know which model and which environment you will be logging until 3:48:45 that is the only thing you have in uh application. So now we have created the connection. So we'll be logging into EPM. So for that 3:49:06 now this is the EPM. Okay, EPM addin is the software name, right? If you have to install it, right? uh right now in server it's available but in your company server you can ask it I it guy or you can ask your uh basis consultant right that I need to install EPM only when they will install EPM addin then only you'll be able to see these two tabs EPM as well as data manager okay and many times the question comes what kind of EPM right what version so for that you can click on about EPM Right here you can see the version 10.0 service pack 34. Right? Depending on the company on the hardware this keeps on changing. Okay. So the BPC version is of 11.1 here as you have mentioned in your company it's 10.1. Okay. So what I'm doing the examples which I I'm covering 3:50:09 right that covers both 10.1 as well as 11.1. It won't happen that what you are uh you know uh looking uh at in the training sessions you will be having a completely different exposure in real time server. No, that would be completely same thing. Only thing is that look and feel is a bit different right for example here you can see the favorite library right dimensions something like that there you will directly see dimensions models okay other than that there's no difference you know like in iPhone we have like you know iOS 13 iOS 12 so and so that's the only kind of difference it's having otherwise everything remains same plus the back back end uh the server right because of the compatibility that is 10.1 is running on BW 7.5 whereas this 11.1 is running on BW4 HANA so this is 3:51:09 the EPM we have successfully logged on into our model which is XYZ our model planning XYZ of the environment planning XYZ right >> all right let's test your knowledge here's a question for you which of the following is not a module in SAP BPC 10.1. Option A, consolidation, option B, planning, option C, profitability analysis, option D, supply chain management. Take a moment to think, and when you're ready, choose the correct option. Remember, each choice holds a key to unlocking the answer. Good luck. Type the correct answer in the comment section. Hey there. Ready to dive into the world of SAP BPC 10.1? Our course is your ticket to mastering supply management all at your own pace on our platform. In this course, we'll unravel the mysteries of SAP BBC 10.1. Think of it like a Swiss Army knife for planning, 3:52:10 ensuring we've got enough goodies and getting them where they need to be. From the basics to expert tips, we've got you covered. Crafted by seasoned pros, this course delivers the goods. Your mentors, top-notch veterans in the feed, ready to guide you through and tackle any queries you throw their way. And hey, don't just take our [music] word for it. Our students are singing their praises. Folks just like you have found this course a game changer. Best part, it's easy on a wallet. [music] Learning doesn't have to cost a fortune. Ready to become a SAP VPC 10.1 maestro? Enroll now. For more details, [music] visit Zarantex website. Okay. So before we move on to server, okay, in today's session, we'll try to cover our uh try to cover about the data manager package. Okay, these all are standard ones. And if you want to see that, okay, which one is your environment, I believe you have created with the name NG2. Somebody has created with the name NG2, right? >> Natrajan did you create from NG2? 3:53:14 Okay, because the reason for asking is that because at my end when I just logged in into the system and where the screen got hanged so the environment is NG2 so I thought maybe somebody has created so any which way so here we can see that environment shell is there okay that's of a standard one you can directly hit on it click on copy create the environment okay and then system will uh take time depending on the server okay since it's on uh 7.5 so the Look and feel and screen layout is the only difference. Other than that there's some performance. Performance is like you know BW for HANA which is uh which on which 11.1 runs right that's a bit faster as compared to 10.1. Other than that everything remains same okay and also one thing more like in case if you all are working on the same engagement okay of any planning project. >> So make sure you only create one environment. It shouldn't happen that everybody is creating different different environment right your models 3:54:15 can be different like like for example sales model right your uh you know capex model finance model those you can create separately so that you can have ownership but make sure your environment remains same okay so today other than create other than you know knowing about how data manager works what are the prerequisites what are the you know activities how it uh you know function questions. We'll also see how EPM report works right what's the role of the data how that makes the impact on the system what's the role of my BW system as well okay so those all scenarios we'll be trying to cover in today's session >> thank you for the confirmation sir >> thank you thanks for your support okay guys for a timing now we are on 10.1 okay so I'll just connect with any environment. Okay. So I'll go with test07 environment 3:55:19 and let's see does it has any models. So it has a standard planning models. Okay. So okay in my last session right when I was discussing about you know how BPC web link plays the role right as a consultant when basis team will share the BPC web link with you right that this is the portal where you need to login with your credentials right so by default right this is the landing page of 10.1 okay here you can see environment is right at the bottom okay by default fault you will be in environment shell. So you need to do the required steps which we covered in last session by copying your own environment. Okay. And then you create your dimensions as well as models. Let's say uh within your company right uh I believe you must be in-house team right 3:56:19 who's responsible for doing the you know planning or implementation. But let's say you also you know sign up a contract with some other company. Okay. working on your planning project. Okay. But you want everything keep confidential. You don't want to share with them. So do when the server is same, right? As you rightly mentioned, in that case environment is the best thing because that allows you to give access based on ids as well. So what they need to do they have to create their own environment and you'll be working in your own environment and they won't have access to your environment. So they can't access your models, dimensions, whatever design you are having. Same goes with you as well. If they put authorization, you also can't do that. So that's why it's good to have environment. Okay. And also other thing is that if for example mostly BPC goes for planning as well as consolidation, let's say both are having dependencies, 3:57:20 right? If both planning and consolidation somebody starts uh doing in one environment and they have to move from development to quality. Let's say consolidation team says that okay we are done with our design our testing now we are ready for go live right and they want to move their whole application uh there are two ways of moving the objects one is like through the transports seat you will go and create the request okay then you will do the you know sep traditional way by SC09 or SC 10 by releasing the transports second is you will you know take the backup of your application ation. Now backup of application can be done on environment level. So what they would do if they are having different environment they will simply backup and then restore in the quality in that way their work would not be dependent on you. But in case you both are in the same environment then they can't do that because if they do right then again whatever changes you 3:58:22 are doing because UAT has not happened then they would always have dependency on you. So it's better to have different environment in such scenarios. Other than that feel free to have a different model. Environment covers your model dimension report logic transaction data master data everything comes under environment >> and the beauty of it is that in BPC as compared to other uh SAP modules in those you have to collect all the objects individually. here if you don't know or maybe let's say you don't want to do that simply take the backup which depending on the size of your data that takes hardly from 10 minutes to 30 minutes you just back up and simply restore you don't need to worry that okay like uh did I lose some object or not okay so that would that would simply create the same replica in the quality as well as the as well as in the production as well okay Okay. 3:59:23 >> But once you are go live and once you are in production then refrain from replicating or doing the restore of your backup because your your system is running right now. You don't want to replicate the whole application. So in that case you have to follow the traditional way of you know creating the transport and releasing that so that you can track that okay who has moved a particular object what impact it has made on my production system. So uh now we are in 10.1 okay and we have already uh like mostly standard models we have but we want to create our own model okay so what we will do in order to show you how data manager plays the role how EPM will work so let's have our own model okay because if we going if we go and again create dimension all then it will take time so what I'll do for time being we'll consider test 07 as the environment Okay. And I'll simply 4:00:25 copy this ID. We can give any ID like let's say 4:00:43 now the thing is that why we are copying the model when we already have a model right planning correct anybody's thinking in that way when we already have a planning model right Why do we need to create another planning model? uh since we are not aware that who has created this environment right at what level they are using these models have some data in particular this model right and if I want to remove any particular dimension from my model then system would not allow me until I clear that data okay right first thing >> so that's why I wanted to create a different model now the thing is that in case if the dimension is same right then we can create our own customized dimension but since it seems new okay so that's why and to keep uh you know uh our model look different as compared to other models that's why I have created 4:01:43 our own model as planning XYZ now few dimensions which I don't need I can remove them okay so if you have to remove or add any dimensions simply click on add remove and then you'll be able to do that and then you need to again save your model and I tell you planning and consolidation are the business concepts what matters is all these technical workarounds right because that becomes showstopper during the project if you are you know not aware or never touched such part of the system so that all we will try to cover during our session ions. So now our planning model is ready and we have seen that it has couple of different dimensions. So let's see what product has. So it's a userdefined dimension. 4:02:44 So it has product A, B, C. Okay, this can work for us. Not an issue. So now our model is ready. Okay. And we know how to create dimension. Now comes our EPM part, right? that what I'm going to do with this structure how it will work. So for that we have to login into our EPM. So what we need to do either we can create duplicate. So we'll create duplicate if somebody has created it. Then we'll select and click on edit because we want that whenever we login as this is one time activity on any project you have to do we want that whenever we login into the system by default we login into our own system. Now here two things one is like you are entering the credentials okay but in case if your basis consultant and your company decides let's give all the user single sign on option then you don't 4:03:45 need to give ID and password every time. Okay. Now here we will select our environment which is test 07. Correct? Then our model right which we can't see here. Wait a minute. Okay. So what's happening first? We have to uh this this part you know uh like we can cover later as well. But let me just go here. So actually we have to assign the authority as well, right? That okay which user can access. So this is the ID which I'm using. Okay. Can see data access profile. 4:04:40 So don't worry about this section. We'll cover in detail as well. But for a time being when you are not able to see your own model when you have selected your environment that means your ID needs to have that access. So the question which Mino asked that okay what's the use of having different environment and all so you can see menu even we are not able to you know login into our own system but now we have since we have admin access that's why we can allow it by going to data access profile. Okay, here we can select all members. 4:05:28 So the these are the security areas we'll cover in detail. Okay. 4:05:42 So earlier it was not coming. Why did it uh now why why we can see this? Because you have allowed the access okay in our security part. So that we'll cover in detail as well. So I have created the connection name by hitting generate connection name. System will generate the connection name with the with your model name. By your model name you can have your connection name and simply click okay. So this is where we have to loged in. Now we are into EPM. Okay. So EPM stands for enterprise performance management. Okay. So when basis consultant install EPM addin on your machine on your laptop then you'll be able to see two extra tabs in your Excel. Okay. One is EPM second one is data manager. Okay. So these two areas we'll start to cover in today's session. Okay. In EPM what you 4:06:44 have you can create your report. Okay. You can edit your report. There are many ways to you know make changes in your report that all functionality will get covered in EPM tab. Whereas in data manager this tab is used to execute the calculation to run the logic. Okay. That's why we use for that we use data manager. Okay. Now in EPM there are two areas you can see one is EPM context. So EPM context is having what? It's having account category entity measures product reporting currency and time. So what are these? These are the same dimensions which we have in our model. Okay, which is planning XY Z. You can always see the data connection as XYZ. 4:07:47 Okay. Now if we go there and if I click on models, how many dimensions can you see here in in this model? There are six dimensions in this model. But when I go here right in my EPM which is connected to my same model planning XYZ. Okay. How many tabs I can see in Excel in EPM context? Is it six or seven? So the measures is the extra one. Right? The seven >> even in exam or in interview this question keeps on coming right. Do we create measures as a dimension in BPC? Those who don't focus or don't don't know or having no exposure they say that yes we create but no this is not required to create system generates it. System creates it by default. What it covers? It covers like a look and feel 4:08:48 of the data whether it's periodic YTD right but we don't need to get into that because our this is our planning model. So you can skip this one. Okay. So never get confused that okay I didn't create measures what's the role of measures. Similarly in other you know uh counter tools of planning right as compared to BPC in that measures is something which you need to create but here in BPC it creates automatically you do don't need to do that in consolidation you can see that whether it's in YTD MTD so this is just to view the data okay so for in that regard we can use that same data stores what value we are passing in the system what input we are giving so that stores my transaction amount okay that's a different one okay that also we don't need to show in the system I mean in BPC but but when somebody will write the 4:09:51 body in a web program right they will mention sign data right so ne so never get confused that okay I don't have any field as signed data sign data is by default created which store which stores your transaction data. Okay. Similarly, what measures does you can view the data in different context whether periodic YTD that's the only purpose of it. Okay. So most of the time you even don't need to use it because mostly all the functionalities you'll be able to achieve by your report or by your client requirement what they have. Okay. Now how this EPM context plays the part that we will see but before that what we'll do we'll create a simple report okay or an input form. So there are many ways to create the report or input form okay first we'll take very straight and 4:10:51 easier one. Okay to the right hand side you can see report layout right correct these are having all my dimensions here plus we have page access row axis and column axis so any report is having three sections first is let's say my page axis which stores commonly applicable detail on the report. Okay. Or from where you can drive or select or make any selection based on which report will be driven. Okay. So page 4:11:53 access would be you know at the always at the top of your row and column. Okay. Then comes your row axis where you have any any dimension in your row and then you have your column axis. Okay, is it clear? I'll explain you further. Okay, when I create the report, but this is how you know the format of the report goes. Always whatever you can see at the top that means that's a page access. That's whatever you will do there that would be applicable for whole report and the report is a combination of rows and columns like in Excel normal report we have now what we going to do we'll simply create a basic report okay so there are many ways first we'll go with a very straight and easy one 4:12:55 I just drag account Okay. Similarly, I can drag time. Okay. Now, what are these? I just dragged account in the row and time in the column. 4:13:24 Other than that, there's another way. You can just drag put it under under row axis and then time under column axis. So what we did we put account under row access time under column access. Technically when I did this system should create you know a report in this manner. Okay. But it's not working because since I can see the data is older one. So we'll replicate with the correct data. So we'll remove it. Okay. Now I have this. This is my report. For a time being I close this. Now I want to understand what is it. Okay. So there's option called edit report. Go to edit report. Here you can see that you know in which column you want to 4:14:26 place your report. So you can change the position as well. Okay. Click okay. Now I can see my report is here. Okay. Now this Q1, Q2, Q3, Q4 this is nothing simple you know representation of the members of time dimension okay here what it's doing it's showing 2006 as a year okay fiscal year and having four quarters now if you double click on it because you know that this is quarter right here you can't save any data if you just double click on it it will get expand January February, March. Similarly for quarter 2 as well, April, May, June. This is for quarter 3 and this is for quarter 4. 4:15:27 Now this is for total assets, total liabilities and equity and balance sheet. So these are the these could be or must be a parent account, right? So let's do the same thing here as well. If I just double click on it, I can see total equity, total liability. On further doing double click, I can see share equity retained earning. If I click on double total ent total liabilities, I can see account payable long-term depth. Okay, see whatever you can see here total entity at the bottom at the top of it. These are the children of total equity. Similarly, long-term debt account payable are the children of total liabilities. Okay? Because you can see there's a change in the position. They are, you know, indenting towards right side. Similarly, total liabilities and equity is the parent of total equity as well as total liabilities. If I double click on 4:16:29 it, then it will roll down roll up again, right? to total liabilities and equity. Now you must be wondering that okay this is a bit confusing or it's not that straight and all. It's nothing like that. It's very easy. There are other ways as well right. But uh I want to you know give you all the you know exposure and experience right which you can have while implementing. For a time being let's go with this example. So you can see when you double click on it right it expands to n number of levels like depends on how many children it's having. Okay. Now what I'm going to do let's say I enter 100. Okay. 4:17:30 So 100 + 200 + 300 + 400 it comes around 1,000 right. So ideally when I enter when I input these numbers right and in my previous session I I I explained and I shared that whatever data you will input to the children it will roll up to its parent right so ideally in total equity it should show me 1,000 okay so before doing that what I need to do I just input the number right it's looking same like an excel right but where does it makes the difference that no It's not an excel. It's directly talking with the database. It happens when you save the data in the system. Okay. Now, how we can save the data. For saving the data, we have this saved data, right? Which is disabled right now. Okay. Why it's disabled? So, this is a report, 4:18:31 right? Not a input form. Okay? So, how to convert a report in input form? Okay. Those who know good for them I know they might be getting bored in this session that okay like how it's working but those who don't know for them okay you can go here in options sheet options and here okay you have to select use as input form okay all of you please pay attention always select use as input form and hit okay then only your report will be converted into input form you can see the save data button is enabled now okay if I refresh right whatever data I have entered here what would happen it would go why because I didn't save that in the database so before doing the required action right what I'm going to do I'll 4:19:34 show you TWW. Okay. So this is for 10.1 why I'm showing you why I'm going to show you because uh you know uh we have created the model we have created the dimension right ideally my back end right my database table that must be blank right so that I want to show you and what would happen if I save the data how it would behave how the data get restored into the database that all we need to know right so that's So here earlier it was RSA1 was in the use or RSPC but now you know the patch has been upgraded even in 10.1 as well. So you can use list Q here you would option you would have option to choose info provider. Okay we can search by the name. So this is 4:20:35 planning XYZ. Okay we know what's the name of our model. Simply search your model name. Execute it. Go to field selection for output. Select all characteristics. So we can see it's completely blank, right? There's nothing here. So I go back to my EPM. Okay. So as I said, BPC covers three components or three areas. One is like BPC web link. Second is EPM. Third is my database. So for all the those three areas as a consultant we don't need to do any any connection. It will be automatically done right. System will take care of that. We don't need to do any manual exercise for that. So we'll go with our example 100 200 300 400. Okay. 4:21:37 I'll click on save. Now it says four data records will be sent. Do you want to continue? As you hit on yes, what it will do? It will place it will save these numbers into the BW database. Okay. So what we can see if it would have been successful it could have shown it would have been uh you know showing accepted count as four but now it's showing zero rejected count four. So this is how you will read the error messages as well. The more errors you will get during the build or during practice that's good for your learning. Okay. So what's the error message? Total product of dimension product is not a base member. Okay. So this is related to total product. Okay. 4:22:37 Now I have selected accounts and time. I didn't select any product. Why it's giving me error for the product? See what we have in our report is like account. Okay. Here I mention account or I what I can do whatever dimension you select there's are options whole report gets driven by these four types only I go to sheet option okay and here in formatting okay I can select repeat row header sorry display dimension names Okay, now I again refresh it. So what I can see how many dimensions I have in my report? Two account as well as time. If I go here 100, 200, 300, 400 and hit 4:23:43 on save. What it does? It throws me an error about the product. Now the question is when I selected only account and time why it's showing me for the product. So it doesn't matter how many dimensions guys you will include in your report. By default whatever data you will input in the report it will always be across the intersection of the members of the dimensions. Now here we have EPM context. I can see my account is having balance sheet. Okay. Category actual entity consolidation entity measures I can ignore product total product. So this is the only dimension where the member is selected by default as a parent member that's why system is not allowing me. So the reason for showing you this example by 4:24:44 knowingly or unknowingly when you have to create you know many reports and all sometimes we forget to pay attention on our EPM context. Now how it can happen? It can happen because we normally just to save the area right to make it broader. We just remove it and then we think that okay everything is working fine but it's not accepting that is because of EPM context. So always click on this one. Okay here you are. So what I'll do I'll select other member any any random member I can select which should not be a parent. I'll select product A. Now what should happen if I enter 100 200 300 400 would it allow me to store or not? Yes, it will. So we can see accepted four saved four rejected count zero that means whatever we have entered it got saved successfully in the system. 4:25:45 I'll click okay. And now if I refresh it right my data would remain stay in the report because it got saved. So what I can see I entered 100 200 300 400 automatically system is rolling up total entity as 1,000. Okay but what about this one total liabilities and equity and balance sheet I didn't do anything here. Why it's coming? because my total asset as well as total equity are getting rolled up to I mean total total assets and total liabilities are getting rolled up to total liabilities and equity that's why it's showing 1,000 okay whereas if I expand balance sheet so total liabilities and equity gets rolled up to balance sheet why it's showing me negative negative sign 4:26:45 because of my account type property. Okay. Now let's check in the database. So this is blank right now. Okay. Just go back it. So you can see that now there are four entries in the system. What are those? 100 200 300 400. In BW backend system, you would not ever see any parent member data. Okay, that will happen only in EPM. Okay, automatically. So for BPC system never saves any rollup data understood always remember this from a conceptual point of view. Okay? Because it always saves the data at base level. That's why it will always save the data in the back end at base level only. It would not shoot any parent level data. 4:27:48 So we can see there are unwanted columns as well which you can hide it or what you can do you can go there right you can choose field select for select all characteristics other than dimensions whatever it is you can remove it right make sure you always select sign data which stores your transaction data which we just entered in the system okay and other than that if I remove these these are the properties these also you can remove it. Okay. So we can see this or to show you in a very short manner what I can do I can remove this because properties are not required to be shown. So earlier uh so guys earlier you know uh if I talk about two to three years back like you know uh these 4:28:50 options were not coming earlier like properties and all based on latest patch. Now the system is allowing earlier it was only showing you what you are going to save in your report. But now you can see whatever required properties our dimensions are having they all are getting visible in the back end as well. Because for back end it's simply a characteristic nothing else. Okay. So this is what we stored actually. Okay. These are the ids for my equity. Okay. This is my entity type of data. What kind of data? I just told this is actual kind of data. Although in real time scenario actual is something which will flow from other SCP system or you know any any other legacy system to your BPC it should get stored in budget category but just for showing 4:29:52 you this is the first time that's why uh we have used actual okay this is for product A and N is this is by default the property you can ignore this [bell] one and this is the currency okay and this is my sign data. Now here is my balance sheet a parent child I mean a parent node or a child node. So if I select let's say my product as total product system would not allow me right. So I had to select a child member. But here in account I have a parent node. Then why system is allowing me to save the data. Right? It should also be selected at a children node. Right? 4:30:52 Okay. So before I do refresh okay so the thing is that if you select any dimension in your report okay account time whatever only those would be the active dimension drivers I mean not drivers but you know you can say that my dimension would be driven by my report only not by my context. Clear? For example, if I I select I addit report. 4:31:34 Okay. Now what I did I selected product A. Okay. In my report which is the base level already. Okay. Now what I'm going to do I'll save the data. Okay, this time 4:32:04 so did you see system allowed me to save the data even the total product have been selected in my EPM context as well. That means whatever would be in my report they would get the preference not the EPM context but those dimensions which are not covered in my EPM report that will be running through EPM context. So this is how EPM context plays or it stops your work basically it it adds up the struggle right that why it's not working why this report is having issue so all such scenarios would help you and will make your you know experience much smoother when you'll try report at your end so what we learned that through EPM context we can select the members but those dimensions if they 4:33:07 are already in the report on that EPM context won't work. EPM context would be applicable only for those dimensions which are not present in the report or not visible in the report. And we'll take a look on our cube. So we can see budgeting entries as well, right? See, so this is the data we have created. Okay. So, so far like uh before uh we move ahead for data manager or for other aspects okay of the report right so let's see this if I show you here okay it shows 200 right now okay BS 211 okay let's see how it works I was coming on that part actually there are many other scenarios okay let's say we take 700 Now ideally 200 should get replaced with the 700 4:34:09 only one record which is going to save what we actually saved we saved 700 right so what it did system checks that okay 700 means 200 already there then 500 more right so it makes it 700 why because BPC is a software okay which basically works on you know accounting mode right debit and credit okay that's why it does the adjustment now for example if I have to remove this okay if I just remove it and save the data now what should happen it's zero right now what should system show me zero so what it will do it will do the entry in debit credit pay Okay. So you can see 700 right got knocked off 4:35:10 with these values having negative sign 500 700 minus 700 so that comes zero it will never save zero it will always replicate with a reverse number okay because it's working in accounting mode debit credit so in BPC there's a way to add comments okay but it has some restriction Okay, up to that level, you will be able to give comments. So yes, it has that feature as well. So that will be covering as we go by for reporting. >> How about the supporting document? For example, I have a document that I want to attach. So will you be able to attach? >> Document is something which you can't attach but you can definitely share a link of that. Okay. In that command because it >> comment section, right? >> Yes, it has a restriction. But as the other other new tools in the market right which are available in that there's no limit you can save any number 4:36:11 of pages as a comment as well. And the good thing is that here the commands would be you know uh more like attached to a particular report but there the comments will get overridden by the selection of data. So that's a good thing and that uh that is something you know which uh you can't expect because mostly we we expect that okay in our database numbers or combination of the data will get stored but you know that is using some different table to store that without having uh the same thing in our database. So like you know right now it's BPC similarly there's SEC for planning right SAP analytics cloud yeah yeah multiple lines multiple pages I would say there is no limit that one okay so we have seen that okay how to create a basic report how my child and parent node making an impact on the report when it comes to saving the data okay how EPM context play its role okay 4:37:14 in terms of driving the overall report. Okay. Now, other than that, if I have to create a fresh report. Okay. What's the other way? Right. So, for that what you can do, you have a edit report option as well. Okay. Here also you can see three sections. Page access, row access and column access. Okay. So, what we can do? I'll I can select here, move it or I can drag and drop. Okay, I put that under page access. Okay, I can go there. I can select individual member. Okay. And then I click on okay. I can I can remove anything. Okay. in my time dimension. I'll select all 4:38:17 and I just delete them. So now what I'm going to show you those are the real time problems and how to deal with that. Okay. So what we can see there the last updated year is 2017. Okay. And we are in 2024. So these members are not in the time dimension. Correct? So what we will do? We'll go here. We'll go to our dimension. This is time dimension. Right. This is where I'm supposed to make the changes. Agreed. >> Yeah. >> I'll go here and I can see that. Okay. They have a lot of data. Okay. As per the some requirement or scenario. What I'll do? I'll just scroll it down. Now I have to create 2024. Click on add. 4:39:21 Okay. I'll create this simpler hierarchy. 4:39:44 Sometimes it does because you know 10.1 is the you know uh older version which is going to have a sunset by let's say 2027 and it depending on the server right so whatever weird things you can expect you can expect up to you know uh this 10.1 in the system even in the realtime systems as 4:40:33 So what it saying that error exist in the member list. So we need to solve those errors. 4:40:55 I think that was that got created that's why it's showing that ID is not unique. Okay. So in here 4:41:16 Okay. So, our dimension got processed. Okay. Now, we'll filter. So, you can see that it's not showing 2024.06, right? >> There's nothing. There's no member. system sometimes does such kind of a weird thing then you can come back let's go again okay yes so BPC demands lot of patience with consultants as well okay the system has allowed us now what we'll do we'll come here okay we saw that still it's not showing What we'll do, we'll cancel it. Okay, we'll go back here. And again, it's not showing us, 4:42:17 right? Although we have created in our BPC web link, but that is not visible here in my EPM report. And on the other hand, we are saying that everything is connected. We don't need to do anything manually. Okay. So maybe let's click on cancel. Even I log off. I'm going to login again. Okay. 4:42:53 Okay. We are in the report. We have logged in again. Okay. I believe whatever changes had to be visible that should be visible by now. Okay. So although I have to do the same exercise I'll move it to page access so that I can centrally drive it. I'll select product C this time. I'll remove this unwanted parent node. I'll go to time dimension. So you can see that right now there's another way as well. Okay. Let's say you can't do you know log off login again and again. Okay. So for that ideally this is something which you should try when nothing is working for you. Okay. I'll create 2025 01. 4:43:53 So we have 2025 as well. Okay. Now in my report if I go here I don't see 2025. I just simply cancel it. Okay. If I go again and hit on time I can't see 2025. Okay. So rather than going logging and log log off again. Okay. What you can do click on more. Okay. And here you can click on refresh meta data. Okay. So that also does the job. Okay. So that you don't need to login and log off again. Okay. Go to time. See we are able to see 2025 right without doing log log on and log off right. Correct. So that's a easier way but uh 4:44:56 like uh mostly people are not aware because they never tried that. Okay. So this is the way and these are the issues which you will always have or you can have while having implementation because whenever you create a new member any ID you would be not able to see the report then what you need to do and this action you you need to perform either mostly go for refresh metadata that doesn't work log off log on again plus as we have just observed there was no unique ID but system was throwing the error simply Filter the option, right? Filter it out. If that is available, good. Not available, just go back and back again, right? Within the dimension and create system would allow you. So, this is a technical, you know, uh flaw of BPC 10.1 version that happens not just in server ones but also in real time systems as well. Okay. So you don't need to lose 4:45:57 your cool just have patience and try again. So it would allow you. So what we going to do? So this is the second way of creating the report. Okay. See if technically you are clear right then you can implement any scenario. It's just the terminology whether be it planning, forecasting, consolidation, anything. It's just a scenario. If you know that okay how you'll make the system work right what I'll do I'll just simply select I can select manually as well I can select parent node as well okay you can select the required members click on add members okay now here you have option how you want to display in the report whether in this way or simply in ID way so I just selected ID so that you know that would take less space in my column section. Similarly, I go to 4:46:58 accounts. I'll just remove them. I'll go to income, operating income, expenses or let's see gross margin and total sales. We have third party sales, inter company, I'll remove it. Cost of goods sales, material cost, labor cost. Okay. And then we have a portal cost. So here also I have options. So I'll choose description. I need only description not ids. So such kind of requirement keeps on coming that okay sometimes you want to view only ID. Sometimes ID and description sometimes only description. So you can select through this option. Okay. Click okay. And you can choose the position where you want to show and just hit okay. So now we can see that this is our report. Okay. So that looks much straight and easier 4:48:01 as compared to the last format for 2006 which we saw. Right? So here also you have option go to sheet options for any report always sheet option is the key. It has everything. Okay. Now there are four tabs formatting, refresh and protection that we will take uh as we go by. So here you can see that it has options like you know display dimension names repeat headers and columns. If I select this one okay and if I select this one okay then what would happen? Indent parent indent children. Indent is there like ch children are getting indented to right side right because personal cost is my parent labor cost material and third party sales are the children okay or I can choose no indent indentation as well now if I refresh it this is what I have plus other than that I have other 4:49:03 options okay to change the look and feel okay that how I'm expanding anything whether member and children children, descendants. Okay, I can choose descendants and I refresh it because it's already expanded. Okay, I can choose children as well. In a large report, you can do in this way. Okay, so what I'll do? So this data will get stored for product C. Okay, since it's a parent but nothing came because these are not the direct children of this personal cost. So we can even remove this one. Okay. So 100 200 300 we have. So these are the three columns 100 200 300 we just saved for product C. So I hope everybody in this call is very much clear that how our you know uh whatever we input in our EPM report how 4:50:05 that makes impact in my database how it will look like in my database right. So this signed data. So this signed data is something which we entered as a figure in our EPM report right that gets saved under the column sign data. It is at the intersection of the other dimensions members right like budget product C USD US these are the accounts labor cost and all right for these time time periods right these for these periods now we know that okay how to create a basic report how to just enter the data right how to play with dimension with member with model right then how I can do things with the calculation. Okay. How my calculation will play the part. >> See property is you know in edit report you can go. Okay. There also you can go 4:51:06 you can choose or make selection based on properties as well. Here this is the option filter by properties or there are EPM functions as well. Okay. So on which we'll discuss. Okay. when we'll be you know only working on proper on only working on reporting part but here you know like as for today's agenda it's more about data manager package right and before data manager package I wanted you guys to be on the same page with me that okay how that works and where that works so for that basic reporting knowledge was required so that we have covered here now this is what we have done on EPM and this is what you will do on EPM tab So this is all about creating the report input form. Okay. Then what about data manager? Okay. As I said data manager is the tab which is used to execute the calculation which is used to make the system work based on some conditions or based on some process 4:52:08 chains of okay which are standard ones. So that actually def process chains are nothing predefined functionality or calculation. Okay. So data manager is used to execute the calculation. How to create the data manager. Okay. So before creating the data manager you always need to create a data manager group. Okay. That defines what is the data manager? What's the use of that? Okay, how to do that? So for that we have organize, package list, package link list, right? There are different use of these. But before that let me show you how my data manager looks like. When I click on run package, now what does this run package means? Package will execute a particular calculation. Okay, if you click on this, 4:53:10 what you can see here, there are two process chains, right? In package chain, in package group, this is for model consolidation. Okay? Having different different process chains, these are standard ones. Okay. So before that what we'll do, we have to create. >> Yeah. Yeah. So here you can see connected to planning this one. Okay. But when we go there that shows ng2 that is the reason it's not showing us our own model. Okay. So for that what you can do you can simply come here click on this one minute VPC connection. Okay. Choose your connection again. Now if we go to data manager run package we can see planning XYZ okay 4:54:12 and there's another thing many times when you will select this thing right even after then system would not allow you right so in that case what you can do go to EPM okay and then you can click on report actions manage connections And here again you need to select particular model and click okay. Okay that that you need to do when you try everything but still system is not allowing you. Now if you click on run package okay what we can see data management. So all the basic operations related to data for that there are predefined or you know readyto use process chains are available which will do particular work. How it will work that we'll see. 4:55:14 For example copy it says copy transaction data. it will copy the transaction data from one intersection to other intersection. Okay. So if I select this simply click on run then it says handling of records how you want to carry forward. There are many ways of doing that but since uh this is our first session on data manager package. Okay. So copy records with match key or copy by replacing data in same data region of this this this right we can select this one. Go to next. Do you want to run default logic? Now what is default logic? That also we'll discuss. Click on no. Do you want to check work status? I know there are many new terms are coming for you right? So that will cover. So for a timing click on no. Now here we are. Okay. Now what it shows 4:56:18 based on our model right it's showing the exact dimensions which we are having in our model right now we have to define okay we have to select how as the name suggest copy what it will do it will copy my data set from one intersection of the data of same dimension to other intersection of the dimension members. So for example what I want to copy I want to copy all these numbers right to where to a particular any member which I'm going to select okay so for example if uh I believe we have done the entries in January right I'll select click on head. 4:57:16 So in the meanwhile screen appeared. So what we going to do? We will see that how this data manager does the work, right? How it can do particular calculation. So copy is the standard function offered by BPC. Okay. So what we'll do, we'll copy the data from January 24 to June 24. Okay. Without doing the same exercise again because right now it's just three entries. Okay. But in real time scenario, you know, the volume of data is huge. Let's say more than 5,000 10,000, right? So it's not possible for you to copy and paste everything. So you will simply run the package that will do the job for you. Okay. 4:58:39 Okay. And that was for product C, right? We won't do anything over there. It was for budget. Okay. So, what we are doing all the system is not allowing us to select uh it but ideally it does. So we just entered in our source 2024.01 January data into June month. Okay, let's see whether it works or not. But this is how you will use the copy data manager package. If you hit on copy, so it again shows you that okay, this is what your selection, right? Everything remains same. You're copying the data from January data into June data. Okay, there are three ways in data manager package. One is like run. If I hit on finish, system will start executing the calculation, executing the process chain, right? Which will copy the data from January 2024 to June 2024. 4:59:44 Another way is like schedule. Okay, schedule is like you know you can run you can decide that okay after 1 hour it has to be running or on particular day that also you can do run and schedule you want to run as well as you want to schedule that also you can do so we'll use run click on finish some black screen is coming I can't see what message it's giving but let's close it now whether it's running or not we can see the status and view status We can see it has succeeded. Now many times when you run the package right and if calculation is not much it will directly show you the result whether succeeded failed or anything. But how do you know whether it has done something or not but if not technically at least you can just double click on it and at least try to see that okay how many records it has written. So we can see that okay except count three submit 5:00:44 count three. So at least three records that means something happened right ideally three records is what system need to copied and if it has done that then that means it's successful what I'll do I'll come on EPM if my copy package has worked properly right I should be able to see the data in June month but here we don't have June month so we have to select again so I'll just refresh it Right? We can't see the data because we didn't select that member. So now I'm going to have that member again in my time dimension. 5:01:37 Maybe we need to close. I don't want to actually we didn't save it. 5:01:50 Let's say this is 2024 June month. Okay, I hit enter. Okay, I refresh. Now if if it's June, right? As I refresh, system would show me the same data what we have in January. So this is how data manager helps you right to perform calculation without doing the you know uh same work by in traditional way where you will copy the data and then paste it and then save it right so it saves lot of time plus we will do calculations okay how that works based on data manager package that also we'll see so is it clear that why it's working and how it worked to everyone one. So you can ideally you can go to data manager. Okay. You can go to view status. You can see the status. Double click on this. Okay. You can expand it and you can see 5:02:51 this everything would get covered here that from here to this is the combination. Okay. These are the accept counts and submit count is zero. If there would be any error submit count would have been zero. But here you can see it's three that means it has uh you know it performed the required calculation. So this is the log file. Okay, you can see for others as well, right? Because right now only in this environment I'm running, right? If you would be accessing the same model you would be running here also I can see that okay so and so user is here you can see that okay user right >> okay >> so based on this you can see that okay which user is working on where what they have executed right so data manager package as we have seen we can you know run it we can schedule right we can execute so there are many process many activities which don't need human intervention right and that can be executed during the night times right 5:03:53 where we don't want anybody to wake up and you know run the uh particular job or particular process chain right so we can automate them so that in the morning when they will log into the system automatically system will execute that if there is any issue any log right they have to hardly see the status in the morning if the jobs have been executed I mean the data management packages have been executed perfectly fine then you can see it succeeded. If there's some error you can see failed. Okay. Then what happen again? Those needs to be run manually during the daytime. If there's some, you know, particular calculation activities dependent on that. >> All right. Let's test your knowledge. Here's a question for you. What is the advantage of using SAP BPC 10.1 over traditional spreadsheetbased planning? Option A, better data security. Option B, improved collaboration. Option C, 5:04:54 faster processing times. Option D, all of the above. Take a moment to think and when you're ready, choose the correct option. Remember, each choice holds a key to unlocking the answer. Good luck. Type the correct answer in the comment section. Hey there. Ready to dive into the world of SAP BPC 10.1? Our course is your ticket to mastering supply management all at your own pace on our platform. [music] In this course, we'll unravel the mysteries of SAP VPC 10.1. Think of it like a Swiss Army knife for planning, [music] ensuring we've got enough goodies and getting them where they need to be. From the basics to expert tips, we've got you covered. Crafted by seasoned pros, this course delivers the goods. Your mentors, top-notch veterans in the feed, ready to guide you through and tackle any queries you throw their way. And hey, don't just take our word for it. Our students are singing their praises. Folks just like you have found this course a game changer. Best part, it's easy on the wand. Learning doesn't have to cost a fortune. Ready to become 5:05:57 a SAP VPC 10.1 maestro? [music] Enroll now. For more details, visit Xarentex website.
