Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i want to create new tables from existing data. The new tables will get the sum up of data from the last 3 month and create a new date.
How can i do it by script?
regards,
sam
You could just load all tables and concatenate them within a single table and then by using a table-chart with product as dimension you could include a condition within the expression like:
sum({ Date = {">=01.01.2017<=31.03.2017"}>} Sales)
whereby it might be useful to add a master-calendar: How to use - Master-Calendar and Date-Values to your datamodel and to use then fileds like Month or YearMonthSeriellNumber to handle the dimensions and/or the conditions within the expressions.
- Marcus
You can use any approach described in
Calculating rolling n-period totals, averages or other aggregations
edit:
Well, these do not actually create aggregated facts tables in your model, but should server the reporting needs.