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.
Built a report selecting one object and limited to 50 rows saved and then closed WebI.
Went to designer changed the object’s select to just be “2” rather than the db.column_name and exported.
Started Webi, viewed report and it got the same 50 values, edit the report and hit refresh and it told me “The query does not reference a table” since my object is now just selecting “2” with no associated table.
Hi
Thanks for all the replies.
I’ve given it a test and have found that there will be no need for me to change/check the webi documents.
My test was:
Create a report with a Dimension object (order code) and a Detail object (order description). The SQL code for the Order Description object performs a CASE statement so will output different text based on the Order Code. For example:
CASE when code = 1 then “New Sale”
when code = 2 then “Cancelled Sale” END
I ran the report and saved the document. Then I imported the Universe from the repository and changed the description texts in Designer.
I saved the Universe and exported the Universe to the repository.
Next I opened the document and refreshed the data and the new descriptions were shown in the report results. I saved the document.
I imported the Universe into Designer once more and changed the text back to what it should be, saved and exported the Universe. I opened the document in InfoView again, refreshed it and the descriptions shown changed back to reflect the text that was in the Object.
And that is what should happen, since you are not really modifying from an Object definition to another Object definition, you are qualifying it with a value (2 in your case) which will not work without the presence of some actual table column (or object).
Nniixx, from the tests that I have done then I would have to disagree. Unless its a data type that you’re changing, then if your object SQL changes, for example
case when code = 1 then colour = “red” end
to case when code = 1 then colour = “blue” end
and you’ve exported this universe, with these changes, to the repository then the next time the document using this universe interacts with the CMS, the CMS says “hey, the universe the changed” and updates the SQL for the queries.
If i just had one object in my report, for example, “Sale Date” and the object SQL did “SELECT saledate FROM sales” so that the output was:
Sale Date
01/07/2011
02/07/2011
03/07/2011
and I decide that I want the “Sale Date” object to only return the system date and so change the SQL of the object to “SELECT GETDATE()” then the output will no longer work since I’m not doing a “FROM”.
However, lets say that I had 2 objects in my report so the output looked like:
ID Sale Date
== ======
11 01/07/2011
22 02/07/2011
33 03/07/2011
and then I change the “Sale Date” object to “SELECT GETDATE()” then the output will still work and will become
ID Sale Date
== ======
11 07/07/2011
22 07/07/2011
33 07/07/2011
This would happen without me having to modify the report.
(BOB member since 2005-12-20)
(BOB member since 2009-03-03)
(BOB member since 2009-09-02)
(BOB member since 2008-08-28)
(BOB member since 2005-12-20)