on 03-28-2014 9:01 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kulwinder,
Thanks a lot for your help!
Actually, the way that we currently build our universe and reports is just like you shared in the document, set up data foundation and business layer, manually create parameters and lists of value, based on them to build analysis reports.
And now, we find that some new features are covered in new HANA SPS07, it supports new value help function when data previewing. So we want to know can we directly use this new features in BOBJ reports.
thanks and best regards
Shi
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.