Skip to Content

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

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

year-week.png (23.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Oct 26, 2019 at 04:39 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Oct 28, 2019 at 08:36 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.