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
RPD issue - missing LTS
Hi,
I will try to be as more specific as possible.
I have done changes in RPD and received error: Cannot find logical table source coverage for logical columns: [field]. Please check more detailed level keys are mapped correctly.
We have a table dim_person. Based on two columns from this table I have created field in BMM. Moved this field to Presentation layer. Field was added to the prompts and filters for few dashboards.Everything fine till now if reading data from the fact tables which are connected with dim_person.
We have also aggregated tables. As they are aggregated, there is no data per person
we have created mini-dimension table with two keys and two values, and the keys were added to the aggregated table.
Mini-dimension was added in the star schema connected to the aggregate.
In BMM I have added new LTS (dimperson_md) to one of the logical tables. I have created new field, and added to the Presentation.
Field was added to the promtp and on aggregated level is displaying the data fast and easy.
Problem starts when I would like to see in details for example employees assigned to this field. Then I get error.
Please help me to understand what part of setup am I missing?
Or maybe it will not work in RPD and need to be connected on report side?
Answers
-
aPsikus wrote:Hi,I will try to be as more specific as possible.
And yet.....not a word on the version X-D
Edit: And no, a "12c" tag doesn't mean anything.
0 -
Is version anyhow related to the described error or possible solution?
0 -
Let me think about it - there were 25 (yes, twenty-five) "12c" version so far which can run on many different platforms.
It's software. Which means there are always possible bugs. Many of those are known and registered in MOS.
With good information provided in the questions we can search for solutions more specifically. Without....we can't. That's the whole reason that the "How to ask questions" was written:
0 -
Issue solved.
Thank you for your help and support.
0 -
That's not the "Correct" answer since you don't say what you did to splve the issue and hence it helps nobody except yourself.
If you come to the forum to ask questions, please share the solution with other users. You expect to get answers, so not sharing answers with others is not a very corteous thing to do.
0 -
If anyone will be interested can contact with me and I will try to provide a description what I have done.
0 -
That's not how the forums work. You ask for help which people provide out in the open and visible to everybody in the forum. Your "offer" of sharing the solution in private goes against this since nobody benefits from this.
0 -
Well, no one provided any solution or even a suggestion.
Instead I received question about version and some "smart-ass" talk going nowhere. In my opinion version has nothing to do with RPD setup, as it didn't change with newest version.
Hint for solution: keep in mind that there is CASE formula, so you do not need to connect with single column from LTS.
And I have marked my offer as correct answer to not keep it opened forever.
0 -