cancel
Showing results for 
Search instead for 
Did you mean: 

Changing an Object in the Universe - does this auto show in the document??

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Very helpful and cleared up a query for me.

Former Member
0 Kudos

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.

Former Member
0 Kudos

Where may I find the "Do Not Generate SQL" option in BO XI 3.1??

Thanks

Julian

Former Member
0 Kudos

Sorry, my fault! It's been replaced by Use Custom SQL when you view the SQL in Edit Query.