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

06 Jul

What are Lumira Documents?

geekycodesco0 CommentsSAP Lumira

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

06 Jul

How to open SAP BusinessObjects BI Platform (Legacy) Mode

geekycodesco0 CommentsSAP, SAP Lumira

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…

06 Jul

Start-Up Modes for the Design Tool

geekycodesco0 CommentsSAP, SAP Lumira

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…

06 Jul

Getting Started With SAP Lumira

geekycodesco0 CommentsSAP, 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…

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…

26 Nov

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

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

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