Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Simple Question on a Descriptor Field.

Please see the below table:
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
-
You need to model the hierarchical relationship between account and group account ...
0 -
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
0 -
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.
0 -
yes Thomos, I gree this is one time solution. I given to solve current requirement.
0