
	Home > SAP software/management Tips > SAP business intelligence tips > Adding special characters in SAP BI

SAP Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

SAP BUSINESS INTELLIGENCE TIPS

Adding special characters in SAP BI

Aaron Wang
09.14.2007
Rating: -4.27- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

In most situations, an extraction in BI fails due to an invalid value for the InfoObject. For example, I failed to load 0MATERIAL_ATTR because some of the material number is like "[2Q235-A100060D" (note the '[' character) while '[' is an invalid character for BI by default.

Check OSS note #173241 – “Allowed characters in the BW System&rdquo to review (same as the picture below)

[IMAGE]

If you can't change the material number, we quite simply have to include whatever is causing problems as a permitted character in BI.

Step1:
Run TCODE RSKC
Input '[' and execute the program. This will add '[' to the allowed characters list.

[IMAGE]

Many documents has mentioned parameter 'ALL_CAPITAL'. It is powerful but also a little bit dangerous I think. So here I added only the must-have one.

After this, the extraction should work properly.

Step2:
Since I was loading 0MATERIAL, you can figure that this is a brand new BI system. So if you've been running for some time, step 1 is not enough. Now we encountered another error:

If we open the cube which has 0MATERIAL to check the cube content (or open InfoObject 0MATERIAL) the following error message occured:

[IMAGE]

Run TCODE OMSL (or SPR...

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SAP business intelligence tips
	Choosing an SAP BI/BW database for InfoCube data
	Using Infoset to join, move DSO analysis to InfoCube
	Selecting InfoCubes in SAP BI/BW Business Content
	How to limit employee access to reports using roles in SAP NetWeaver
	SAP BI extractors vs. Business Objects for ETL process
	Adding custom fields for retail product comparisons in SAP BW
	Top 10 SAP tips of 2007
	Retrieve BI data with Web Services
	Currency translation using SAP BI
	How to acquire the runtime information of a data transfer process (DTP)

Business Objects and SAP business intelligence

SAP CTO Sikka: SAP's innovation gets overlooked

Four things SAP must consider before a Teradata acquisition

SAP TechEd Demo Jam 2009: Winners use beer keg in demo

Which five SAP projects should businesses launch now?

SAP BW or third-party data warehouses a dilemma for SAP customers

SAP pitches in-memory DBMS to handle transactions as well as analytics

Tips for setting up a default SAP BI client after implementation

Competitive sailors use SAP dashboard, BI to plot better race strategy

Consider more than end of support in move from SAP BEx to BOBJ

SAP Business Explorer (BEx) and SAP BI reporting basics

SAP business information warehouse

Four things SAP must consider before a Teradata acquisition

SAP BW or third-party data warehouses a dilemma for SAP customers

Should we install SAP BW on the same server running SAP R/3 4.7?

SAP: Don't rush from SAP BEx tools to SAP BusinessObjects

SAP shores up SAP NetWeaver BW with Teradata

Choosing an SAP BI/BW database for InfoCube data

Using Infoset to join, move DSO analysis to InfoCube

Selecting InfoCubes in SAP BI/BW Business Content

SAP BI roadmap one year later: How's Business Objects working out for SAP BI customers?

How to limit employee access to reports using roles in SAP NetWeaver

SAP business information warehouse Research

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

BEx (SearchSAP.com)

Business Information Warehouse (SearchSAP.com)

Enterprise Services Architecture (SearchSAP.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

O > IMG button > BW > General settings > Set Material Number Display) both in R/3 and BI, because we need to ensure the settings in BI is the same to that in R/3.

[IMAGE]

Hope the above could help you out on the invalid character issue.

Aaron Wang is a SAP/BI Consultant for IDS Scheer China

This content is reposted from the SAP Developer Network.
Copyright 2007, SAP Developer Network

SAP Developer Network (SDN) is an active online community where ABAP, Java, .NET, and other cutting-edge technologies converge to form a resource and collaboration channel for SAP developers, consultants, integrators, and business analysts. SDN hosts a technical library, expert blogs, exclusive downloads and code samples, an extensive eLearning catalog, and active, moderated discussion forums. SDN membership is free.

Want to read more from this author? Click here to read Aaron Wang's Weblog. Click here to read more about Business Intelligence on the SDN.

Rate this Tip
To rate tips, you must be a member of SearchSAP.com. Register now to start rating these tips. Log in if you are already a member.

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

NetWeaver SAP White Papers

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2000 - 2009, TechTarget \| Read our Privacy Policy SearchSAP.com is a search service provided by TechTarget and is completely independent of and not affiliated with SAP AG.