Forum Discussion

KrzysztofK's avatar
KrzysztofK
Frequent Visitor
5 years ago
Solved

SAP HANA Message Server - Using list declared list elements as parameter for query

Hello!  I am working on self-updating report based on SAP HANA Message Server, I am relatively new with using this datasource and have some problems with understanding logic of Cube.* functions: ...
Need Help
  • KrzysztofK's avatar
    KrzysztofK
    5 years ago

    Hello, 

    So it turns out I was on a right track to resolve it. What finaly worked was: 
    1. create a query that contained values I wanted to act as parameters, make sure at the end of the transformation you change it to list:

    2. Replace text parameter with query in code:

     

    {Cube.ApplyParameter, "[!V000003]", {#"Period list"}},


    This worked like a charm, and using simple logic based on DateTime.IsNow() you can easily make the list self updated. 


     

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, KrzysztofK 

I’m not very familiar with connecting to SAP HANA Message Server and using list declared list elements as a parameter for the query, you can check these cases and documents and find if it can make any help:

https://docs.microsoft.com/en-us/power-query/connectors/sap-bw/message-setup-and-connect

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sap-bw-connector

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other-mso_2016/unexpected-error-power-query-specified-method-is/1a2eb905-6cf7-405f-b9bf-c47b7cbd0558

If they can’t help you, I suggest you to @ some top kudoed/solution authors to help you so that your case can get more attention.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

KrzysztofK's avatar
KrzysztofK
Frequent Visitor
5 years ago

Hello, 

So it turns out I was on a right track to resolve it. What finaly worked was: 
1. create a query that contained values I wanted to act as parameters, make sure at the end of the transformation you change it to list:

2. Replace text parameter with query in code:

 

{Cube.ApplyParameter, "[!V000003]", {#"Period list"}},


This worked like a charm, and using simple logic based on DateTime.IsNow() you can easily make the list self updated.