Articles on Trending Technologies

Technical articles with clear explanations and examples

CUID format in SAP BO Server Repository

SAP Expert
SAP Expert
Updated on 12-Jun-2020 746 Views

As per my understanding, CUID is a 35 characters and normally starts with A, B, C, F, K and M. To know formatting of different ID types, you can refer to this:SAP Note: 1285103: What are the different types of IDs used in the BusinessObjects Enterprise repository?CUID: CUIDs are Globally Unique Identifiers that uniquely identify an InfoObject, both within a single CMS cluster and across multiple CMS clusters. Because CUIDs are strings they are less efficient to use and slower to query for. Unlike an object’s ID, an object’s CUID stays the same when it is migrated to a new ...

Read More

Difference between PX, EM and Percent

Nishtha Thakur
Nishtha Thakur
Updated on 12-Jun-2020 650 Views

The px unit defines a measurement in screen pixels. The following is an example −div {    padding: 40px; }The em unit is a relative measurement for the height of a font in em spaces. Because an em unit is equivalent to the size of a given font, if you assign a font to 12pt, each "em" unit would be 12pt; thus, 2em would be 24pt.The following is an example −p {    letter-spacing: 4em; }The % unit defines a measurement as a percentage relative to another value, typically an enclosing element.p {    font-size: 14pt;    line-height: 80%; }

Read More

No error while inserting record in child table with no match in master table in SAP

SAP Expert
SAP Expert
Updated on 12-Jun-2020 350 Views

Note that when you perform an insertion using an ABAP program, there is no check on foreign key constraint.  Even when you define checks in data dictionary SE11 still there is no check at database level.When you execute using an ABAP code, this checks consistency at application level and not at database level. Errors you see in SE16 shows record rejected at application level.You need to perform validation by checking record from master table with foreign key of child table and incase sy-subrc is not initial then record shouldn’t be inserted to the child table and shows an error message.

Read More

Sorting Prompt values in SAP BO Webi report

SAP Expert
SAP Expert
Updated on 12-Jun-2020 647 Views

In Business Objects 4.1, this can be done by following below steps in Universe:Navigate to Parameters and LOVNext is to go Edit SQL option -> write query with order by to get the order.

Read More

Attach data from SAP system using Oracle Web Logic and Oracle Enterprise Service Bus

SAP Expert
SAP Expert
Updated on 12-Jun-2020 256 Views

As per my knowledge, Oracle Bus Service has a SAP adapter that you can use to get data via queries. With 10.3.1 release of the Oracle Service Bus, you have the following adapters for use within Oracle Service Bus:Oracle AQDatabaseOracle ApplicationsSAPJ.D. Ewards OneWorldSiebelPeopleSoftYou can refer to this link to know more about Oracle Service Bus (OSB):Oracle Service BusYou can use API available with Weblogic and ESB for configuration and for creating end points. To see the list of API’s available for Oracle ESB, refer this link:API's for Oracle ESB

Read More

Upgrading SAP .NET Connector from .NET 2.0 to .NET 3.0

SAP Expert
SAP Expert
Updated on 12-Jun-2020 580 Views

You are correct. NET Connector 2.0 uses proxy classes however .NET Connector 3.0 uses generic API. You need to rewrite all code that include NCo interaction..NET Connector 3.0 has many benefits over .NET 2.0:NCo 3.0 Is more stable, robust and supports heavy load.NET 3.0 provides better design of your application by decoupling the connection handling.It consumes less memoryAllows dynamic programming without the need for proxy generationCan dynamically look up metadata (so if something changes in the related ABAP system – e.g. if parameters in a function module signatures are added or the ABAP system is switched from Non-Unicode to Unicode, ...

Read More

How to find a constant in a string in SAP BO Webi Report

SAP Expert
SAP Expert
Updated on 12-Jun-2020 3K+ Views

You are correct. You can use functions like Match() or Pos(). You can use MATCH([Dimension];"*def*")) and this will get you the output and wildcard will match the beginning of the string.Pos Function is used to return the position of a specific character string.You can also try using Pos() function as below −=Pos("def abc ghi";"def") returns 1 =Pos("def abc ghi";"abc") returns 5 =Pos("def abc ghi";"xyz") returns 0

Read More

Publishing SAP Xcelsius dashboard without login

SAP Expert
SAP Expert
Updated on 12-Jun-2020 200 Views

Yes it can be achieved via using Open Document link. To get HTTP link, you need to store object in BO repository and get open document link from BI Launchpad.When you store object in repository, you have to handle necessary credentials and running queries can be handled by this. You can setup SSO in OpenDocument and SSO source can be an Active Directory authentication, or SAP BW.When SSO is setup, clicking the generated OpenDocument link should automatically log you on and open the dashboard and you don’t need to pass additional authentication.In short, you have to follow below steps:Set up ...

Read More

Is there a way to find last date of month using any function? Like 03/15/2017 should return 03/31/2017? (SAP)

SAP Expert
SAP Expert
Updated on 12-Jun-2020 174 Views

You can try using DateSerial() function.DateSerial returns a Date value for the specified year, month and day. It also handles relative Date expressions.Argumentsyear is a whole Number or numeric expression representing a year, example: 1996.month is a whole Number or numeric expression representing a month, example: 12 for December.day is a whole Number or numeric expression representing a day of the month, example: 5.ReturnsA Date value.ActionDateSerial returns a Date value for the specified year, month and day. It also handles relative Date expressions.DateSerial (2000, 6, 15)DateSerial (2004, 1 - 7, 15)DateSerial (2008, 1, 166)Check the below code as it finds ...

Read More

How to work with Bootstrap?

Chandu yadav
Chandu yadav
Updated on 12-Jun-2020 201 Views

To work with Bootstrap, the following are the steps − Download the latest version of Bootstrap from the official website.On reaching the page, click on DOWNLOAD for current version 4.1.1You have two options on clicking Download above,Download Bootstrap − Clicking this, you can download the precompiled and minified versions of Bootstrap CSS, JavaScript, and fonts. No documentation or original source code files are included.Download Source − Clicking this, you can get the latest Bootstrap LESS and JavaScript source code directly from GitHub.

Read More
Showing 50221–50230 of 61,248 articles
Advertisements