BusinessObjects Board

Universe Save As does not create new LOV objects?

building semantic layer
#1

Hi All,

I have a universeA. Using Save As I created file UniverseB. I changed the name of this universe to UniverseB using “Paramaters” icon. I changed the row restrictions for UniverseB and then exported it to the repository.

I pointed few reports which were earlier pointing to UniverseA to UniverseB.

The reports when refreshed still show the LOV of UniverseA.

Is there a way to create/refresh/set to default LOV of all objects in UniverseB? I have more than 150 objects in UniverseB.

Please suggest.

Regards,

Devang

devang808 (BOB member since 2007-05-28)

#2

Is the shortname (filename) still the same or did you just change the long name?

Mak 1 :uk: (BOB member since 2005-01-06)

Lost row restrictions when save universe with other name
#3

That may be because you might not have selected the check box for ‘automatic refresh before use’ which may be still showing values from universe A.

.

haider :es: (BOB member since 2005-07-18)

#4

Where do I change the Short File Name?

I have changed the name in the File >> Parameters. This is the long name or short name? I am using BO Xi R2.

devang808 (BOB member since 2007-05-28)

#5

I want to keep the object properties same as UniverseA. As of now they are same.

One more observation:

When I refresh the reports pointing to UniverseB and check the LOV of prompts it imports UniverseA.

I want that LOV objects of UniverseB should be separate entities and no where linked to UniverseA.

I believe the prb occured because Save As created a new universe (universe Id) but did not create new Ids for the LOV objects.

Also how do I ensure that other objects in UniverseB (dimensions and measures) are independent of UniverseA i.e. if I make change in one the other should not be affected?

devang808 (BOB member since 2007-05-28)

#6

The will be no change of ID when changing the long name.

The filename is the name of the file that you save as in the windows dialog box, if you change this then you will create a new universe ID and I believe change the LOVs…

Mak 1 :uk: (BOB member since 2005-01-06)

#7

Unlike previous versions long name(universe parameters) or short name(file name) are one and same in XI r2.
Can you refresh the list of values in the universe from Tools-list of values-edit list of values.
Does it still show values from universe A

.

haider :es: (BOB member since 2005-07-18)

#8

Correct Haider! My bad… :slight_smile:

Mak 1 :uk: (BOB member since 2005-01-06)

#9

I tried refreshing LOVs of few objects. I also deleted UniverseA from my local drive. I opened the report again, refreshed it and checked for LOV of prompts. It says “Cannot FInd UniverseA (DAO011)”.

If I refresh individual data providers the LOV of prompts do come up. I guess they are coming from UniverseB which is the required behavior.

devang808 (BOB member since 2007-05-28)

#10

In that case try refreshing the list of values from DeskI tools-universes-universe name
Then refresh the whole report

.

haider :es: (BOB member since 2005-07-18)

#11

So I will have to select each object and refresh the LOV for that object?

devang808 (BOB member since 2007-05-28)

#12

No, its rather the classes which can be selected(using ctrl key) to refresh all LOV objects

.

haider :es: (BOB member since 2005-07-18)

#13

Just go to Tools-> click universes -> select the universe(whose modifications are to be reflected in the report and then click refresh, as Haider suggested. This would allow the reflection of all the modifications done to the universe in the report.

Jansi :india: (BOB member since 2008-05-12)

#14

Thanks Haider and Jhansi…

As I am doing that few more passing questions:

Will I have to do it for all the reports that need to be pointed to UniverseB?
How abt any new report that I create using UniverseB?
Is UniverseB actually independent of UniverseA in all respects like dimension objects, measure objects, LOVs, row restrictions etc?

devang808 (BOB member since 2007-05-28)

#15
  1. Yes.
  2. Here no need of refreshing it in the said way, as you are going to create new reports
  3. It is not dependent anymore. Both are independent.

Haider, correct me if I am wrong.

Jansi :india: (BOB member since 2008-05-12)

#16

Thanks Jansi and Haider…:slight_smile:

The method works!!!

I have around 50 reports which I need to point to UniverseB. Is there any other method to achieve the same.

devang808 (BOB member since 2007-05-28)

#17

Are these webi or deski docs, if deski there is a utility in BOBs downloads, if they are Webi try this:-

https://bobj-board.org/t/106492

Mak 1 :uk: (BOB member since 2005-01-06)

#18

we use BO XI R2.
I did my test - everything worked fine - I didn’t have any problem with LoVs.

  1. I created Universe “A” with LoV with Connection “C1”.
  2. Saved it and exported.
  3. Then I renamed universe “A” to “B” and changed connection to “C2”.
  4. Saved it (!!!Don’t!!! use “Save As” just “Save”- it’s very important!!!).
  5. Export universe “B” - you’ll get a message: «Universe 'B" was previously exported with name “A”. Do you want to update the existing universe with the new name?..» - Click «Copy» !!!not!!! update.
    This also solved my problem with rows restriction.
    Regards

Elena Semenova (BOB member since 2007-05-28)

#19

In my case the connection also remains the same. For me Save As works fine but I have to manually refresh the LOVs for UniverseB in all reports.

Mak,

Could you provide me a link tothe download?

devang808 (BOB member since 2007-05-28)

#20

“Save As” will terminate security for rows restriction level.

Elena Semenova (BOB member since 2007-05-28)