on 08-23-2018 10:26 AM
Hi,
On SAP Analytics Cloud I'm trying to add actuals and budget information however I'm not able to add Version dimension into my analytical model.
Basis information is on excel file, and I'm trying to map actuals and budget into my model. I do not have licenced planning.
Could you please help.
Regards,
Vitor Ramalho
You should first add required version in story side for this mode, and then add "public." before your excel version and then map.
you could refer to below link.
SAC Blank Model - Dimension 'Version' add new members | SAP Community
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Sorry, I could not find the excel and data which you have prepared but in my view even for Analytical model if you have maintained a column for Version/Category in your excel file, e.g. ACTUAL and BUDGET and map it to the "Type"= "Version" and then click on "Map Version" button to map the maintained data as ACTUAL to ACTUAL and BUDGET to BUDGET.
Please find attached picture for reference.
BR
Praful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I'm afraid version management and the category dimension are features that belong to Planning-enabled models.
regards, H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Henry,
If I understood correctly if we do not have planning-enabled models we cannot have budget comparison reporting? Why is this defined like this?
Is there any plan to have this features on analytical models?
Many thanks,
Vitor Ramalho
Hi,
Two ways of answering this:
1) 'Business Intelligence' generally concerns itself with known-knows. i.e. "actuals" . that's why your non-planning analytics model doesn't have that paradigm.
2) it's a pricing mechanism - the more useful stuff costs more.
regards,
H
p.s. these are the pages that show you how to do this, using a planning model https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/3b7f87c3d9cb49b7a6fef3f5cb0a...
Hi Henry,
I'm afraid that I do not have the same understanding on Business Intelligence system. Nor even all customers that I've worked so far.
The first variance that we always do for a KPI is vs budget (and doesn't matter were budget is created). Everyone wants to know how my business is doing regarding budget and just after regarding last period (year, quarter or month).
With this I'm not expecting to have a planning system in place, I'm just expecting that a simple reporting system allow me to have very simple analysis. Do you agree with this?
Regards,
Vitor Ramalho
I know, it seems crazy right ? All i can tell you is that it gets stranger -
if you use Live data-access connection + a (non-planning) Analytical model, then you CAN manage versions (in an analytical model) and map to categories in your dataset. (see images below - this is based on HANA cloud platform)
... that obviously enables the variance calculations etc
But i can see no way to achieve the same on ACQUIRED (import) data unless i tick "Planning Enabled Model" .
regards, H
Hi Henry,
Thanks for your reply.
I need to test that on my system but it's very strange that its possible to live data an not on acquired. I hope that SAP developers could add this functionality on next releases.
Many thanks,
Vitor Ramalho
Hi,
I had another idea after a restful weekend. OK, this is if for an Analytics model (no planning).
It occurred to me, that if I loaded a new "shot" of data (i.e. go through the 'import from xx' workflow) into my existing model
.. then the data-integration screen would give me this option which should help you achieve what you are trying to do:
Good luck! do let us know how you get along.
regards,
H
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.