Hello community,In Power BI in the cube IFS_Sales I cannot see the fields Coordinator and Parallel Currency, those fields are in the dimensions Campaign and Company of FACT_CUSTOMER_ORDER_LINES and FACT_CUSTOMER_ORDER_CHARGE (Information sources)So why can not see them in Power BI? but for e.g in Business reporter I can. Are we not taking the information from the same source?Thanks and best regards,
We are running IFS Cloud 23R1 in a, by IFS, hosted setup with self hosted BI setup in our own Azure tenant. However, our main datalake resides in Snowflake and we’re therefore pushing data from Azure to Snowflake. Currently this is done with full dataloads each time, which is not a sustainable model.We have enabled incremental loads between IFS Cloud and our self hosted BI (Azure). We are now looking into what we can utilize to enable incremental loads between Azure and Snowflake, and noticed that mvt_created_dt was populated in Azure. However it seem to be updated with the time of the latest incremental load, for all records? My exceptation was that this would only occur for newly added/updated records.Does anyone have any suggestion how to implement a solid incremental load funcationality between Azure and another datalake?
Hello,I have a requirement to make the data source - FACT_GL_TRANSACTION as incremental data load and I have modified that in Data Load Definitions -> Data Source ->FACT_GL_TRANSACTION - Incremental Load (condition got auto generated based on mvt_created_dt).Although my existing access view FACT_GL_TRANSACTION_BI, has the data access type set as online and it is created based on FACT_GL_TRANSACTION_OL. Hence, full load will be sent every time when the data load runs as the mvt_created_dt in FACT_GL_TRANSACTION_OL is sysdate.I don't see any option to modify access view - FACT_GL_TRANSACTION_BI to change access type as datamart. Can you please suggest me how this can be handledRegards,Manisha
Hello,We have a data source - FACT_GL_TRANSACTION which needs to be sent as incremental load to Azure. But the load goes into error while the data load runs. Any idea why ?
Hi,We have encountered an error with the view FACT_ACTIVITY_CALCULATION_BI which I believe is part of the Analysis Models.The error is:ORA-00904: "ACTIVITY_CLASS_SEQ": invalid identifierHas anyone else experienced this?It seems that it is because the view thinks that "ACTIVITY_CLASS_SEQ" is a column in FACT_ACTIVITY_CALCULATION_OL but that view does contain that column.This is causing failures for us when we are trying to load the data into the SQL database.Any help would be appreciated. Thanks,Mark Mruss
Hello,I’m trying to set up tabular models IFS_INCIDENT_ANALYSIS and IFS_SALARY_REVIEW_ANALYSIS and it seems it’s missing Fact IDs referenced by above Tabular Models. It gives below error when trying to deploy tables and views to SQL Server, This environment does have some inactive components. Could you please explain the reason behind this behavior? what are the expected components that need to be active?
Hello,Below error is received when running a data load run,DataLoadScriptORAToSS - Copy Data from Oracle to SQL Server - 2 - ERROR: ORA-28000: The account is lockedAny idea why?
We are trying to install the Bi solution. In the tech documentaion it is refered to a Main.cmd that you should request from and IFS Consultant.https://docs.ifs.com/techdocs/23r1/050_reporting/450_self_hosted_bi_int/010_create_azure_resources/#upload_odac_installation_files_to_the_blob_storageAnyone that know where to get the Main.cmd. We have tried a support ticket without any luck. Have now been waiting for 14 days….
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.