Question on Logical table Sources

10-11  Source: Network gathering  Views:6 

Advertisement
Good day!
I would like to ask for your advice on an bottleneck I am experiencing in a repository implementation in Siebel/OBIEE.
I am to create a logical table which sources comes from two different tables(Physical table A and Physical table B).
I am trying to union the contents from table A and table B so I planned to use fragmentation content.
My problem is that there is no way to distinguish the difference between the records coming from physical table A and table B.
I created two logical tables sources and specified the same condition for both but the server would automatically choose the first one and would not include the records from the second logical table source.
Is there any other way I could combine the records from table A and table B in Business Model and Mapping layer?
Please, I would like to know your thoughts.
Thanks,
Ivan
Hi Ivan,
I dont think there is other way which is equable to fragmentation content functionality.
I would suggest to try with any column is not null or most satisfied condition so that both contents present in the query.
If helps pls mark
Related articles
  • Question on Logical table Sources 10-11

    Good day! I would like to ask for your advice on an bottleneck I am experiencing in a repository implementation in Siebel/OBIEE. I am to create a logical table which sources comes from two different tables(Physical table A and Physical table B). I am

  • Question related to Logical table source 10-11

    Hi All, I have very basic questions - (1) When do we create multiple logical table sources within a dimension? (2) If a dimension has more than one logical table sources , when do we need to map the underlying table to other underlying table of logic

  • Problem: 1 physical table -- multiple logical table sources 10-11

    Hi, I'm quite new to BIEE and setting up my repository. So I have a question, if the following scenario is possible: Physical Layer: TABLE_A: COL_A, COL_B, COL_C TABLE_B: COL_D, COL_E, COL_F Join TABLE_A.COL_A = TABLE_B.COL_D In Business Model I have

  • Multiple Logical Table Sources In BMM Under 1 Logical Table In OBIEE 11g 10-11

    I have a question and even after doing a lot of search on google i could not find any article so through to ask you :- I want to create a Logical Dimension table This logical dimension has columns coming from 2 different physical tables, TableA and T

  • How to "think" use of multiple logical table sources 10-11

    Hi everybody, i'm new to OBIEE and its paradigm. I'm trying to build a prototype with multiple physical sources: ERD and a Data Mart; I need OBIEE to go to the Data Mart model at the need of aggregated info and to go to the relational model at the ne

  • Repos - logical table source does not contain mapping 11-30

    Hi, I have a repository question? I do not have a fact table in my physical layer. Do I have to have one? I thought the fact table got created in the BM. I do have a date table in the physical layer, but it isn't joined to any other table. I added th

  • Logical table source 11-30

    Hello! Can someone please explain difference between dragging and dropping a physical column from a table in Physical Layer to a Logical Table in BMM layer and ragging and dropping a physical column from a table in Physical Layer to a Logical Table S

  • Business Model - Logical Table Source 11-30

    Can someone give me clarification on exactly when you would follow scenario 1 when modelling a logical table and exactly when you would follow scenario 2, and what the key difference in behaviour between the two is. It would help if someone could ill

  • How would multi Logical Table Source work? 11-30

    Hi All, I am facing a problem about multi Logical Table Source. Can I build a Business Model with a Logical Fact Table that have two Sources? Taking the below description as an example: Table Name Columns Description Fact TIMECD(2013Q101, which join

  • Logical Table source source query 10-11

    In OBIEE 10g we can have multiple logical table sources and we can also add multiple tables into a single logical table source(logical table source source). I wanted to know the difference between doing so and having multiple logical table sources fo

  • Filter on the same logical table source on two logical tables is not working properly 10-11

    Hi, In the RPD, assume that I have a physical table named Employee_fact, created an Alias called D0 Employee Fact In the BMM I've two logical tables called Employee_fact_Type1 and Employee_fact_Type2 Each of these logical tables has the same Logical

  • Dynamically change the Priority Group of Logical Table Sources in OBIEE 11g 10-11

    Hi All, I have 2 Logical Table Sources(LTS 1 and LTS 2 for a Logical Table in BMM Layer). Example: Logical Table : Sample LTS Source 1 : Sample 1(Priority Group Set to 1) LTS Source 2 : Sample 2(Priority Group Set to 0) I have set the Priority Group

  • Max number of logical table sources 10-11

    Hi, I have one logical table based (a fact table) on 8 logical table sources. This is done to simulate some partitioning as my customer does not have an partition set up on data base level. Anyway my challenge is that a request fired in answers does

  • Multiple Logical Table Sources vs Single Logical Table Source 10-11

    OBIEE 11g. I am totally confused. Can someone help me with the following for me. I have seen logical table sources being used in 2 ways. I have a 2 sources tables: CUSTOMER & ADDRESS. In physical layer these 2 tables are linked by CUSTOMER _ID in a 1

  • Time series functions are not working for fragmented logical table sources? 10-11

    If i remove that fragmented logical table sources, then its working fine. if any body know the reason, please let me know. thanks and regards, krishnaHi, is because the time series function are not supported for the framentation content, see the cont

  • Logical table having more than one Logical table sources 10-11

    Hi , Is it possible a logical table has 2 logical table sources and there is no join between the underlying table of logical table sources? What will happen if we create the request which contains one attribute from each source? Will BI server return

  • No Fact table Exists and [nQSError: 14070] Cannot find logical table source 10-11

    Hi, I have 3 tables A(fact),B(dim) and C(dim). there are some other dims. i am getting Errors here. A is joined with B and B is joined with C . 1) In report if i pull columns from A and B its giving data. If i include C table Columns in the report i

  • Union of more than 2 fragments/Logical Table Sources in BMM Layer 10-11

    Hi, I have come across many blogs which explain how to union two fragments/physical tables in a logical table source. Currently, i have a requirement where i have to combine/union 4 fragments/physical tables in a logical table source, say T1, T2, T3,

  • Confused about logical table source 10-11

    Hi, I'm confused about logical table source(LTS), there are 'General', 'Column Mapping', 'Content' tabs in LTS, in General tab ,there are some information,like 'Map to there tables' and 'joins', just here, we have created relationships in physical la

  • Invalid data from serveral fact logical table sources after upgrade to 11g 10-11

    Hi, We have a situation after upgrade from 10g to 11g. Answers' querys works fine in 10g environment, but in 11g, generated SQL is not correct. Our example is something like that: we have orders fact table, customers and time dimensions. Customer hav