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 ...
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.

      • dranny's avatar
        dranny
        Icon for Advocate I rankAdvocate I
        7 years ago

        No solution for this point ... I have same issue