Question Re: Consuming data from an Analytical Model in Technology Q&A

Consuming data from an Analytical Model

hudupa — Tue, 11 Feb 2025 18:45:34 GMT

Hello experts -

I’m looking for options to save data in Datasphere by running an analytical model at specific times during the day. However, it seems that Data Flow doesn’t support AM as a source. Are there any alternative approaches?

Thanks,

Hiri

Re: Consuming data from an Analytical Model

tmeyer — Wed, 12 Feb 2025 07:32:53 GMT

Hi Hiri,

what is the need to "run" and "save" the data from an Analytic Model?

Br,

Tobias

Re: Consuming data from an Analytical Model

hudupa — Wed, 12 Feb 2025 15:33:52 GMT

Hi Tobias,
We have a requirement to take snapshots of the open orders (weekly) and report on it. The analytical model can only provide current order position and the snapshots will provide historical data for trend reporting.

Thanks,
Hiri

Re: Consuming data from an Analytical Model

tmeyer — Wed, 12 Feb 2025 15:57:02 GMT

Could you not get this data from the view below the Analytic Model?

Re: Consuming data from an Analytical Model

hudupa — Wed, 12 Feb 2025 16:20:09 GMT

I could. However, I wanted to use the analytical model to leverage all the fields from the star schema. I have a bunch of master data views in the star schema at the analytical model level.

Re: Consuming data from an Analytical Model

tmeyer — Thu, 13 Feb 2025 09:04:00 GMT

Could you connection your DSP AM via ODATA? Then you could use the data flow to persist the data