RPD issue - missing LTS — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

RPD issue - missing LTS

Received Response
112
Views
9
Comments
aPsikus
aPsikus Rank 6 - Analytics Lead

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    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.

  • aPsikus
    aPsikus Rank 6 - Analytics Lead

    Is version anyhow related to the described error or possible solution?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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:

  • aPsikus
    aPsikus Rank 6 - Analytics Lead

    Issue solved.

    Thank you for your help and support.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • aPsikus
    aPsikus Rank 6 - Analytics Lead

    If anyone will be interested can contact with me and I will try to provide a description what I have done.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • aPsikus
    aPsikus Rank 6 - Analytics Lead

    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.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Point 3: Give information about your environment, such as versions of software you use. This is essential, as versions change and other users might run into a similar problem never knowing if the thread they read was about their version.