Sitemap

Amicuk Programming Answers

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

2015-10-11   Views:4

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
Dear All, How to display the sort value in the selection screen in the report title? I have selected a value in the selection screen for sorting , but i need that values by which i have sorted with in the report title. Can you please throw some light [More]
I constantly loss my music!!!!!!!!!!!!!  I constantly loss my music!!!!!!!!!!!!!!!! I need help to stop this!!!!!!!!!!!!!!!!!First of all, is the music only disappearing from your iPod, or from your iTunes Library as well? From your other thread, I g [More]
How can I create an alias of the Home Folder (User Folder) to put on the desktop? I've done it in the past, but I'm not able to do it now, nor am I remembering how I did it. When I highlight the Home Folder in the User's folder and try to make the al [More]
Hey, I have a cannon hd camera that films in 1920x1080 which is a 16:9 aspect ratio if I understand correctly. I'm trying to export this video size to a 640x480 using the quicktime conversion. From what I've read online and in the manual if I check " [More]
Four instances total, and in each instance iTunes directed me to an updated TOS agreement. I checked the agreement, then navigated back to the store only to find being twiced charged for the same download. Windows Vista, iTunes 8.1.1.10, fresh instal [More]
I can get the list of items in a folder but it always is organized alphabetically by name even if the folder is in list form and sorted by date. Is there any easy way to get the list of items sorted by date (or some other property)? Of course, I can [More]
I don't see how this problem is solved. I too am trying to input a graphic into a signature with no end-user joy. Whilst it works fine with Mail, my clients mainly use Lotus Notes/Domino. I too have Notes 6.5 for Mac. The graphic does not display in [More]
I am running SyncToy 2.1, version 2.1.0.0. When synchronizing folders that contain Outlook messages saves as *.msg files, I recieve the message "Error: Cannot write to the destination file. The filename, directory name, or volume label syntax is inco [More]
Hey guys, I've recently begun experiencing BSODs with the above explanation, and I cannot spot a reason for it.I have uploaded the Minidump files from the BSODS here:- http://1drv.ms/1i2A9Df as I unfortunately have no knowledge of examining BSOD dump [More]
Hi, Please help me out. What is wrong? I work on a Mac OS X 10.9.5 After the update when saving a html or dwt page in Dreamweaver 2014 CC Dreamweaver stucks. It just keeps on waiting. I already have reinstalled the software, restarted my Mac twice an [More]