SAP Q&A | Geeky Codes- Code Like A Geek But In Style

04 Apr

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

geekycodesco0 CommentsSAP, SAP Q&ABusiness Warehouse, BW, BW HAna, SAP, SAP BW, SAP BW HANA, SAP Error, SAP Error resolution

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…

14 Feb

How to create a process chain? Step By Step

geekycodesco0 CommentsSAP, SAP BW, SAP Q&Acreate a process chain, How to create a process chain, Process, Process chain, SAP, SAP Process chain, Schedule a process chain, Scheduling a process chain

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…

03 Jan

Types of DTP in SAP BW

geekycodesco0 CommentsBlog, SAP, SAP BW, SAP Q&A, TutorialsBusiness Intelligence, Business Objects, Business Warehouse, Data Transfer Protocol, SAP, 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…

09 Dec

How to calculate the period of the previous month.

geekycodesco0 CommentsSAP, SAP Q&ASAP, SAP BI, SAP BO, SAP BW, SAP BW HANA, SAP Crosstab, SAP Design Studio, SAP F Q&A, SAP HANA, SAP Lumira, SAP Q&A

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…

26 Nov

INFO CUBES in SAP BW/BI

geekycodesco0 CommentsSAP, SAP Q&ASAP, SAP BI, SAP BO, SAP BW, SAP BW HANA, SAP F Q&A, SAP HANA, SAP Q&A

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…

12 Nov

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

geekycodesco0 CommentsBlog, SAP, SAP Q&ACrosstab, Lumira Designer, SAP, SAP BI, SAP BO, SAP Crosstab, SAP F Q&A, SAP Lumira, SAP Q&A, Wrap text column

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…