Forum Discussion

edemirel's avatar
edemirel
New Member
8 years ago

Displaying Keys from SAP HANA on Import Mode

Trying to display specific Keys (IDs) instead of the descriptions of the said attributes. Is there a specific way to retrieve Keys with a function or a query change when using HANA Calculation Views in Import Mode? Below are two screenshots that show the difference between PowerBI and BOBJ Analysis.

 

BOBJ vs PowerBI

5 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi edemirel,

     

    Based on your description, you are using import mode to connect to HANA, right? And you want to achieve specific values in your text every row, right? You can click Query Editor-> Transform-> Split Column using Custom mode by "Total" and "(".

     

     

    Regards,

    Jimmy Tao

     

    • edemirel's avatar
      edemirel
      New Member
      8 years ago

      Hey v-yuta-msft, thanks for the response.

       

      Not exactly. I blocked those values in the screenshots as they were confidential info. 

       

      What I'm trying to do is how to make the data in Material: ABC Stratification PowerBI look like the data from BOBJ Analysis.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi guys,

         

        Is there any sotution?

         

        Thanks a lot.

  • k_e's avatar
    k_e
    Frequent Visitor
    6 years ago

    Hello there,

    Isn't there any solution yet, I am facing the same issue. The key & text are available when connected using direct query & no longer available when the connection is switched to import mode