Introduction to SAP Analytics Cloud [Edition 1]
source link: https://blogs.sap.com/2023/01/25/introduction-to-sap-analytics-cloud-edition-1/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Introduction to SAP Analytics Cloud [Edition 1]
Edition 1- SAP SAC Support
From S4HANA system we are extracting data to SAC using HANA CDS Views:
S4HANA— HANA CDS Views— SAC
- Core Data Service (CDS) Views: are virtual data models of SAP HANA which allows direct access to underlying tables of the HANA database. SAP CDS Views came into being with SAP’s new programming model. SAP CDS Viewsaim to push logic from the application server to the client-side anddatabase.
There are two types ofCDS
- Standard
- Customized
- Depending upon the Client’s requirement we will work on it accordingly.
- After Modelling the Data in SAC, Stories will be created for Analysis.
- Reporting will be done on Stories:
- Standard Story
- Customized Story
BWS4HANA:
- BW4hana is allows you to consolidate data across the enterprise to get a consistent, agreed-upon view of your data.
- SAP BW/4HANA aims to reduce the complexity of the development environment and decrease the end-to-end development time.
- SAP S/4HANA is an ERP business suite based on the SAP HANA in-memory database that allows companies to perform transactions and analyze business data in real time.
- S/4 is an ERP solution, BW is Data Warehousing framework, HANA is a DBMS that have an ability to run application platform inside it (XS Advanced). S/4 and BW/4 both run on NetWeaver platform and they both use HANA DBMS underneath.
CURRENCY: The following currency types are available in the system:
- Transaction Currency
Currency in which a document is posted (currency type 00).
- Company Code Currency
The company code currency is the currency in which the local ledgers are managed in external Accounting (currency type 10). It is already predefined in the system and is the national currency of the company code.
- Group Currency(Global & Local Currency)
The group currency is used as the global currency, which allows amounts to be compared in a single currency (currency type 30). You specify your group currency before you install your system. The respective currency code applies for each client and consequently for all company codes and ledgers
OLAP OVERVIEW:
- Relational databases store data as individual records. Each record may contain a number of fields, but all these fields relate to just one record. For example, a Product record might have a number of fields containing information about that Product, such as sales transactions to different customers in different regions.
- Online Transaction Processing (OLTP) applications are used to query this information and keep it up to date. OLTP is designed to enable a large number of users to update and retrieve comparatively small numbers of individual records quickly.
- Online Analytical Processing (OLAP) applications are designed from the start with online data analysis in mind. To reduce processing time, relational data is summarized and pre-consolidated into matrix table format. Because these tables usually have three (or more) dimensions, they are referred to as data "cubes". OLAP data represents the hierarchical aggregations of the individual transactions. Consequently, the aggregated data can be analyzed much faster than relational data.
Recommend
-
12
(Neo4j Blog)←[:BACK] Neo4j in the News – Spring Edition: Cloud, Graph Analytics, and the Next Decade of Graph
-
14
Tammy Powlas August 16, 2021 6 minute read ...
-
5
Marcus Homann June 2, 2022 1 minute read
-
7
SAP S/4HANA Cloud, Private Edition, and SAP S/4HANA for Governance, Risk, and Compliance (GRC)| 2022 Product Update This blog illustrates selected highlights in the area of Governance, Risk, and Compliance (GRC) wi...
-
6
SAP S/4HANA Cloud, private edition, and SAP S/4HANA for Product Compliance | 2022 release – Part 2 The most widely applied regulation concerns the transport of dangerous goods. Dangerous goods, abbreviated as DG, are subst...
-
8
SAP S/4HANA Cloud, private edition, and SAP S/4HANA for Product Compliance | 2022 release – Part 3 Companies operate in the context of many national and international rules and regulations when they produce or sell product...
-
7
Claudia Rosbach February 8, 2023 2 minute read
-
5
Bert Schulze February 27, 2023 4 minute read
-
12
Vincent Zhu April 6, 2023 6 minute read ...
-
12
Marco Valencia April 5, 2023 4 minute read...
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK