This is driving me nuts. We use linked universes and recently ugraded from V5 to V6.5.1. In the past, we had to change our ORA7EN.prm file to add parameter CORE_ORDER_PRIORITY = Y in order to have new objects added to the master universe show up in the same order as the derived.
In V6.5.1, I noticed the .prm file setup is different. Also, there are 2: oracle.prm and oracleen.prm. I’ve updated the oracle.prm file with the following statement:
Y
It doesn’t seem to be working. As I add new objects to the master, they do not show up in the same order in the derived. I’ve even tried setting this parameter to YES and Yes. Am I missing something? Is there anything to change in the oracleen.prm file?
In version 6.5 you can override what’s in the paramenter file inside Designer. So a new universe would probably see the change you made to the text file, but existing universes may not? I don’t know, I’m guessing here.
As Dave mentioned, you can now set parameters inside Designer. Open the universe parameters box (File - Parameters) and go to the Parameters tab. Enter your parameter and value there, and see if that works.
Thanks for the replies! That was exactly what I was looking for.
For others that are having trouble, here’s what worked for me. We have some objects/classes in a linked universe that were created in the master Universe and then other objects/classes that were created in the derived Universe.
To get the objects in the correct order, I had to use the following procedure:
Open the derived Universe.
Go to File->Parameters and open the Parameter tab.
Change the parameter CORE_ORDER_PRIORITY from No to Yes.
Export the derived Universe and reimport.
*At this point, the objects that I added to the Master Universe were ordered correctly. However, all of my objects created in the derived Universe showed up at the bottom of the list.
Re-order the derived objects.
Change the parameter CORE_ORDER_PRIORITY from Yes to No.
Export the derived Universe and reimport.
Now, both my master and derived objects are in the correct order.
All documentation that I could find for Business Objects 6.5 still mentioned changing the PRM files for your datasource. This did not work for me. Thank you very much for helping on this issue!
Do you know if this parameter setting also has to be applied to the prm file on the end users PC in order for the object to display in the correct order ?
Great thanks amer0521 most appreciated not only for the orignal post on the subject but also replying I thought I was going mad and the fix will save me a lot of time.
Can we also move objects from Kernel universe class to Derived universe class in the derived universe by changing this parameter in Designer in BO XI R2?
For example :-
1)create a Kernel universe ‘A’ with all the dimensions objects under Class ‘C1’.
Create a derived universe ‘B’ with fact/additional objects under class ‘C2’
3)Link the kernel universe ‘A’ to the derived universe ‘B’ where the class & objects (‘C1’) of ‘A’ appear dimmed(greyed out) .
Now I want to move and reorder couple of objects from class ‘C1’ to ‘C2’ as they are related to each other.
I can move objects from Class C2 to C1 but not from kernel to derived.
Could you please help if there is a way to achieve this?
When you are setting the CORE_ORDER_PRIORITY to yes(in Derived universe parameters) then all the classes & objects will from the master universe will take their positions in the derived universe in the same order in which they are existing in the master universe. You cannot control(rather modify) these classes/objects from the derivedd universe.
for ex: when you create 2 universes and the link them you just need to set this parameter to yes and you’ll get the desired result as soon as you import the master and derived universe from the repository and then export the universe back.
you do not need to set it to No. b’coz for us this is how it is working perfectly.
(BOB member since 2002-06-06)
(BOB member since 2002-08-08)
(BOB member since 2002-10-04)
I thought I was going mad and the fix will save me a lot of time.