I have 6 different universes (all having the exact same structure, pointing to separate servers).
I create a report using Universe1. In the report I want to list the name of the universe, so I insert a cell into the report with the formula of =UniverseName(“DataProvider”). The report shows the value of “Universe 1 Name”. After saving the report, I switch the universe to universe2. After refreshing the report (now attached to universe2), the report still shows the value of “Universe 1 Name”. Even after exiting BusObj all together, the problem still remains!?
Any ideas? I am currently on hold with tech support…
Using 4.1.2 on MS SQL Server…
Tim Heuer
PacifiCare Health Systems
(714) 825-5702 - office
(800) 946-4645 pin 1404017 - pager heuer_tk@exchange.phs.com
If you have been choosing the ‘REFRESH’ button, therein lies your issue. Clicking on the refresh does nothing other than resubmit the SQL that is currently in use against the connection information that is stored in the report. (You can verify this by using the Connection formulae to display the connection being used).
After reassociating you should reenter the Query Panel and click run. This will make sure that all of the Object definitions are up to date and then return the correct values. (including the Universe Name).
Did you use UniverseName(DataProvider(object of dataprovider)) or just flat UniverseName(“name of dataprovider”). The first is more flexible in terms of changes to the name of the dataprovider (when default it will be changed from “Query 1 with universe1” to “Query 1 with universe2” when you switch universes).
Greetings,
Marianne Wagt-van Loenen
IDETA, the Netherlands
After saving the report, I switch the universe to universe2. After refreshing the report (now attached to
universe2), the
report still shows the value of “Universe 1 Name”. Even after
exiting
BusObj all together, the problem still remains!?
No idea of the cause but I seem to remember having the same problem with the DataProviderSQL function - ie changing the objects (and hence the SQL) in a report left the original SQL being displayed in a text box. Because I was only ‘playing’ at the time, I forgot to log it with BusObj.
Regards
Jonathan
Project Leader
Global Medical, Regulatory and Product Strategy (GMRPS) IS
We are using refresh (and use the refresh command in the scripts to run the report). ALL other objects AND formulas not relating to the SQL refresh with the correct information. I have tried using both the UniverseName() and the UniverseName(DataProvider()) options both to no avail. After talking with BO, they have researched it and have logged this as a bug. Any further suggestions?
Tim
Tim Heuer
PacifiCare Health Systems
(714) 825-5702 - office
(800) 946-4645 pin 1404017 - pager heuer_tk@exchange.phs.com
After reassociating you should reenter the Query Panel and click run. This
will make sure that all of the Object definitions are up to date and then
return the correct values. (including the Universe Name).