Home > Default > Query on transactional ODS

Query on transactional ODS

October 11Hits:1
Advertisement
Hi All,
I want to write a query on a multiprovider built on two transactional oDS.
The first transactional ODS will have :
1. Material
2. Avg rating
The secong transactional ODS will have:
1. Material
2. Vendor
3. Avg rating
Now, I want to build a MP on these two ODS' where the report should have:
1. Material
2. Vendor
3. Rating
4. Rating as a % of Avg rating
How can I do it?

Answers

Hi Ravi,
I made a mistake in the specification.
The first transactional ODS has:
1. material
2. Average rate
The second ODS acyually has:
1. material
2. vendor
3. rate
Finally what I want to calculate on the MP is:
vendor, material, rate and rate as % of average rate
Please suggest.
Regards,
Sharmishtha

Read other 9 answers

Tags:

Related Articles

  • Query on transactional ODSOctober 11

    Hi All, I want to write a query on a multiprovider built on two transactional oDS. The first transactional ODS will have : 1. Material 2. Avg rating The secong transactional ODS will have: 1. Material 2. Vendor 3. Avg rating Now, I want to build a MP

  • APD Query populating Transactional ODSNovember 30

    Hi ,    1) How do we find out if a Transactional ODS is populated by an APD Query. Where will this information be mentioned?    2) If we dont know the name of the APD Query, but we know the transactional ODS, can we find out the APD query name.    3)

  • How to see data in a transaction ODSOctober 11

    Hi all, I am populating data into my Transactional ODS through the function module RSDRI_ODSO_INSERT_RFC . But not able to see the data in it. as there is no manage option to the ODS. and by default an export datasource is created for the ODS. do i h

  • Report on standard ODS object  and transactional ODS objectOctober 11

    hi gurus i have an infoset which is built on two transactional ODS objects and one standard ODS object which gets the data on regulr schedule. the transactional ODS obejcts get the user entered data. when i query on the infoset, i am getting the data

  • Why cant we Report on transactional ODS directly?November 30

    Hi Pioneers could any one let me know the reason why we cant report on Transactional ODS directly?Why should we create an infoset for that purpose.Whats the reason? BR RaviHI Ravi You cannot set the indicator for BEx Reporting when creating a transac

  • Info Set on Transactional ODSNovember 30

    Hi Friends, My Requiement is to create a Info Set on Tannsactional ODS and On this info set i have to create a Bex Query. If i creata a Query on this info set whether we can get  all the query properties like currency conversion etc as for the query

  • INSERT query or Transact-queryOctober 11

    Hi folks, need some guidance here, do I use INSERT query or Transact-query to create a Customer order. I have 4 tables, details below; I would like to save this query as a Stored Procedure as the front end will be asp webpage. If possible could you p

  • Transform sap query into transactionNovember 30

    hi! my question is not related to mm but also not to other forums in this site. i'm trying to transform sap query into transaction using se93 transaction. i just learing sap in a class and we use an old version of sap. user group name: ofer6 infoset

  • Vendor evaluation Transactional ODSNovember 30

    Hi all, I need follwoing information with respect to supplier evaluation, pulling the data from SRM: 1) what is the differnce between the ODS 0SRVE_O4 and 0SRVE_O2? 2) what is the differnce betwwen the ODS 0SRVE_O3 and 0SRVE_O1? 3) How and when can w

  • How to Create Transactional ODS in BI 7.0November 30

    Hi Experts, What is Transactional ODS(3.5) in BI 7.0 ( when i am creatin DSO,i got 3 options Standard,direct,overwrite) which one i should select . Regards SidhuHi, Transactional ODS is now Direct update DSO in BI 7.0 and contains only active data ta

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.691 s.