Question Re: SAP Analytics Cloud aggregation on drilldown in Technology Q&A

SAP Analytics Cloud aggregation on drilldown

alpharaffrobb — Thu, 28 Sep 2023 10:10:47 GMT

Hi All:

I have an SAP SAC Story Time Series Line Chart that aggregates the stock price when I drill down to year.

The Story imports from a Model (as opposed to dataset)

How do I simply show the stock price for IBM, Apple, etc on last day of the year, and not the cumulative or aggreated stock price.

Thanks

AlphaRobb

Re: SAP Analytics Cloud aggregation on drilldown

AnnePetteroe — Thu, 28 Sep 2023 10:11:26 GMT

Hello Robert,

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage your readers to respond.

Kind regards,
Anne

Re: SAP Analytics Cloud aggregation on drilldown

N1kh1l — Thu, 28 Sep 2023 10:39:29 GMT

alpharaffrobb

Depending on your model type, if you are using measures or Account member for price, set the exception aggregation to LAST with exception aggregation dimension as Time. Also if you have both Accounts and Measures in the model do check the structure priority of the model and set it to either Accounts or Measures depending on where you set the exception aggregation.

If using Account to store stock price

If using measure

Structure Priority if you both Measures and Account in the model

Hope this helps !!

Br.

Nikhil

Re: SAP Analytics Cloud aggregation on drilldown

alpharaffrobb — Tue, 31 Oct 2023 16:40:47 GMT

Thank you for your answer. I am just getting going on SAP SAC and this forum. I plan to regularly participate, and respond.

AlphaRobb

Re: SAP Analytics Cloud aggregation on drilldown

N1kh1l — Tue, 31 Oct 2023 17:53:56 GMT

alpharaffrobb

Welcome. Please close the thread by accepting the helpful answer so that it can help the wider community.

Br.

Nikhil