SAP

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
Change color for each column for crosstab in design studio

Change color for each column for crosstab in design studio

As probably you may know, when it comes to change the appearance of a crosstab in Design Studio. In Which you have to add some properties in the CSS file. To do so, there are available some posts in the Design Studio Community Forum. This talk about changing the style of the different parts of the crosstab (headers, rows, etc…). But there is not much information about complex changes such as hiding columns or changing columns names. Here, we are going to explain some tricks and tips that we have found in the community. Which allowed us to implement new…
Read More
How to wrap text column of a Dimension in Crosstab of Lumira Designer

How to wrap text column of a Dimension in Crosstab of Lumira Designer

Question We have build a dashboard in Lumira designer and used a crosstab in it. For a particular Characteristic (Dimension) for few rows in data sets the text value is more than 200 chars. Due to which entire column takes enormous width resulting in scroll. Is there any way we can wrap text the value of text shown in Char. Column if the original text cross a fixed width? Answer You can resize columns interactively. And you can pre-define column sizes in Designer using "Column Width" property. If the text doesn't fit, crosstab will cut it and show "..." at…
Read More
Scheduling an object with events in SAP BO

Scheduling an object with events in SAP BO

In this post we'll be explaining about scheduling an object with events in SAP BO. When you schedule an object with events, the object runs only when the event occurs. You can schedule objects to wait for the following event types: File-based: Triggered by the existence of a specified fileCustom: Manually triggeredSchedule-based: Triggered by another object running If you want a scheduled object to trigger an event, you must choose a schedule-based event. Scheduling objects based on an event When you schedule an object based on an event, the object will run only when the event is triggered and the…
Read More
Package Size & Impacts of Package Size in DTP

Package Size & Impacts of Package Size in DTP

Most of the BW consultants have raised a query in SCN for the performance issues they are facing while running DTP. To eliminate the issue of slow or long running DTP it is essential to understand the concept of Package Size & it’s impacts on the DTP. Once we are clear through it we might be able to eliminate the issue of long running DTPs. To start with, understanding of Package & Package Size in DTP is important. Let’s do that first. What is a Package? A Package is a bundle of data. It contains the records in group. What…
Read More