Skip to Content
author's profile photo Former Member
Former Member

Stored Procedure Universe

Hi,

I created a dummy object in the universe. I would like to use it as a FLAG (Y/N) in the report. But the object is grayed out in the universe. Is there a way to unhide objects in a stored procedure universe? Right click on the object "unhide" option is grayed out.

BO. 4.0

Thank You

Veena

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 28, 2013 at 09:01 PM

    Hii Veena ,

    Is the Dummy object defined properly with correct reference to existing universe objects

    as object greys out if there is no relationship maintained with existing objects.

    Regards

    Jeetan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2013 at 08:45 AM

    Hello Veena

    Speaking purely from XI3.1 and below, stored procedure universes are very limited with what you can do with them. I guess the same is true in BO 4.0 given your experience.You cannot combine a stored procedure with anything else either within a universe, but you can use functions when working with a table-based universe.

    Regards,

    Mark

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Whatever database functions you create. As long as the user defined in the universe connection has privileges to execute the function, then you can use it in the universe. Tell us what your stored procedure does as well as what you want to achieve and we'll see if there's a better way of accomplishing it. 😊

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.