KEMBAR78
SAP Analytics Cloud FAQ | PDF | Analytics | Data Model
Scribd
Upload
284 views2 pages

SAP Analytics Cloud FAQ

SAP Analytics Cloud (SAC) allows users to connect live to data sources like SAP S/4HANA for analysis and reporting. Models in SAC are used for data modeling, wrangling, defining measures and dimensions, and enhancing the data. Dimensions are qualitative while measures are numerical values that can be totaled or averaged. SAC supports different types of hierarchies and calculated columns in models. Live connections access real-time data while import connections use static imported data. Dimension and measure properties can be configured along with currency conversion settings.

Uploaded by

Gurappa Chemuduru
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
284 views2 pages

SAP Analytics Cloud FAQ

SAP Analytics Cloud (SAC) allows users to connect live to data sources like SAP S/4HANA for analysis and reporting. Models in SAC are used for data modeling, wrangling, defining measures and dimensions, and enhancing the data. Dimensions are qualitative while measures are numerical values that can be totaled or averaged. SAC supports different types of hierarchies and calculated columns in models. Live connections access real-time data while import connections use static imported data. Dimension and measure properties can be configured along with currency conversion settings.

Uploaded by

Gurappa Chemuduru
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

1. What is SAP Analytics Cloud?

2. How SAC is differing than other Reporting tools?


3. What is pre requisites for SAC ?
4. What type connections support in SAC?
5. What is the difference between Live and Import connection?
6. What is sources support in Live connection in SAC?
7. What is the process create the SAC reports?
8. What is the Model?

Models are where you do all your data modeling in preparation for analysis. Data modeling
entails data wrangling, or cleaning, your dataset, defining your measures and dimensions,
and enhancing your data by establishing hierarchies, setting units and currencies, and adding
formulas.

Create New Model: Blank Model .Import from files(Excel or CSV),Live Data Model, From a
Data source.
9. What is dimension and Measure?

Measures are numerical values that mathematical functions work on. For example, a sales
revenue column is a measure because you can find out a total or average the data.
Dimensions are qualitative and do not total a sum. For example, sales region, employee,
location, or date are dimensions.

10. Types of Models and usage?


11. What is Account Dimension?
12. What actions we can perform in Data model?
13. What type of Hierarchies available?
14. What is calculated column in Modeler
15. What is the difference between Model and Dataset?
16. Currency conversion setting in model
17. Assign the currency and units
18. Dimensions and measures
19. Dimension adding attributes ,properties
20. Datawrangling
21. What is Smart Discovery ?
22.

Capgemini:

23. What type of predictive scenarios available in SAC


24. What is the difference between smart discovery and smart insights
25. How to create currency table in SAC
26. How to create planning model using Live Connection
27. How to created nested if with count
28. Tool Tip
29. Linked Analysis
30. How to create Universe using their different data sources?
31. If you migrate UNV linked universe to UNX universe, how many data foundations created?
32. How implement Row level security in SAC?
33. Have you worked Planning?
34. Can we restrict story filters to one page if story has multiple pages?
35. Have you worked Analytics Designer ?
36. How you implement cascading filters in Analytics Designer?
37. What is the difference between Designer and Story ?

SAC Live Connection with S4HANA (Limitations)


 
1. Dimension calculation not available
2. Measure only calculated measure and Restricted measure available remaining calculation
measure type not available.
3. Cross calculation not available
4. Exception aggregation not available
We cannot create any calculations and enrich the data at Model level.
Rank is not possible in live connection with S4HANA

You might also like