Best workaround for querying across multiple Data Sets?!

10-11  Source: Network gathering  Views:1 

Advertisement
Hi folks
Today I was migrating my older OEID 3.0 applications to 3.1, and I noticed some of my older version views are not working anymore in new version.
We used to have multiple Bulk Add/Replace (without specifying Collection Keys) and we could use any attributes from any of these, in a certain View for example.
My views were like SELECT SUM("an attribute/metric from Bulk Add_1") / SUM("an attribute/metric from Bulk Add_2")
Now that you have to specify a FROM clause in your views, and it has to be from a certain Data Set, whats the best way to achieve above line goal?
Bests,
Patrick
What I meant by Cross Join is Cartesian Product in situation that you have many-to-many relations between 2 Data Sets
Lets say, I have to different data, coming from 2 totally different source, one from Sales Dept and the other one from Purchase Dept:
Sales Table:
Part Number
Sales QTY
Sales Date
Part Type
Manufacturer
Country
0001
70
10/5/2012
TYPE1
Manuf1
US
0001
120
10/6/2012
TYPE1
Manuf1
US
0001
350
10/7/2012
TYPE1
Manuf1
US
0002
100
10/8/2012
TYPE2
Manuf2
US
0002
80
10/9/2012
TYPE2
Manuf2
CA
0003
2500
10/10/2012
TYPE3
Manuf3
CA
0004
180
10/11/2012
TYPE4
Manuf4
US
Purchase Table:
Part Number
Purchase QTY
Purchase Date
Part Type
Manufacturer
Country
0001
50
10/5/2012
TYPE1
Manuf1
US
0001
60
10/6/2012
TYPE1
Manuf1
US
0001
100
10/7/2012
TYPE1
Manuf1
US
0001
200
10/8/2012
TYPE1
Manuf1
US
0002
1100
10/9/2012
TYPE2
Manuf2
US
0003
20
10/10/2012
TYPE3
Manuf3
US
What is the preferred approach to ingest this data?
Related articles
  • Best workaround for querying across multiple Data Sets?! 10-11

    Hi folks Today I was migrating my older OEID 3.0 applications to 3.1, and I noticed some of my older version views are not working anymore in new version. We used to have multiple Bulk Add/Replace (without specifying Collection Keys) and we could use

  • Matching across multiple character sets 10-11

    Would like to know whether anyone has attempted matching across multiple character sets, for example, between English and Japanese: what are the pitfalls to avoid, what are the best practices, and what you would like to see from application/tools per

  • Best practice for Plan and actual data 10-11

    Hello, what is the best practice for Plan and actual data?  should they both be in the same app or different? Thanks.Hi Zack, It will be easier for you to maintain the data in a single application. Every application needs to have the category dimensi

  • Joining multiple tables across multiple data sources in MYSQL throws error 11-30

    Hi all, I have to join tables across multiples MYSQL databases eg : Table T1,T2 from DB1 Table T3 from DB2 Columns from T3 are aggregated ( dimensional column ). Hence when i query using oracle answers ( say i have columns from T1,T2 and T3 ) , OBIEE

  • Question: Best practices for dealing with multiple AM configurations 11-30

    Hello all, I have a project using ADF Business Components and ADF Faces. I would like to set up multiple configurations for the Application Modules to support the following scenarios: 1). Local testing and debugging - using a connection defined in JD

  • Multiple data sets: a common global dataset and per/report data sets 10-11

    Is there a way to have a common dataset included in an actual report data set? Case: For one project I have about 70 different letters, each letter being a report in Bi Publisher, each one of them having its own dataset(s). However all of these lette

  • Best practice for including additional DLLs/data files with plug-in 10-11

    Hi, Let's say I'm writing a plug-in which calls code in additional DLLs, and I want to ship these DLLs as part of the plug-in.  I'd like to know what is considered "best practice" in terms of whether this is ok  (assuming of course that the un-i

  • Query from multiple data blocks 11-30

    Hello professionals, I having difficulty in finding solutions to query data from multiple data blocks. By the way I'm using Oracle Forms 10g I have 4 data blocks and all items are database items Below are the blocks, 1. student_main (columns : studen

  • Best Practices for Accessing the Configuration data Modelled as XML File in 11-30

    Hi, I refer the couple of blof posts/Forum threads on How to model and access the Configuration data as XML inside OSB. One of the easiest and way is to Re: OSB: What is best practice for reading configuration information Another could be Uploading X

  • Time utility shell dimension across multiple date dimensions 11-30

    Hello, I have built a time utility shell dimension based on a solution from Tomislav Piasevoli (book: MDX with SSAS 2012 cookbook) however I have modified it slightly In his example he uses two hierarchies from the same dimension. However I have modi

  • Backend Operation for OK button of Data Set tab of Data Definition 11-30

    Hello everyone, Please let me know what happens at backend when we click on OK button Data Set tab of Data Definition in Unifier ! Cheers, GaganTo only select the first 100 records is rather easy.  Use the addition on your select statement "UP TO X R

  • Summarizing Data Across Multiple Dates 11-30

    Here is my issues. I have two dimensions. Date and Time. Date is a standard date dimension. Time is a time dimension who's leaf level is at the second. I need the ability to obtain a value like maximum from my fact table for a given set of prices. I

  • What is the best way for a parent to share/set up an apple id for their children's iPhone if they have an Iphone too? 10-11

    So I work for a wireless provider and i often have customers who buy their children iphones. They end up sharing Apple ID's amongst themselves. After they have done this- what is the easiest way to get the content being shared (contacts, pictures, mu

  • In the Begining it's Flat Files - Best Practice for Getting Flat File Data 10-11

    I probably should have posed this question here before I delved into writing Java to get data for reports, but better late than never. Our ERP is written in COBOL. We have a third party ODBC which allows us to access data using a version of SQL. I ha

  • Searching for links across multiple pdf files 10-11

    We have thousands of pdf files that are being moved to a new website. Some of these pdf files have links within them (either as text or as a hyperlink). This number is unknown. The issue is how to programmatically search across multiple pdf files (nu

  • Need Solution/Workaround for Note 947081: SG dates in MMDDYYYY 11-30

    We are implementing ESS for Singapore. Dates are being shown in MMDDYYYY format - we need DD.MM.YYYY, which is the Singapore standard. Our large user base all have language EN, country SG. With reference to Note 947081, dated 07.09.2006, I'd like to

  • Best workaround for editing long AVCHD clips in CS6? 11-30

    Hi there, I've recently switched to CS6 and have run into incredibly long render times using native AVCHD clips (13 hours to encode a 30 minute m2v).  After reading many posts it seems the issue I am running into is a known bug.  So, my question is:

  • Best Practices for converting SAP HR data (4.7 to ECC) 11-30

    Hello Experts ... We are going from 4.6 to ECC ... no upgrade ..it will be a new implementation ... I am looking for best practices to convert SAP HR data from one sap instance(4.6) to another(ECC) ... I am not sure if direct input or LSMW or any oth

  • Best practice for phone number column data type 10-11

    Hi, I hope I have posted this in the right forum, if not just notify me and i will remove it to the correct area. What would be considered best practice for storing a phone number. Number of Varchar2. BenWell I was thinking that Number would have the

  • Best practice for how to access a set of wsdl and xsd files 10-11

    I've recently beeing poking around with the Oracle ESB, which requires a bunch of wsdl and xsd files from HOME/bpel/system/xmllib. What is the best practice for including these files in a BPEL project? It seems like a bad idea to copy all these files