Home > Ask the SAP software/management Experts > SAP BI/BW Questions & Answers > Using Infoset to join, move DSO analysis to InfoCube
Ask The SAP Expert: Questions & Answers
EMAIL THIS

Using Infoset to join, move DSO analysis to InfoCube

Jay Narayanan EXPERT RESPONSE FROM: Jay Narayanan

Pose a Question
Other SAP Categories
Meet all SAP Experts
Become an Expert for this site


SAP news, tips and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 09 April 2009
I have two tables, both of which are stored in a DataStore Object (DSO). I have a key ID, called policy ID, which is present in both tables. I used an Infoset to join the DSOs from both tables, hoping that this would perform a natural inner join, thus "adding" columns from one table to the other where the policy ID matches. I then want to send this joined table to an InfoCube.

The problem is that this action gives me various error messages such as "The parameter is not used" (for the currency keys needed in my InfoCube). Am I doing this correctly, or is there a better process?


>
If the requirement is to store the data in an InfoCube, then there is no need to create an Infoset. Data from the DSOs can be individually loaded into the InfoCube, and then you need to apply the ABAP routines to summarize this data based on the requirements. If the intention is to do reporting out of the Infoset, then you may create the Infoset, which will be a joining of the two DSOs.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
SAP BI/BW
SAP Software Deployment Manager vs. Java Support Package Manager
Should we install SAP BW on the same server running SAP R/3 4.7?
Choosing an SAP BI/BW database for InfoCube data
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
Migrating Business Content from SAP BW 3.5 to NetWeaver BI 7.0
How does SAP R/3 data differ from BW (NetWeaver BI) data?
What's the future of SAP BW and SAP BI careers?
How to choose between a career in SAP Basis vs. SAP BI

Business Objects and SAP business intelligence
On-premise vs. on-demand BI: SAP tries for the best of both worlds
SAP teams with Microsoft in enterprise performance management space
SAP talent management FAQ: Fresh answers to frequently asked questions
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

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
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 BI extractors vs. Business Objects for ETL process
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



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



SAP White Paper Topics
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
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.
  TechTarget - The IT Media ROI Experts