on 07-05-2011 11:00 AM
Hello
I have to make some changes to some Dimension and Detail objects in my Universe as some of the underlying data is changing and so case statements that I have in my objects will need to change. For example, say I have an object called "Colour Description" then:
CASE WHEN code = 1 THEN red END
will now change to
CASE WHEN code = 1 THEN blue END
My question is, will this change in the code of the object automatically filter through to every document that the object is used in or will i have to go through every document that uses it to make sure the change has been made to the SQL.
Thanks in advance.
Julian
Very helpful and cleared up a query for me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Once you have exported the universe, it will change the object for each report that does not have the "Do Not Generate SQL" option checked the next time that you log on and run it - literally the next time that report interacts with the CMS and find out its universe has changed, it will update the SQL. As long as you're not changing data types, you will be fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.