SAP

What are Lumira Documents?

What are Lumira Documents?

Lumira documents are files produced with either SAP Lumira Discovery or SAP Lumira Designer that are stored on the BI platform. In both tools, SAP Lumira Designer and SAP Lumira Discovery, it is also possible to store Lumira documents on the user’s local machine in a common folder shared between SAP Lumira Designer and SAP Lumira Discovery, called SAP Lumira Documents. The file extension of locally stored Lumira documents is .lumx. End users access Lumira documents from the BI Launchpad. Differences with regard to the document creation tool Depending on the tool Lumira documents are created with, there are the following differences: Lumira Discovery documents can contain the following:One or more datasetsCharts built from datasetsStories that describe data using charts, text,…
Read More
How to open SAP BusinessObjects BI Platform (Legacy) Mode

How to open SAP BusinessObjects BI Platform (Legacy) Mode

To launch SAP Lumira Designer, choose Start  All Programs  SAP Business Intelligence  SAP Lumira  Lumira Designer. Depending on the mode in which you log on, perform the following steps: This mode lets you create analysis applications in the legacy format of Design Studio 1.6, which are stored on the BI platform. You can also open, edit, and save analysis applications created with Design Studio 1.6 on the BI platform in this mode. When you launch Lumira Designer for the first time, type the host and port of the BI platform in the Web Service URL: http(s)://<host>:<port>/dswsbobje/services/Session For further information, contact your system administrator.NoteOnce you have entered the host and port in…
Read More
Start-Up Modes for the Design Tool

Start-Up Modes for the Design Tool

SAP Lumira Designer can be used and started in the following modes: SAP Lumira Documents mode: This is the default mode that supports the creation of Lumira documents, which may contain any number of analysis applications, composites, MIME objects and/or offline datasets created with Lumira Discovery. This mode can handle both local documents and documents stored on the BI platform.SAP BusinessObjects BI Platform (Legacy): This mode supports the creation of analysis applications in the legacy format of Design Studio 1.6, which are stored on the BI platform. You can also open, edit and save analysis applications created with Design Studio 1.6 on the BI…
Read More
Getting Started With SAP Lumira

Getting Started With SAP Lumira

What is SAP Lumira SAP Lumira helps customers access information from trusted business data and personal data sources, and share such information through interactive displays, news, and analytics applications with other users, desktop browsers, and mobile devices. SAP Lumira provides connectivity to SAP business data models in SAP BW, SAP HANA, and SAP BusinessObjects universes (UNX) as well as a variety of third-party information and file data, for data acquisition, cleaning, and fraud. Additionally, fully integrated SAP HANA and SAP BW internet (including BW Integrated Planning and SAP Business Planning and Consolidation 10.1 Embedded) data models are provided to enable…
Read More
How to resolve:- requested state cache element does not exist for key

How to resolve:- requested state cache element does not exist for key

S: RSSDK:400 Requested state cache element does not exist for key 1 Issue Description: While extracting data from SQL server(Source system) to BW System we might face this issue. Even when the RFC connection is fine. Reason- When the data is sent back to BW from the SQL source system, the JDBC connector gets confused between systems, and either the load fails or gets the wrong number of records every time in BW. Solution Go to transaction SM59 and compare the parameters supplied there with the ones found in Visual Administrator. The destination should be listed under TCP/IP connections. The…
Read More
How to create a process chain? Step By Step

How to create a process chain? Step By Step

I want to continue my series for beginners new to SAP BI. In this blog, I write down the necessary steps how to create a process chain loading data with an info package and with a DTP, activation, and scheduling of this chain. 1.) Call transaction RSPC RSPC is the central transaction for all your process chain maintenance. Here you find on the left existing process chains sorted by “application components”.  The default mode is planning view. There are two other views available: Check view and protocol view.  2.) Create a new process chain  To create a new process chain, press the “Create” icon…
Read More
Types of DTP in SAP BW

Types of DTP in SAP BW

DTP determines the process of transferring data between two persistent / non-persistent objects within the BI. In this blog we'll be discussing about the types of DTP in SA Starting with SAP NetWeaver 7.0, InfoPackage uploads data from Source System to PSA. DTP decides to upload more data thereafter. Use Uploading data from PSA to InfoProvider (s).Transferring data from one InfoProvider to another within the BI.Distribution of targeted data outside the BI system; e.g. Open HUBs, etc.In the process of transferring data within the BI, Transformation defines the map layout and logical data analysis for targeted data while, Output Mode…
Read More
How to calculate the period of the previous month.

How to calculate the period of the previous month.

There are lots of ways to solve this; I will provide a few and you can choose and modify however you see fit. I am making the assumption you want to get the data for a given month; most likely the previous month, but you could easily get a different month. 1. Variables in WEBI First, I created a variable so I could test various dates (e.g. crossing years, different length months) Var Reference Date=ToDate("08/30/2021"; "M/d/yyyy") Next we want to create a variable to hold the first day of the month previous to Var Reference Date. We do that by subtracting…
Read More
INFO CUBES in SAP BW/BI

INFO CUBES in SAP BW/BI

INFOCUBES in SAP BW Infocube is data storage area in which we maintain data which we are extracting from source system physically. An Info cube can function as both a data target and an Info provider. From a reporting point of view, an Info cube can be described as a self-contained data set.For example, a Sales Amount Info cube which has dimensions like MONTH – PRODUCT-CUSTOMER-REGION can be viewed by any of the axes, for example total sales by region or by customer. The dimensions of an Info-Cube are entities or hierarchies. How to create an Infocube: Step 1) - Go to…
Read More
SAP Business Warehousing/Business Intelligence (BW/BI) Introduction

SAP Business Warehousing/Business Intelligence (BW/BI) Introduction

SAP Business Intelligence (BI) SAP is full formed as Systems, Applications and Products in Data processing and SAP's Business Intelligence (BI) or SAP Business Warehousing(BW) is basically a SAP's module which is created in order to analyze and to create reports on the basis of data from different heterogeneous data sources. SAP Business Warehouse (BW) integrates data from different sources, transforms and consolidates the data, does data cleansing, and storing of data as well. It also includes data modeling, administration and staging area. SAP BI/BW is a technical module created by SAP, previously it was named as Business Information Warehousing (BIW), after then it became Business Warehousing (BW) and then again Business Intelligence,…
Read More