3 weeks ago
Hi,
I have made a model in SAC which is getting updated every day from a sap hana database.
Now I want to have it in such a way that it always has the current months and past 23 months. But I don't know how to make this. I can filter on the year, such that I only have 2024 and 2025. But I want to have it that I have now feb 2023 to jan 2025 included and next month march 2023 till feb 2025. Is this possible?
Also when I want to add something to a model later on it says:
I want to change a attribute of a column to textual but this is not allowed. Are you not allowed to change a model once it is made?
Request clarification before answering.
Unfortunately, as far as I know, only the filters of a query are available for changes after it is saved for the first time. The selected fields will not be modifiable.
Also, about the filter for the date, I could not get it working either. It will not let me use any sort of dynamic parameter (E.g. greater than "last quarter of previous year", or smaller than "today's date"...), so you would need to load a wider period, then later remove the undesirable records once they get saved in your SAC model (E.g. Jan 2023 to Jan 2026). This approach will require you to maintain, from time to time, the filters of the query, just so you always have a range of dates that includes the 23 months that you need in SAC. You can use a data action to clear up your database. In the DA you will be able to setup a more dynamic code to always get you the 23 months that you want - put it in the calendar to run right after the query is executed.
For the property/ attribute of your dimension, I don't think you can change it to text or anything else, once it is saved as integer and add master data in it. The opposite way could be done, from text to integer, I believe.
I hope it helps, let us know if you find a smarter way to solve these questions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks @andrepaccagnella,
Does it impact the performance if you use a Data Action to filter? The reason we want only 23 months and current is due to capacity. I can imagine sending the query and filtering it afterwards might be to much for the system?
Best regards,
Rick
User | Count |
---|---|
56 | |
10 | |
8 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.