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.