The impact of changing the business Key of a level

[backhandx]

Hi all,

I have a dimension with two levels. I want to change the business key of a level from the attribut A to B. I want to know what would be the impact of this change in report Studio and the generated SQL.

Thanks

[AnalyticsWithJay]

The new business key will be referenced in the SQL where filtering and grouping for that member is necessary.

[backhandx]

The new business key will be referenced in the SQL where filtering and grouping for that member is necessary.

Thanks for you reply.

Do we have to change the members mun in which are used in the report?

[AnalyticsWithJay]

Thanks for you reply.

Do we have to change the members mun in which are used in the report?

Great question. Your MUNs will definitely change by changing the business key.

If you need to search for which reports are referencing these MUNs, I wrote an article on my extremely inactive blog.

[backhandx]

Great question. Your MUNs will definitely change by changing the business key.

If you need to search for which reports are referencing these MUNs, I wrote an article on my extremely inactive blog.

if the member is used in filter, do we need to change the mun or no?

[AnalyticsWithJay]

No you don't.