Skip to Content

How to consume value help for Variables/Input Parameters in BOBJ reports

Dears,

We need to do some BI analysis based on calculation view which created in SAP HANA Studio SPS07.

Variables/Input Parameters are used in the view, and the values for them are derived from other views/tables.

For example, the values for Variable V_SAPClient are derived from the view SAPClientValueHelp;

the values for Input Parameter P_ControllingArea are derive from the view

When we execute data preview in SAP HANA Studio, we can choose values for Variables/Input Parameters from value help.

I tried to create a data foundation based on this view, and then create a business layer. But when I execute a query based on the BL, I found that there is no value retrieved for all Variables/Input Parameters.

I also tried another way. In SAP Crystal Reports for Enterprise 4.1 SP2, I created a crystal report using HANA DB as the Data Source Connection, but the result was similar to previous way.

So how can we consume the value help for Variables/Input Parameters? Don't we still need to create Lists of Values in Data foundation? or create parameters in Crystal Reports?

Your help will be very much appreciated!

Thanks and Best Regards

Shi

V_SAPClient.png (60.3 kB)
query.png (172.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Mar 30, 2014 at 12:26 PM

    Hi Shi Yu,

    I don't have internal information about BO development, but when I was in touch with than at beggining of HANA development what I could see is a tremendous different of delivery things due to really amazing development cycle of SAP HANA (every week we got one inside SAP, and customers also receive the newest features/corrections in short time).

    What you can configure on HANA and test on Studio Data Preview is always all the possibilites of metadata.

    Due to fast cycles on HANA Development not all these metadata are handled from clients, normally due to speed and number of updates released. This doesn't means also that there's a planning to handle all client necessity.

    So, for the time being I'd say that you need to model it again on Crystal.

    Regards, Fernando Da Rós

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2014 at 08:19 PM

    Shi Yu,

    Help values for Input parameters and variables can be achieved by creating derived tables in data foundation tab. You have to create manually List of values for those parameters. It is very well explained in below document.

    Using SAP HANA Variables with SAP BusinessObjects BI4.0

    It works well.

    Kulwinder

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Shi Yu

      Hi,

      Can you please elaborate on what help functions you are talking about in SP 7 revision. I didn't come across anything which will cover consumption of help value function of input parameter in BO 4. I think still we need to handle this with same technique mentioned above as per SP 7 revision also.

      Regards,

      Kulwinder

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.