Hello,the requirement is rather simple, but i am not yet very experience in advanced formulas.I want to select a month of a specific year (defined as dynamic parameter) and then select a year (or year as the node of a date hierarchy). Then this month...
Hello everyone,
I am developing a custom widget for the SAC and want to use the Analytics Designer API (https://help.sap.com/doc/958d4c11261f42e992e8d01a4c0dde25/release/en-US/index.html).
In my case I want to be able to change the viewed story...
Hello,
is it possible to automatically import my exchange rates from an external institution like ECB?
I already found this community question from 2019, but the content there seems deprecated, as there is no "Automatic Market Rates management" I...
Hello,
I am trying to use the SAP.SETDATA formula.
When defining my table, value and dimensions I want to write, I only get back the value currently saved on my defined dimensions. The value I set in the SETDATA parameters is ignored.
Am I miss...
Hello,
I am currently working with the SAP Analytics Cloud Addin for Microsoft office.
I want to build some operating use case, where I insert a SAC table and then reference with Excel formula an Excel area / cell in my workbook.
What I experie...
I just figured it out myself, this is the code:MEMBERSET [d/Measures] = "VALUE_PROJECT"MEMBERSET [d/Date] = BASEMEMBER([d/Date].[h/YM], %TARGET_YEAR%)DATA()=RESULTLOOKUP ( [d/Date] = %SOURCE_MONTH%)
Hello,is the result different if you add the date dimension to the table?ist FC_Amount a measure or a "Conversion Measure"?If it is a measure, you need to run the data action everytime you change the Amount.You can also define the FC_Amount as a conv...
