Finding data in a datasource/ Business Content Query
Hello, can you help me with this one -- background to this problem is shown below: Question: 1. No data was found in my infocube so I went o R3 to see if the datasource had any data in it by running rsa3 but found no datasource 2LIS_02_S012, although rsa5 shows that it exists. What could be happening? 2. Also, how do I see the queries which come with the InfoCube? When I go into BEx, I see the dimensions to create my own queries, but where are the ones which comes with the Business content for me to use? Background to Questions---- I was experimenting with an MM InfoCube 0PUR_C01, and my research indicated that the datasource which supplies this this infocube with data is 2LIS_02_S012. The notes on this datasource indicates it could be extracted as a standard extraction or LO. I did standard, rsa5, rsa6, etc...replicated in BW, etc. I later created and InfoCube zpur_c01 and copied from 0pur_co1, etc. ...then later created and infopackage and loaded data into the InfoCube for the purposes of reporting.
To answer your first question.
- The datasource 2lis_02_s012 that you have seen in rsa5 is in the delivered version you need to transfer this into the active version. Select the datasource in rsa5 and click the transfer datasource button. After you have done this you will see the datasource in rsa6.
Also since this datasource is a Logistics Info Structure the LIS reporting should have been activated and in use.
For your second question
- If you have already identified a standard business content query that you want to use through the metadata repository, you can activate the report through the business content tab in rsa1.
Hope this helps.
Dear Friends, We are in BI 7.0 and trying to install a business content query "Balance Sheets Profit and Loss Statement" but while activating we are getting the error that some Particular Request has not been found or not suitable. we checked fo
Hi, we have activated the business content for General Ledger (New). We have successfully executed all data loads. but, the standard query 0FIGL_V10_Q0001 which is activated, is not executing properly. It throws up a message "Value '0' is invalid for
hi pls explain how to find the standard queries in a business content assign full pointsHi, Incase you want to know details about the standard queries, then the best source would be the help documenations on BI content: http://help.sap.com/saphelp_nw
Hi All, I am trying to install few queries in business cube 0pur_c01, which is already in production and already lot many queries are running. As per requirement i have to install New quries in the 0Pur_C01 0PUR_C01_Q0012 : Ordering Activities 0PUR_
Hello Exerts, Can anyone advice me finding the underlying tables of business Content data sources? Regards.Hi, I dont think that there is any standard tcode or table to find out the underlying base tables. But you can try the below mehtod to to find
We are going live this month but user just raised a query. They want to do the analysis based on reservation and good issue (against reservation)items too. Pls advise, where we can find reservation information in MM Business content? AlokYes, I am ta
Hi, As we have technical documentation for SAP BI business content BI reports on SAP HELP Portal, is there any link where we can find the technical documentation for business content reports supported by SAP BOBJ Rapid marts for R/3 solution like for
Hi all, my case is this: i want to learn how to get or struct a model in BW, for example, my task is make a query where the client wanna get information , and he told me the fields, ok, in R3 i got the name of the field (NODISCONCT), the struct (EANL
Hello BW Gurus, Please let me know step-by-step (Detailed) procedure on how to enhance the Business Content Data source Actual Time and Labor Times <b>0HR_PT_2</b> http://help.sap.com/saphelp_nw04/helpdata/en/4b/26c5394dbfef35e10000000a11402
Hi Experts I am extracting data using 0CO_OM_CCA_9 Datasource. I would like to be able to select a range of Company Code (BUKRS) to pull in, but I cannot find a way to make certain fields available as selection criteria. When I go into "Change DataSo
Dear experts, for SRM bidding engine i have activated the extractors in SRM through transaction RSA5 and put them on a transport. Replicated them in BW and their they are appearing correctly, activated them and provided infopackages. Now when i want
Hello, we have recently upgraded our business content from 3.10 to 3.30 in order to get new business content (e.g. datasource 2LIS_13_VDKON - billing item pricing conditions). Although the upgrade was successful, the new datasources cannot be found i
Hi When I review the Business Content component on the left hand side for the objected type InfoObject 0HIER_NODE, it is activated. But when I try to find it from the InfoObject component on the left hand side or RSD1, it is saying that the 0HIER_NOD
Hi, I am not clear about the Data Sources and Business Content sync. If I transfer the datasources in SBIW(RSA5) and replicate in BW, how it will automatically bind to the infosources and data targets when we activate the relevant infoobjects in BW
Hi all, Any idea about standard business content data source which contains the BOM - bill of materials data..... Best Regards, NavinHi Navin, Check these links: Re: Extract BOM data from R/3 to BW Re: Loading Bill of Material Bye DineshRead other 2
How can we add a custom meta data filed which lists out content id based on query like dDocType <matches> `AssociatedProduct`? Or other alternative would be to have a custom metadata field such that it allows selection of content id using link wizar
I am working with datasource 2lis_04_p_arbpl to construct Yield Report. I have a field GAMNG(Target Quantity) in the table AFKO, so I added it to the communication structure and activated it. I also want the field IGMNG(confirmed quantity) which is a
Hi Experts...... Good evening!!!.. I do have one requirement for which im not getting any business content ds. Could you pl help me out in that ? My requirement is like below. Report is extracting SAP CRM contracts data: u2022 This report lists t