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
The new business key will be referenced in the SQL where filtering and grouping for that member is necessary.
Quote from: CognoidJay on 17 Feb 2017 10:17:43 AM
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?
Quote from: backhandx on 17 Feb 2017 10:21:56 AM
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 (http://www.cognoswithjay.com/searching-for-report-contents-in-the-content-store/) on my extremely inactive blog.
Quote from: CognoidJay on 17 Feb 2017 10:46:47 AM
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 (http://www.cognoswithjay.com/searching-for-report-contents-in-the-content-store/) on my extremely inactive blog.
if the member is used in filter, do we need to change the mun or no?
No you don't.