IFS Cloud - Analysis models deployment

Hi Gangadhar,
I’m completely knew on this interface but very familiar with everything concerning MS SQL Server, AnalysisServices (platform for running (old) multidimensional and (new) tabular cubes and MS Integretion Services (SSIS-packages).
Also very familiar with MS PowerBI (it will give you additional own calculated measures when connection to tabular(!) cubes)

We did a lot of SSIS packages and we are familiar with the IFS SSIS packages even if we don’t know exactly what this deploy process is doing.

I like to suggest the following:
Check documentation: The “old” IFS BI has a very good documentation.
I expect the newer (cloud based) doing as well.

Check “DWH” databases: It looks like there is no IFS_Sales DB available.
Therefore a SSIS package immidiately throws an error.
Could be you have a IFS_Sales ORACLE based database but I don’t think so.

Build your own, small SSIS package:
Not very hard to do, just create 2 connections (one Oracle, one MS SQL) and try to
export e.g. CUSTOMER_INFO_TAB from ORACLE to MS SQL Server.

Check you connections in your own SSIS.

All the best and good luck.

Michael