Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

RPD - Duplicate LTS with filter for a new meassure

Received Response
31
Views
7
Comments
1037520
1037520 Rank 4 - Community Specialist
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

Hello, I have a fact table in a BMM and i need duplicate its logical table source filtering by a value to calculating a new column (meassure).

When i want setting the physical table for my new meassure the new LTS does not appear just appear the original.

I understand its happen because both LTS refer the same physical table.

Dos someone know how i can do this??

I just want create a new meassure based in a filter over the LTS original, but keeping the LTS original for others meassures.

Thanks a lot for your help.

Answers

  • orcllover
    orcllover Rank 1 - Community Starter

    USE FILTER FUNCTION, instead creating 2 LTS..

    https://docs.oracle.com/en/cloud/paas/bi-cloud/bilug/editing-formulas-or-calculated-measures.html#GUID-56B8E03F-E6A6-4421-AD81-DDD72B5D68F4

    1.png

  • 1037520
    1037520 Rank 4 - Community Specialist

    Thanks for your answer orcllover, i tried that but appears an error because the 'filter using' just work if the filter is by a dimension and i need filter the fact where a meassure is > 0.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    First what version are you talking about?

    So you are saying you duplicate the LTS and you don't see it? Do you maybe have a screenshot?

    I would say you better set the mapping to logical columns in the LTS instead of the column. In that case you can't not see the LTS as you are using it and so you don't even have to question yourself if you see it or not.

  • 1037520
    1037520 Rank 4 - Community Specialist

    Gianni,

    The version is OBI 12c. I send the screenshot.

    Don't understand ' better set the mapping to logical columns in the LTS instead of the column', can you explain me please?cuota.png

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi,

    I think what they are suggesting is; -

    1. In Business Model layer duplicate your existing measure and give the duplicate an appropriate name

    2. Edit the formula on the new measure, applying the filter as shown in the first post, after all it can be based on physical measure and you can reference other measures, or use case logic or similar to give you similar functionality

    3. Drag it into the presentation layer in the appropriate place

    4. Test

    If 2 cannot explain for you then kindly provide further detail as to why?

  • Gianni Ceresa
    Gianni Ceresa Mod

    What you see is right, because as you said the physical table is the same one

    And the last screenshot on the right you are inside the LTS, so you set your column to the formula you want and you maybe want to cancel all the others.

    I guess you want your "moderadora" LTS to source only the logical column "personas unicas moderadora", so there in the last screenshot on the right cancel all other mappings on other columns, and set it on the column you want (or formula) for the "personas unicas moderadora".

    If you then open the logical column itself you will see it's sourced from that LTS while all the others are sources from the other LTS.

    But what you see is right: on the physical side of things the table is always the same

  • 1037520
    1037520 Rank 4 - Community Specialist

    Thanks a lot Gionni. It works perfect !!!