cancel
Showing results for 
Search instead for 
Did you mean: 

SAC - Dimension Version on Analytical model

0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member764740
Discoverer
0 Kudos

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

0 Kudos

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

0 Kudos

Hi Praful,

I do not have type "Version" available to map with any column. I'm afraid that this option is only available for Planning models and without this we cannot have several versions for my data even though I have maintained this on excel data.

Kind regards,

Vitor

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

I'm afraid version management and the category dimension are features that belong to Planning-enabled models.

regards, H

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

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

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...

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/1a011f8041a84e109a3b6bf8c1c8...

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

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

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