Solved

Analysis Models - Issue in setting up Tabular Models

  • 5 November 2023
  • 2 replies
  • 86 views

Userlevel 2
Badge +5

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?

icon

Best answer by subashfestus 6 November 2023, 04:01

View original

2 replies

Badge +4

Hi @himasha.abeywickrama ,
It seems like the modules containing the facts of these 2 tabular models are not active. It should look like below.

 

https://docs.ifs.com/ifsclouddocs/23r1/DocBusinessIntelligence/IfsAnalysisModels/AboutIncident%20AnalysisModel.htm?StandAlone=true

https://docs.ifs.com/ifsclouddocs/23r1/DocBusinessIntelligence/IfsAnalysisModels/AboutSalary%20Review%20AnalysisModel.htm?StandAlone=true

 

Salary review related facts - COMPBE

Incident analysis related facts - OSHA

 

I think the error you get is appearing due to model generation errors because the relevant facts are missing in the model. If the customer is not using these functionalities then it will be meaningless to use these tabular models because there will be no data in the application to be fed to the models.

 

Userlevel 2
Badge +5

@subashfestus,

Thank you Subash!

Both of the components are inactive in the environment and that explains the behavior.

Reply