About ashutosh_rastogi

ashutosh_rastogi

IntroductionWe’re excited to announce analytical insights in Joule, powered by SAP Analytics Cloud with the upcoming Q1 2025 quarterly release of SAP Analytics Cloud. This post provides an overview of the capability, its current scope, future directi...

ashutosh_rastogi

In this blog, i will cover another common usecase where you need to display the percent contribution of a particular member of a dimension towards the measure. Usecase One In this case you have a table with Sales and Product Line Now, you want to se...

ashutosh_rastogi

In this blog I will cover two features of SAC stories that can help you out. Let's first understand the business scenario that needs to be achieved, and then we can get into details of those features. Business Scenario User has two measure groups ...

ashutosh_rastogi

If you have a usecase where you need to build assymetric table for displaying in SAP Analytics Cloud, you may not be able to achieve that with standard tables in SAC. In such cases, if the usecase is only consumption then R can be used to build such ...

ashutosh_rastogi

In this blog I would cover another usecase, where a user needs to see the last X months (say 12 months) trend. However, this last 12 months can be from the current month or a user selected month. For implementing such a scenario in SAP Analytics Clo...

ashutosh_rastogi

- When Joule will be enabled in SAC, will it replace "Just Ask" ?This is work in progress and you would see that sometime in 2025. No, it will not replace JustAsk.- Can Joule work with Datasphere models ?Yes, Analytical Insights in Joule plans to sup...

ashutosh_rastogi

Not sure on this one, however you can also use number of decimal places in Styling panel for the measure that you plan to round. -Ashutosh

ashutosh_rastogi

If you add totals by adding column manually. and calculating it as follows (would work with static number of columns only)And additionally use filters while defining threshold. In such case totals are not colored. -Ashutosh

ashutosh_rastogi

Your usecase seems to be in data cleansing area. Can you elaborate on the logic that you wish to use to change the date and to what date you will change it. This will help answer this clearly, whether it's possible or not. I understand from your ques...

ashutosh_rastogi

Hi Vijaya, Measure name cannot be dynamic in SAC.WorkaroundsYou can use the title of the table to indicate the year to which the data belongs. Something like Next option is to create restricted columns with each year as restriction. For instance Tota...

User Statistics

User Activity

Analytical Insights in Joule (powered by SAP Analytics Cloud), Controlled release in Q1 2025

Percent contribution for a measure in SAC

Dynamically change more than one columns in stories

Tables in SAC using flextable package of R

Last X months Trend for a given month

Re: Analytical Insights in Joule (powered by SAC), Controlled release in Q1 2025

Re: Round a calculated measure

Re: Totals column in table with conditional formatting

Re: How to compare values of a column across rows

Re: SAP Analytics Cloud dynamic text for measures in Table