Hi @Any 

The Business reporter tool directly work with the fact/dimension metadata in the IFS application and it will show all the fields of facts and dimensions.

But in the case of Tabular models only some generic subset is exposed. If you want to expose more field then you have to do a configuration to get those fields into the tabular model.

Parallel Currency field is there in the DIM_COMPANY but I don’t see Coordinator in DIM_CAMPAIGN.

https://docs.ifs.com/techdocs/23r2/050_reporting/600_analysis_models/080_customconfig/

Go through above documentation and you can find info about modifying the models.

In high level,

• Modify the _TM view of the dimension data source and add the column(s) you need.
• Modify the Tabular model tables and add the columns you need.
• Deploy the views to SQL Server DB.
• Deploy the tabular model
• Run data load.
• Process model.

Hi @subashfestus 

Thank you so much for your response. In this case we are working with App10, so the modification of the _TM must be directly in SQL server DB right?

The field coordinator, I can see it in BR inside DIM_Campaign (FACT_CUSTOMER_ORDER_CHARGE)

Regards,

Hi @Any ,

Sorry I thought this is an IFS Cloud question.

In apps 10 things gets bit complicated because there we don’t have cube configuring support using the application.

There are no _TM in apps10 solution. There are IFSappl_XX, Dw_XXX, Dm_XXX tables and SSIS packages to move data between them. Then there is another SSAS project for the cube. All those has to be changed using SSDT or visual studio if you want to do a column addition like this. 

ok thanks for your support @subashfestus 

Best regards,