Conditions change in the data provider

[legend8]

I have a very strange problem. I have 2 environments A and B and I made a change to the universe by adding a condition to it. I add the condition in a report and everything works properly in A. Then I imported the universe from A to a file and exported it to environment B which is in dirrenent database and repository area. I sent the updated report to Corporate Document as well. Then I retrieve the report from B and refresh the output and go to the data provider and some of the conditions in the query are being replaced by some other conditions without any warnings. This is really scary.

Any advice is appreciated.

Legend8

 

[BobWard]

I can explain this one for you. It sounds like you are transferring a universe from one repository to another. The reason is that each universe definition is stored in the repository and each object/condition is given a ID number. When you are trasnferring to a new repository the ID's are not being allocated the same. When you open the report it gets object definitions from the universe based on ID's not names so your report potentially has different conditions and objects in the Querypanel. Bummer !

 

[legend8]

Thanks for the explaination. BobWard.
Do you how to get around this problem?

Legend8

 

[BobWard]

A few questions

Are they seperate security domains ?

How do you re-point the report at the universe in environment 2 or is it automatic ?

what you need to be able to do is change the data provider from universe from env A to universe in env B. In this scenareo it uses object names so will therefore not give you the same problem. I suspect that if you areusing different security domains you cant do this !!

 

[legend8]

It has separate domains.
Because the same universe name are being used between environments, I think they are being done automatically. I found that what screw up the most are the Conditions (i.e. the 'filter' icon). There are ID assigned for each Object but nothing for Conditional Objects.

Legend8