If you need alternatives to query browser in SAP Dashboards, Consider BIWS (SAP Business Intelligence web services)
Background: Your company has invested millions of dollars and purchased the BI 4.0 suite for reporting and dashboarding.
Problem: You are trying to build a dashboard in the traditional way and now you cannot map Bex variables to excel spreadsheet.
What does that mean to a dashboard design? SAP has restricted its customers from mapping the variables from BEx to excel spreadsheet. That means the only we can refresh a query is to use the “Query Prompt selector“. The query prompt selector itself works fine but its always a combo box for selection from user. If the user wants to click on the chart and refresh a query then its not possible. That is when you need to map the variables to the excel spreadsheet.
What can be done? Read more
SAP BW stands for Business warehouse (Data warehouse on SAP). The Business Information Warehouse (BW) is SAP’s architectural solution for data warehousing. It is a separate system from SAP transaction processing. No data is generated in SAP BW. It takes care of ETL and reporting both.
SAP BW History:
A Fact table consists of metrics, measurements, or facts of any business process. Facts and Dimensions are at the root of data warehouse. Facts are the metrics that senior management or board members of an organization use for making business decisions. Dimensional modeling brings together the relational model Read more
A dimension tables plays a critical role in data warehousing and has strong association with facts of the business process. It consists of descriptive attributes typically text fields which describe facts but are complete and have discreet values. Facts are the metrics that business houses use for making decisions. Dimensions are generally descriptions Read more
Data warehouse is mutidimensional data structure where Dimention is a category of information. For example, “Customer”, “Date”, and “Product” are all dimensions that could be applied meaningfully to a sales receipt. The primary function of dimensions is to filter, group and label. Read more
Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. It consists of numeric facts called measures which are categorized by dimensions.
In Star Schema all of the information about a dimension is stored in a single table. Each level of a hierarchy Read more
In relational database management system (RDBMS), the process of organizing data to minimize redundancy is called normalization. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. Read more
In a nutshell, a data warehouse is a “repository for historical data, used to make decision”. Of course there’s much more to it than that.
Data warehousing is a concept. It is a set of hardware and software components that can be used to better analyze the massive amounts of data that companies are accumulating to make better business decisions. Data Warehousing is not just data in the data warehouse, but also the architecture and tools to collect, query, analyze and present information. Read more