SAP Q&A

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
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