tag:blogger.com,1999:blog-34613911052308456602024-03-17T08:22:31.706+01:00Martin Maruskin blog (something about SAP)Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.comBlogger1005125tag:blogger.com,1999:blog-3461391105230845660.post-40463890712943184222024-02-22T11:34:00.001+01:002024-02-22T11:47:13.241+01:00How to switch BPC environment state (on/off line)?In
one of my older posts, I explained few ways how
to check BPC environment state. Either it is online or offline. This time I
focus on how to change the state of the BPC environment.
1.
in BPC web
client: In main screen of web client choose Settings button on top
right corner. From there click on Environment button in a drop down Settings menu.There
is a new popup shown as next with a listing Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-84801506008527276392024-01-13T16:08:00.000+01:002024-01-13T16:08:03.943+01:00System does not let you log on using a passwordIn
case user is getting a below message on attempt to logon to SAP NetWeaver/ABAP
Platform based system:
This system does not let you log on
using a password
Message no 00139
It
means that password based logon to particular system was disabled. In such a
case user has to use different authentication method to logon. There are following:
•
Using password (conventional logon) – method Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-7128172824246590402023-12-26T19:55:00.005+01:002023-12-26T19:55:38.606+01:00Request Status Process Management (RSPM)Request
Status Process Management (RSPM) concept for BW request management is in place
since a higher support packages of SAP BW 7.5 and also in SAP BW4/HANA. It replaces RSSM (Request Status Management) request
management based on 0REQUID. The Request
Status Process Management (RSPM) based on Request Transaction Sequence Numbers
(TSN, 0REQTSN). Details can be found here.
However, in this
post IMartin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-91120898569493334832023-12-26T11:35:00.002+01:002024-02-10T06:29:58.778+01:00PC does not start due to not maintained start variantI
faced recently a strange error within my newly created process chain. On attempt
to start it up, I got below error message:Job could not be released. Probably an
authorization issueMessage no. RSAR051I was sure
that it has nothing to do with the authorization. I checked what user is
assigned into the chain in its attributes as Execution User. That user did not
lack any authorization too.
It
Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-48367662556537620782023-12-16T19:23:00.007+01:002023-12-16T19:24:28.183+01:00"Results table" feature in SAP Code InspectorSAP
Code Inspector (t-code SCI) is a tool for analyzing and inspecting ABAP code.
The tool is to help ABAP developers to ensure that ABAP code complies with
certain coding standards, performance guidelines, and best practices. It
performs static code checks, which means it analyzes the source code without
actually executing it. The tool identifies potential issues, vulnerabilities,
and areas for Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-27606006161167990662023-12-16T11:37:00.003+01:002023-12-16T11:37:58.955+01:00BW/4HANA 2.0: External SAP HANA SQL ViewThere
is a new feature in BW/4HANA 2.0 starting with Initial
Shipment Stack. In this version of the SAP BW4/HANA 2.0 is external SAP
HANA SQL View introduced. The new view follows one
of principles of SAP BW4/HANA, which is openness.
In
older releases of SAP BW4/HANA
there wasn’t dedicated SQL view to support an extraction from aDSO objects. As
SAP doesn’t recommends to use active table of the Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-27118821501968884782023-11-02T22:42:00.003+01:002023-11-02T22:42:31.256+01:00SAP_INFOCUBE_DESIGNS toolIn
case dimension tables of star schema data model becomes too large comparing to
fact table there can be a performance problems. Thus, it needs to be monitored.
SAP provides a tool for that. It is ABAP program called SAP_INFOCUBE_DESIGNS. The tool provides a list of cubes associated
with number of rows and density % rate for each if the cube.
The
density ratio means a number of rows in the cubeMartin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-35346521491009795802023-10-31T23:58:00.003+01:002023-11-02T22:43:13.759+01:00BW/4HANA obsolete toolsIn
SAP
BW4/HANA many tools that were present in earlier releases of BW became
obsolete. This is has few reasons. Mostly it is because the BW/4 uses less objects
comparing to classic BW. The BW/4 is simplified in many ways – see details about
it here.
Below
I tried to compile a list of the obsolete tools in BW4/HANA. This blog post
complements my earlier post about t-codes that are obsolete in BWMartin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-57789089727048537422023-10-31T23:34:00.003+01:002023-10-31T23:35:40.791+01:00BWonHANA: SAP HANA-Optimized DataStore ObjectIn BWonHANA BW
systems there was a new object introduced. It was SAP HANA-Optimized DataStore Object. I mentioned it in my blog post
related to BWonHANA
- Benefits
of #BWonHANA. It was a type of DSO object that was optimized for HANA DB. This
objects do not have any data in its change log table stored persistently. The
change log table is calculated on the fly via HANA’s calculation view. Data isMartin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-79217749989747273292023-10-31T22:23:00.000+01:002023-10-31T22:23:11.110+01:00BW objects - Differences between DDIC and DBBW
system generates a lot of temporary database objects while it is running e.g.
during query execution, or other processes that read data from BW infoproviders.
These objects can be database views or tables. Mostly they are placed in '/BI0/0'
namespace.
I
wrote some information about the BW temporary objects here.
In that blog post I mentioned that program SAP_DROP_TMPTABLES
can be used to Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-9074541282233446812023-10-27T11:42:00.003+01:002023-10-27T11:42:58.915+01:00Slice statistics in BWTo
be able to use slice statistics in BW there are few things to be customized.
Via t-code RSDDSTAT_SEL_CUST (program
RSDDSTAT_SEL_CUSTOMIZE that calls function module RSDDSTAT_SEL_MAINTAIN) a selection
statistics for particular InfoProvider (mostly aDSO in BW/4 based systems)
needs to be activated.
The
all the InfoProviders for which it was customized is stored in table RSDDSTATSLICECUS
(Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com2tag:blogger.com,1999:blog-3461391105230845660.post-5830253900914106072023-09-24T21:28:00.006+01:002023-09-24T21:28:39.006+01:00SAP PowerConnectSAP
PowerConnect for Splunk is a tool to capture data about an events in SAP
systems and upload it to a Splunk software in real time. The data is analyzed
to and visualized as SAP telemetry intelligence in the Splunk. The SAP
telemetry provides analytical information on efficiency of the systems of SAP
in a local and cloud environment.
The
PowerConnect tool was originally developed by BNW Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-64211495633437074532023-08-27T16:14:00.004+01:002023-08-27T16:14:52.683+01:00Reserved key words for SAP table fieldsWhen
it comes to table creation in SAP Data Dictionary (DDIC) there is a check
performed whether particular field (names of table columns) is not reserved. If
so the dictionary object cannot be activated. This applies regardless the table
is created manually or generated by the system. Automatically generated
dictionary objects can involve in BW objects like aDSOs, Open Hubs, etc. In
other Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-85810439521547957212023-08-24T14:37:00.005+01:002023-08-24T14:37:50.042+01:00Unavailable SAP Notes There are a few
cases when SAP Notes or Knowledge Base Articles (KBA) are not available to be
viewed on SAP for Me (formerly ONE Support Lunchpad (OSS)) site.
1.
SAP Note/KBA XXXXXXX is being updated.
This happens when there is a new version of particular Note being prepared. As usually
the Notes has initially a version in its master language it can be that, there
is a few daysMartin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-2225862370252200222023-08-04T11:38:00.002+01:002023-08-04T11:43:46.671+01:00ABAP Platform Trial 1909 SP07Last time when SAP
released an on premise version of SAP ABAP Platform/NetWeaver developer edition
was on Feb 15th 2021. It was a version called SAP
ABAP Platform 1909, Developer Edition and it was provided as a Docker
image allowing developers run it on its own machines as a container. That
edition was available till Dec 2021 when Log4J
vulnerability was revealed. The ABAP Platform
1909 became aMartin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-31416616555614069762023-07-29T08:35:00.004+01:002023-07-29T08:37:01.503+01:00Repairable DTP data load requestWhen
using Data Transfer
Processes (DTPs) to load data, there is an important feature called "Reparability" If a data load
request fails, it appears in red status, indicating that the data was not
loaded correctly into the target destination. Such failures can occur due to
various reasons, such as extraction issues, network errors, database locks,
data transformation errors, or data integrity Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-21086567730861070532023-07-27T18:46:00.007+01:002023-07-27T19:04:07.882+01:00SAP BW Standard Transport SystemIn
SAP BW a transport system is used to
move BW objects from one system to another. This system facilitates the
movement of data models, data sources, transformations, InfoObjects, DataStore
Objects, queries objects and other BW specific artifacts between different
environments, such as development, testing, and production systems. The
standard transport system in SAP BW is part of the overall Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-17131762673221694112023-07-11T23:05:00.005+01:002023-07-11T23:05:41.326+01:00Program to find personal data in BW/BEx report objectsWithin
BW reports (formerly BEx reports), there can be a personal information in form
of SAP user name or email stored. There are multiple BW
report objects that can store such an information. It can be query element
(ELEM), query view (QVIW), workbook (XLBW), web template (BTMP), enterprise report
(ERPT), broadcast settings (BRSE), bookmark (ABAP, JAVA runtime or BICS), web
item (BITM), Query Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-59041680724527272812023-07-09T09:08:00.003+01:002023-07-09T09:08:48.927+01:00SAP Notes in different languagesThere
is a translation of SAP Notes content available on SAP support side for quite
some time. A links to translated Notes are available usually at the very end of
the note. There is a section called Available Language that lists out all the
languages. There
can is an URL parameter that can be used to access the SAP Note in a specific
language. Like below examples:
https://me.sap.com/notes/Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-51896215450849442282023-06-28T22:45:00.001+01:002023-06-28T22:45:50.399+01:00SAP Data Warehousing solutions as of 2023Data
warehousing is a category of enterprise software that integrates a data from
different sources, transform it into a consistent and structured format, and
provide users with easy access to the information needed for decision-making
purposes.
As
of Q2 2023 SAP has three data warehouse
solutions depending on its deployment scenarios:
A) on-prem & private cloud: 1.
SAP
HANA SQL DWHMartin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-22443167994837492382023-06-22T16:02:00.006+01:002023-06-22T16:02:49.214+01:00Upport Downport Overview (UDO) toolSAP
as any other software vendor needs to support its software thru its whole lifecycle.
This involves also providing code changes introduced in higher-level releases
to lower ones. Process like that is so called downporting. There can be a e.g. legal reasons for that.
Downporting
is the process of porting an application or software component from a higher
version of a platform to a lower Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-86888557937811408602023-06-21T21:15:00.003+01:002023-06-21T21:15:32.253+01:00Enhanced Master Data UpdateOne
of a new BW features that were introduced in BW4/HANA version is
Enhanced Master Data Update. It can be enabled for a characteristics (attributes
and/or texts) type of Info Objects. Only the characteristics that do have
master data is supported. This feature brings a possibility of parallel loading
of data to the IO. There are new tables created for the IO in case the feature
is enabled. The Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-92035417948087726252023-06-18T11:25:00.003+01:002023-06-18T11:25:22.574+01:00Consuming data from BW or BW/4 in BW based on ODPIn
Classic BW systems the scenarios when BW serves a data to other BW systems
involves creation of so called export DataSource (DS). That DS is created in
source system and it has a naming convention 8*. In other BW system where the
DS to be is consumed the export DS is replicated and means afterwards it is
visible in the target system. From there on a data flow can be built on topo of
that Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-18825131237338931722023-06-11T13:42:00.002+01:002023-06-11T13:42:45.733+01:00What is a difference SAP RISE vs SAP GROW (GROW with SAP)?SAP
tries to pitch its S/4 cloud solution to its customers very hard for a years. However
as per surveys conducted by the SAP User groups like ASUG or DSAG the adoption
is not at the level SAP would wish it would be.
Therefore,
SAP continues to provide offerings to help customers with their transformation
to S/4. It started back in 2021 with SAP RISE
followed by this year (March 21st 2023) Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0tag:blogger.com,1999:blog-3461391105230845660.post-49418009704890615172023-06-01T22:17:00.006+01:002023-06-01T22:19:54.129+01:00SAP Smart Data Integration (SDI) and difference vs Smart Data Access (SDA)HANA
as data management platform needs to connect to other data sources to get a
data. There are many integration patterns to follow to enable the connection.
There is an ETL processing, real time replication, data integration etc. Each of
them has its own advantages as well as disadvantages. With the introduction of SAP
HANA Smart Data Integration (SDI) the SAP is pursuing to get the best of Martin Maruskinhttp://www.blogger.com/profile/11523191743837925891noreply@blogger.com0