Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Look up table error

User294199
Rank 3 - Community Apprentice
Hi,
following manuals on the web, i created a lookup table for data translantion purpose. I created a new logical column with formula LOOKUP(DENSE....) and no errors was generated.
But when i try to create an analysis with the new logical column and my fact table i receive error "nqserror 14025: No fact table exists at the requested level of detail"
But lookup table haven't need to be joined physically and logically with other dimension. It's right. So how i can resolve the problem? Is it necessary to create a hierarchy on lookup table?
Thanks
0
Answers
-
Can someon eplease answer this question, I have same issue.
0 -
Does your lookup table have keys defined and are you looking up based on all the keys?
0