Categories
- All Categories
- 147 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Alter legend
Hello everyone.
I would like to know how it is possible to make a change of the field highlighted below.
I'm using OBIEE 12c on which option should I access
.
Tks.
Answers
-
a) that's not a field that's a dimensional member inside a dimensional attribute used as a horizontal axis label
b) what do you want to change?
c) if your data source actually stores the value "em atraso" ("in arrears?!" ... google translate) the that's what you get back
0 -
What are you asking? given the image of the chart I assume you have a dimension that has the aging buckets (24,48,72,Late) ... so I'm not sure what you are asking.
0 -
Oh that means "Late"? Naughty google :-D
0 -
When the values are greater than 72h they are "in arrears" but the name "in arrears" I do not have in my dimension how can I do
0 -
how do you expect to classify a fact when you don't have a dimensional key for it?
how does you fact table account for a row that doesn't fit into 24,48 or 72?
OBIEE doesn't make up data.
0 -
You're right.
I'll study the case better and come back with a more correct question.
0 -
Arrears data is usually stored as Accumulating Snapshot where all of your 'bins' are keyed to your age bin dimension.
As a snapshot then you can on regular intervals see the changes in a delinquent account over time. Can make practical decisions as:
Do I spend the time and $$ to collect this account (first time in arrears) OR that account (5th time in arrears and amount owed is growing AND aging)?
It's nigh impossible to do the Accumulating Snapshot purely logical in the BMM layer of OBIEE -- add to that row volumes and the need for performance -- I strongly recommend a good look at the physical fact star before you model in OBIEE.
0 -
That's all fun and games but you still haven't answered the question:
What are you actually trying to do? "make a change of the field highlighted below" still doesn't mean anything with your explanations above.
0 -
The circled bit in his mock-up is not part of his dimension table ... he was wondering how to add it to the chart ("make a change").
^ if I understand correctly!
0 -
Sorry for the wrong information.
Each bar is made by the difference between the day of delivery of exams and the current day
Example: CURRENT DAY - TIME DELIVERY TIME
When the difference is greater than 5 days it must be counted in the block "Em atraso"
But I had an idea.
I can set up a table in the Administrator Tool with 4 columns '24', '28', '72', 'Em atraso' and fill them with notes for the columns with timetable, but I only have one question to fill when I will know that the difference Is 24 or 48 to put in the correct column.
I'm an apprentice in OBIEE, I did not have an orientation. I'm learning on my own.
Note: For the time being I am not allowed to change the database. I have to try to work with data I already have. So ETL process, or things like that will not do. Thank you very much
0