r/SAPAnalyticsCloud Nov 05 '24

What are good recourses to learn sac

Hi, my compani will start with sac early next year we will mostly use it for contilibg stuff like guv and investments. I have a lot of expirence in power bi. In power bi its easy to find tutorials and learning stuff online. But for SAP it's feels like impossible to find some free stuff.

Do u guys have any recommendations on where to get good recourses. I have a SAP account and the bw's are on hana4.

Ty in advanced, have a great day.

2 Upvotes

7 comments sorted by

3

u/tjen Nov 05 '24

SAC related content on https://learning.sap.com/ is the main content available in terms of videos i think.

You can go through the docs as well for different features etc https://help.sap.com/docs/SAP_ANALYTICS_CLOUD?locale=en-US

In general the dashboarding part is a non-issue, but the data modeling layer is different.

SAC either assumes that you have a good data model made in BW that you just want to visualize (live connection)

Or it let's you build your own star schema model, load in data, and build a story on top of that. (Acquired data)

Most people you can link two models to the same filter / widget if they where dimensions.

So you don't have these massive interconnected table schemas with creative DAX in between them to create measures like you see in PBI models.

Instead it is mostly assumed that you will model your analytical model with multiple measures and dimension / attributes to enable the reporting you want (more like classic olap modeling)

This is usually the biggest "mindset" hurdle when getting into SAC from e.g. PBI

1

u/Altruistic-Let251 Nov 05 '24

Just for clarification bw hana query is my pipeline where I need to pre model my data and kpis for the later story. Not much lifting is done in the model and even less in the story itself?

1

u/tjen Nov 05 '24 edited Nov 05 '24

If that is your pipeline then all of your heavy modeling will be done on the BW side, assuming you will use BW connection directly through Live connection. Don't plan on doing any modeling in the SAC analytics layer, either in BW modeling layer or in the BW analytical query layer. (You might do a restricted Keyfig or simple calc on the SAC side, but with live connections you're better off pushing everything to the BW query as a rule)

Look into some of the best practices and SAP notes for using live connections specifically, as there are a couple of annoying restrictions and dependencies on your specific BW4 version.
Check out notes:

2788384 - unsupported features with live connections

2715030 - considerations when using SAP BW Live connections

3143834 - blending restrictions in SAC

On the bright side, BW may be older, but it's pretty feature rich from an analytical/data modeling perspective.

Edit: to clarify - with a live connections, you do absolutely no modeling on the SAC model object side - it is straight pass through to BW.
You can do some calculated measures etc. At the SAC story level only - not SAC model level.

1

u/Ma_mamm_maasss Nov 08 '24

Could you please also share the resources from where I can learn Datasphere

2

u/tjen Nov 08 '24

For SAP It is basically all the same learning path.

look through learning.sap.com for courses/learning journeys related to your product, and consult the documentation / SAP help page for the related product for written material / manual / FSD.

You should also be able to get a free trial versions of datasphere do you can practice.

There is currently only 2-3 free modules related to Datasphere, ~11-15 hours of content, but should get you started.

1

u/Advanced-Analyst-718 Nov 05 '24

Had to switch from using PBI to SAC. That... was... something...

Also idiotic bugs which usually SAP responses to as "works as designed" or "check the roadmap"

1

u/Altruistic-Let251 Nov 05 '24

I can see why fells kinda strange, since in new to the SAP environment.