Sitemap

Amicuk Programming Answers

[39008] Logical dimension table ... has a source ... that does not join to

2015-10-11   Views:1

Advertisement

Oracle BI 11g Hi, I have this set of tables: 1) Table "Sales" with fields: ID, Billdate, ProductID, Amount 2) Table "Products" with fields: ID, ProductName, BrandID, TypeID 3) Table "Brands" with fields: ID, Name 4) Table &qu

Oracle BI 11g
Hi,
I have this set of tables:
1) Table "Sales" with fields: ID, Billdate, ProductID, Amount
2) Table "Products" with fields: ID, ProductName, BrandID, TypeID
3) Table "Brands" with fields: ID, Name
4) Table "ProductTypes": ID, Name
In Physical layer I add these tables and create Physical Diagram with constraints like this:
[Brands] -------------------->[Products]
[ProductTypes] ---------->[Products]
[Products] -----------------> [Sales]
In Logical Layer I create logical table T1 Products with sources:
- LTS1 Brands,
- LTS2 ProductTypes,
- LTS3 Products
and fields:
- ProductID
- ProductName
- Brand
- ProductType
After that I create Dimention With Level-Based Hierarchy (H1 Products):
Total Products
- Brands
-- ProductTypes
--- Detail Products
When I try "Check Global Consistency" I get warning: "[39008] Logical dimension table T1 Products has a source LTS1 Brends that does not join to any fact source."
And after that when I try to make Analysis in Oracle BI, for example:
H1 Products | Amount
and then drill down item "Total Products" I receive error:
"State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14025] No fact table exists at the requested level of detail: [,Brand,,,,,,,,,]. (HY000)"
What's wrong? Where do I mistake? And why I don't get any messages about Logical Table Source LTS2 Product Type?

The replay answer
Advertisement
Hi,
you can create a single LTS for the product with the join for all 3 tables. Do you have a particular reason for the modelling that you have used?
Regards,
Gianluca

Go to See the other 4 answers

[39008] Logical dimension table has a source that does not join to any fact

Category:DefaultRelease time:2015-10-11Views:130

Dear reader, After deleting a fact table from my physical layer and deleting it from my business model I'm getting an error: [39008] Logical dimension table TABLE X has a source TABLE X that does not join to any fact source. I do have an other fact t[More]

[39008] Logical dimension table has a source  that does not join to any fac

Category:DefaultRelease time:2015-10-11Views:130

Hi I have a problem in BMM layer: *[*39008] Logical dimension table X has a source Y that does not join to any fact source.* To start with I have three tables joining to Cust (customer) table in physical layer Cust-Seg (Segments)---------------------[More]

Consistency Warning: [39008] Logical dimension table ... has a source ...

Category:DefaultRelease time:2015-10-11Views:130

Hi and many thinks for reading, I have a problem (which is quite common as I saw, though I could'nt find a solution which resolves my issue yet) with the consistency. My physical layer looks like this: Table_A Table_B Table_C Table_D Table_E In the B[More]

[39008] Logical dimension table ... has a source ... that does not join to

Category:DefaultRelease time:2015-10-11Views:130

Oracle BI 11g Hi, I have this set of tables: 1) Table "Sales" with fields: ID, Billdate, ProductID, Amount 2) Table "Products" with fields: ID, ProductName, BrandID, TypeID 3) Table "Brands" with fields: ID, Name 4) Table &qu[More]

[39008] Logical dimension table X has a source that does not join to any...

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, I have warning: "[39008] Logical dimension table X has a source that does not join to any fact source" WHERE X: PROMOTIONS,PRODUCTS, CUSTOMERS, CHANNELS but all logical table are mapped to fact. Eveb I can create reports for them (The[More]

WARNINGS: [39008] Logical dimension table D1_CALENDAR2 has a source D1_CA

Category:DefaultRelease time:-0001-11-30Views:130

WARNINGS: [39008] Logical dimension table D1_CALENDAR2 has a source D1_CALENDAR2 that does not join to any fact source even though it is joined to a fact , can any one tell me the reason y im gettin this warning? Thanks in Advane.Looks like you have[More]

[39008] Logical dimension table X has a source

Category:DefaultRelease time:-0001-11-30Views:130

Hi I have a Fact table with some dimensions. If I add a detail table to that Fact table I get: [39008] Logical dimension table X has a source Y that does not join to any fact source. For each dimension that I had. Is this possible to model?. To have[More]

Warning [39008] : Logical dimension table...

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, in OBIEE we have a fact table linked in Physical Layer to 20 dimensions. I've created hierarchies for 15 dimensions but when I check consistency I receive the warning BUSINESS MODEL <bmname>: +[39008] Logical dimension table <tname> ha[More]

Please help me out with this error:Logical dimension table D_TARGET has a source D_TARGET that does not join to any fact source.

Category:DefaultRelease time:2015-10-11Views:130

I get the folowing error when I run the global consistency check WARNINGS: Business Model DAC_Measures: [39008] Logical dimension table D_TARGET has a source D_TARGET that does not join to any fact source. Can someone help me out please? Thank you!It[More]

Logical dimension table

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am creating logical columns using two logical dimensions in a separate logical table. Do I need create complex joins for the new logical table, two source logical dimension tables have complex joins created already. Could you anyone provide[More]

Creating logical dimension table using common attributes of Facts

Category:DefaultRelease time:2015-10-11Views:130

I need to create a common logical dimension based on an attribute present in both the fact tables. Example - Expense fact has 3 columns expense_key, expense_amount and customer_name Revenue fact has 3 columns revenue_key, revenue_amount and customer_[More]

Hot
Hi im trying to save a file on safari that is from a uni intranet(lecture notes) so that i can view it in word or powerpoint inorder to adjust the text and pic sizes so that when printed they are easier to view. The problem i have is that the saved f [More]
Greetings.  I'm following the steps in the following link from Adobe: http://help.adobe.com/en_US/Lightroom/3.0/Using/WSE828B644-9097-46ab-98A7-E2719BBB6647.htm l The final step, after selecting the folder I want to add, is to select Import.  Except, [More]
Hello everybody, I've an Asus M2N68-AM Plus Motherboard in a HTPC with all SATA connectors occupied. What can you guys come up with as the cheapest way to add more extra storage space [via SATA]? 1. Change Mobo? 2. Switch HD's? 3. Any controller boar [More]
The table has X-values (date format) in column A and Y-values (number format) in column B. The (linear) chart displays not more than 135 XY values. The first date is 04/28/2008, the last date is 03/06.2014. I am unable to get additional data on the c [More]
While trying to install the SAP netweaver sneak preview I got this error at the second step of the installation “SAP System installation”….. "An error occured while processing service sneak preview edition of SAP web application server java 6.4  inst [More]
I Need to find out what date I downloaded an app? Is it possible to find this out? THank ink you for your helpYou can on a Mac or PC. See here: See your purchase history in the iTunes Store - Apple SupportRead other 2 answers [More]
I have a Officejet Pro 8500 printer that has freaked out and I can no longer read the digital messages therefore now I can't follow the instructions for the faxing, scanning, etc.  The tech support was unable to help reset and suggested to buy a new [More]
Forgive me if I have posted in the wrong community, however this is my first post. My iphone 4 (iOS 6.0.1) has recently (over the past three days) started sporadically assigning a xx/xx/00 date to emails rather than xx/xx/12. When I open the email th [More]
Going on 6 days now with any call I receive that goes to Voicemail. It shows up as "UNKNOWN" when viewed in Visual Voicemail. I'm certain these are not "Blocked" calls/callers - most part are in my address book as long established cont [More]
I've converted for AppleTV many times in the past with no problem but I'm experiencing a big problem now. 1. When exporting a full quality QT (self-contained) file from Final Cut Pro and then encoding for AppleTV from that QT file, the result is an A [More]