cancel
Showing results for 
Search instead for 
Did you mean: 

How to refresh BO Universe when no. of input params change in sproc

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member793810
Active Contributor
0 Kudos

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

Former Member
0 Kudos

HI Bashir Awan,

Thanks for your response, I tried the steps that you mentioned and I see a popup message saying "The Selected Tables were not Found". Any idea why I am getting this message?

Thanks

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

former_member793810
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

This is what we have

Product Version: 12.3.4.895

SP 3

Fix Pack 3.4

where can I find Universe Designer Document for SP 3?

Former Member
0 Kudos

Also how can I search for above mentioned articles? Please let me know.

former_member793810
Active Contributor
0 Kudos

Do you have SId. If not then ask your company to create one for you so that you may access SAP Notes.

Regards,

Bashir Awan

Former Member
0 Kudos

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

Answers (0)