Skip to main content
Question

IFS Cloud - Analysis models deployment

  • May 24, 2023
  • 1 reply
  • 126 views

Forum|alt.badge.img+3

Hello all,

I tried to deploy Analysis models – IFS_SALES and IFS_GENERAL_LEDGER getting following error. I need assistance with this.  Did anybody have any idea?

1 reply

Michael Kaiser
Sidekick (Customer)
Forum|alt.badge.img+8

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

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings