SAC - [Difference from] with a generic dimension like [year.week]

[former_member638388]

Hello,

ist it possible in SAC to use a generic dimension to show value differences between datapoints? I have a Chart which is based on a dimension in the format year.week (and year.week_txt) which is not a official date format in SAC. With a dimension in date format its no problem to use previous periods for difference calculation.

Maybe there is a possibility with a calculated dimensions? So I can reference to the previous Data and show the difference of both values in %.

Thank you very much
Andreas

[mfoeken]

Hi Andreas,

To make sure you can plot the difference between two data points on the same data I would create these calculations in your data source. Which data source are you using?

Kind regards,

Martijn van Foeken | Interdobs

[former_member638388]

Hi Martijn,

thanks for your response. The model is based on a splitted SQL data source with around 8.000.000 rows. I guess you mean I should add a calculated column?

How would you prepare these calculations in order to the model to keep all filter possibilities?

Are there any other options like a calculated dimension directly in SAC? 🙂

Best regards

Andreas Untch

[mfoeken]

Hi Andreas,

For these type of use cases and data volume I would check out a new product that will be released soon and has an embedded version of SAP Analytics Cloud: https://saphanacloudservices.com/data-warehouse-cloud/. You can request a free trial version.

Kind regards,

Martijn van Foeken | Interdobs

[former_member638388]

Hi Martijn,

this is a very interesting product which I didn't hear of before. I will definitely keep it in mind for further intern discussions.
Unfortunately I need to hang with SAC and the implemented SQL connector at the moment. Because of company restrictions we decided to use this product for a new proof of concept.

I just had the idea to build a SQL function which recreates a date out of the input from year.week which delivers the friday date of the given week (last day of workweek). After that new column is in my model I will try to map the year.week as an description on the created date column so I can use the date as underlaying dimension and the year.week column as visualized description for the user. In theory this should be a possibility to work with the hidden time dimension.

Thank you for your fast help and the information about data warehouse cloud 🙂

Kind regards,
Andreas Untch