List of Values for HANA (SPS 07 Rev 70) Input Parameters In IDT 4.1 SP2

This blog discusses the use case where we can use list of values generated in SAP Business Objects Information Design Tool's (IDT) data foundation layer for SAP HANA input parameters (from SAP HANA information view).

As we know that we can map SAP HANA input parameters to universe parameters in data foundation layer of IDT and this can be done by creating derived table in IDT. If you are not sure how to achieve that then please refer to document here. You would need to write a SQL statement to create derived table in IDT. I would like to suggest you to look at SQL statement generated in HANA studio when you preview your data. You can copy the part in green and then use it in IDT (as shown below).


SQL Statement in SAP HANA Studio:





SQL Statement in IDT:





Challenge/Issue/Gap:

When we use SAP HANA input parameters in Information Design Tool then the list of values created in SAP HANA doesn't come along. For example, following is the input parameter created in SAP HANA information view (using SAP HANA studio). We are using other HANA information view (see "
View/Table for value help:*") which contains text attribute for distribution channel.

















When we preview data in SAP HANA studio then the we can select from list:



















However, this list is not visible or comes along with input parameter in IDT.


Solution/Suggestion:

In this case, we can create list of values from same HANA information view or data model, which contains text attribute of distribution channel in data foundation layer of Information Design Tool. Please use following steps:

Click on "List of value based on SQL" under "Lists of Values" section in IDT's data foundation


Write the SQL statement and hit "Save" to save data foundation layer.


Once list is created then use it to map with distribution channel parameter
















Now, you should be able to carry this list as well input parameter to IDT Business Layer and use them as universe parameter.

Comments

  1. We will go through how to use mod salicylates initially, but will use all sorts of fruit and veg in the classes.
    plagiarism check

    ReplyDelete
  2. You can create list of values from same HANA information view or data model. I want to recommend you a good site https://unplag.com/.

    ReplyDelete

Post a Comment

Popular posts from this blog

SAP HANA Input Parameter - Derived from Table - Use Expression in Filter Value

SLT Replication Issue Due To Timeout Reading Logging Tables

SAP HANA Data Modeling Features - from project perspective