on 09-09-2011 7:06 PM
Hi ,
I have a BO Universe created which directly calls stored procedure and its working fine. Now I have to add a new input parameter to this stored procedure, how can I refresh my Universe so that the newly added input parameter gets reflected in BO Universe.
One solution that I know is I have to delete existing table and then reinsert stored procedure so that new input parameter is shown in Universe. This is like almost creating Universe from scratch. Any other option available apart from this? Please let me know.
Hi,
If you have added new parameters to existing stored procedure and now you want to reflect this newly added changes to your universe and reports you need not to create new table because your stored procedure is already part of universe. You just have to go to universe tool bar;
Click on View and Click on Refresh universe structure and it will refresh and bring all the setting.
You might have to exit and re- log on to designer.
Regards,
Bashir Awan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
The reason for this message is due to the connection problem.
Check out if you ae able to connect to your DB server?
1. Try to connect from DB Client to DB Server in-order to check if without BOBJ in picture you are able to connect or not.
2. From BOBJ side, Open the Universe and go to --> "Files" --> "Parameters" and click on "Test" from the connection tab. Look for the message what is coming.
Thanks,
Vivek
Thanks Vivek for your response.
I tried connecting to DB server from DB Client and its working fine even I checked from BO Designer "Parameters" screen it says "The Server is responding".
Also when I tried "Check Integrity" parsing is failing with error message as "Procedure or function 'procedure name' expects parameter '@newParameter', which was not supplied. State: 42000.
Some how Universe is still not picking new parameter.
Hello,
I just came across an KB Article
1524516 - Building A Universe With Stored Procedures.
I think it says that this is a limitation and which has already been raised to SAP BOBJ team.
Another KB Article: -
1486899 - Universes with stored procedures do not refresh the structure of altered stored procedures
Thanks,
Vivek
Hi,
What SP and FP you are running. According to new article this issue should have been fixed.
As Vivek metioned two SAP Notes. Second one is more than a year old before even SP 2. Now SP 3 and more are out with FP too.
Go through Universe Designer guide after SP 3.
Have a look at the first notes.
1524516 - Building A Universe With Stored Procedures
Regards,
Hello,
I had a check with XI 3.1 SP4 & XI 4.x and in both the places I got "The selected table were not found"
So we need to create a new universe once we add/remove any parameter from the stored procedure.
I think you better have a look to KB article which I have mentioned above, that will clarify your doubts.
As mentioned above you need to have a S-User logon to SAP Service Market Place.
If you have any query for S-User you can contact to SAP Or get it from someone in your company.
The link to the support portal is: -
http://service.sap.com/support
if you want to search for any KB Article go to above link and check for :-
Help & Support --> Search for SAP Notes
Modify the search critirea as per your requirements.
Now for the documents you can use: -
Help & Support --> SAP Business Objects --> on the left had side you will see "Documentation" section: -
a) Supported Platforms/PARs : will provide information about all the infrasrtucutre support for different SAP BOBJ version
b) Product Guides / End-user Documentation: Will take you to the portal from where you can download user guide etc. as per your need.
Thanks,
Vivek
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.