SAP Analytics Cloud source : Snowflake datawarehouse Live connection

[mfoeken]

Hi,

Has anybody come across Snowflake datawarehouse as a source for SAP Analytics Cloud (SAC) live connection?

If yes,

1. Was APOS used as a connector between Snowflake and SAC? If no, what connector/adapter was used?

2. Was hierarchies from snowflake consumed as expected in SAC data model? Were you able to use live connection data models to stories and straight away use the hierarchies from snowflake in stories?

3. the date hierarchy. Was that created in snowflake and how did it behave in SAC via live connection? Were you able to get the SAC date functionalities? range/member , Current year/previous year, month etc.

4. Is there a way to merge SAC data models outside a story and use that object as a source for a story?

Regards,

Cleo

[mfoeken]

Hi Cleo,

With one of my our customers we are exploring using APOS Live Data Gateway (LDG) to connect in a live manner from SAP Analytics Cloud to Snowflake. Regarding question 2 and 3: i can't comment yet. Regarding question 4: no, you can't merge. You can use blending/linking or simply create a data model to combine your data in for instance snowflake and consume this as a single model.

Kind regards,

Martijn van Foeken | Interdobs

[former_member302630]

We are actually considering (not tested) doing all calculations in snowflake (so that we don't need the SAC date functionalities? range/member , Current year/previous year, month etc. ).

So we calculate in a semantic layer in snowflake YTD and MTD etc. So a view layer on top of tables in snowflake.

But if I create a story filter on fiscalyearperiod field in SAC , how does it communicate with snowflake via APOS?

The ask is kind of like what we used to do in BEx customer exit. but that could be invoked even when value was passed by SAP Webi to BEx.