Query status showing inactive in the RSRREP table

[Former Member]

Hi experts,

We are in BI 7.4 SP9 environmet and using standard business content for inventory management cube(0IC_C03) and queries.

When I checked the queries in the table object status showing inactive,Is there any dependent HANA views need to activate to become activate these queries.

Also getting Column store error:fail to create scenario[340-2048] while activating multiprovider(0IC_MC03),please let me know anyone come across the same issue,please share your solution highly appreciated.

Regards

[sander_vanwilligen]

Hi,

It might be that some Business Content is not yet completely installed. Please check it in Business Content installation and choose Grouping mode Data Flow Before and Afterwards and Collection mode Collect Automatically.

Best regards,
Sander

[Former Member]

Hi Sander,

Thanks for you reply,I tried this option and still getting same issue queries are still inactive in the table.

Please share if you have any other thoughts.

Regards

[sander_vanwilligen]

Hi,

When I look again at the error message in the attached screenshot, it indicates a problem with the underlying InfoCube 0IC_C03. Please check this InfoCube and activate it again. Also please check if all assignments to Characteristics and Key Figres are complete and correct.

The InfoProviders (both MultiProvider 0IC_MC03 and InfoCube 0IC_C03) must be OK and active. This is an important prerequisite. Once they are OK, then you can try to save the queries in the BEx Query Designer or install them again from Business Content.

Last but not least, are you using the conventional approach or the new HANA approach? If the latter is the case, please also check the document .

Best regards,

Sander

[Former Member]

Hi Sander,

Issue got resolved,Thanks for your response.

Regards