Simple Question on a Descriptor Field. — Oracle Analytics

Oracle Analytics Cloud and Server

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

Simple Question on a Descriptor Field.

Received Response
11
Views
4
Comments
2850613
2850613 Rank 1 - Community Starter

Please see the below table:

pastedImage_0.png

The first column is the account, the second column is the sub-account, the third column is the description for the combined account with the sub-account.

I need to change the information in the fourth column to show the description located in the '00' sub account for each account For example, in the column labeled "'00' Description", I need to show all sub-accounts of 900654 with  the description 'Space Rental'.

I need to show all sub-accounts of 900760 with  the description 'Administrative Overhead', etc. .

Thanks in advance for your help.

Bob

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    You need to model the hierarchical relationship between account and group account ...

  • 1008490
    1008490 Rank 3 - Community Apprentice

    Hi,

    You want to show if the the Account no is 900654 then 'Space Rental' use case statement.


    edit formula write like below:

    Ex Case when accountnumber=900654 then 'Space Rental'

         casw when accountnumber=900760 then 'Administrative Overhead' else accountnumber end

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    That's the one-time solution ... USE of information drives design.  Spend the effort and do it right; then it will perform better and is much more usable.

  • 1008490
    1008490 Rank 3 - Community Apprentice

    yes Thomos, I gree this is one time solution. I given to solve current requirement.