About Charlielin

Charlielin

Dear Expert, I am trying to calculate the difference of GP% between current year and last year. But the formula behave kind of weird. Here is our sample data:We have calculated the GP% for 2024/08 and 2024/07 in the Analytic Model of Datasphere and...

Charlielin

Dear Experts, I am facing some performance issues with datasphere modeling. Here is my design structures:Background: We have to create SAC report based on COPA Actual/Plan Data and some other External Data as well.Modeling Steps refer to above:1. P...

Charlielin

Hi Experts, I am facing a requirement where I need to calculate Input Month, Last year Input month, Previous Month, YTD of income statement figures(SAP COPA Data) all on the same report using SAC(as below), the source data is from Datasphere. Cross ...

Charlielin

Thanks for your reply. Unfortunately, we are using live connection to Datasphere so exception aggregation cant be done at SAC side.

Charlielin

Thanks for your reply. I've tried to create a new formula in SAC but no luck. The GP% is already pre-calculate in the Analytic Model of Datasphere. I also tried to pre-calculate GP% in the prior level(View) but it turns out even worse, it seem to cal...

Charlielin

Thanks for your reply. I've analyzed the PlanViz file and change the model and now it's down to 2 secs in the preview of analytical model. But when it's directly consumed by SAC, it takes almost 2 mins to bring out the result. Guess i have to work wi...

Charlielin

I think the best practice is to follow the star schema design, firstly create a dimension(Master data attribute) and associate with text then associate the dimension to the FACT souce

Charlielin

Yes, we are trying to do row-based calculation so called "Cross Calculation" in Optimized design experience in SAC. A/B/C measures are key figures representing different kind of KPIs. Customer requested the format in this way so we are figuring out i...

User Statistics

User Activity

SAC Calculate after aggregation based on datasphere

Datasphere performance issue

Calculate Current Month, Last year same month, Previous Month, YTD, for [Cross Calculation] on SAC

Re: SAC Calculate after aggregation based on datasphere

Re: SAC Calculate after aggregation based on datasphere

Re: Datasphere performance issue

Re: Datasphere : Text association to analytical model

Re: Calculate Current Month, Last year same month, Previo...