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
I working for a banking sector, My requirement is that, there is a screen which stays open 24 hours 365 days , there are some database changes happening in the backend , the data needs to get refreshed in the page without actually clicking any refesh [More]
I scanned a catalog for my archive - double sided pages of course. It was easy enough to scan the front pages first (odd numbers, 1-3-5) , in several sets of 30 pages, therefore several separate pdfs. Then I scanned the back side (even numbers 2-4-6) [More]
I just bought a new MBP, and since I used my education discount, I got a $100 gift card to use in the App Store/iTunes/etc. I have a bunch of songs I bought back when iTunes had DRM, so I was going to use this money to upgrade some of those purchases [More]
I have formatted my iMac and done a fresh install of lion without problems. Before i done this all my Music, films, etc were stored on a FireWire drive that again worked without problems. I cannot seem to get the new iTunes to import the new library [More]
Hi folks, need to delete from a 95 millions rows regular table, what should be my best options, have tried CTAS using parallel, but it failed after 1+ hrs ... it was due to bad query, but checking is there any other way to achieve this. Thanks in adv [More]
Hi ,        Is there transaction throuch which we can see the history of Moving Average price . ... Or any other way is there for the same can any body suggest me for the same .... Thanks in Advance Regards ShankarDear, Enter MR22 t-code. Click on Di [More]
Hi, I have been making a website entirely in flash CS4 AS3 and I decided to buy a contact sheet to add into it, when I added it in though it didn't work. I would click the button of the contact sheet and it didn't work. I contacted the creator if the [More]
I have the most recent updated version of Photoshop CC, using a MacBook running on 10.6.8, and the Perspective Warp function is not enabled. How do I fix this?I would guess you need to uninstall bridge cc and then reinstall without applying the 6.1 u [More]
How do I find out what ios the ipad has?Hi milopie, To find out what iOS you are running on the iPad, go to Settings>General>About. About half-way down, you will see a Version number. That is the iOS version. Cheers, GBRead other 2 answers [More]
I have one of these ancient laptops, and i cant find any support, or downloads for it from www.toshiba.com. I bought one of these 210ct's and it was formatted when i got it. I saw it when it still had os in it and it worked perfectly. Now when i boot [More]