Calculation result type (attribute/measure)
Hi,
Is there any way to specify calculation result type to be an attribute or a measure?
Thanks,
Alexandr
If you find replies helpful or if you got a complete answer to your question please mark it as closed so others having the same problem can benefit
It should, as in OBIEE depend on the following:
- If column formula contains only attributes then it's attribute
- If column formula contains a measure then it's a measure
I've tried the two formulas you suggested with the samplefile that is included in DVD, the formula was the following
case when Sum(XSA('weblogic'.'Sample Order Lines')."Columns"."# of Orders" by XSA('weblogic'.'Sample Order Lines')."Columns"."City" ) < 50 then 'A' else 'B' end
In this case the new column was shown as Attribute (maybe because of the two alphabetical values) but wasn't acting as attribute in the Chart until I included the City in the chart itself.
case when Sum(XSA('weblogic'.'Sample Order Lines')."Columns"."# of Orders" by XSA('weblogic'.'Sample Order Lines')."Columns"."City" ) < 50 then 1 else 0 end
In this case the new column was shown as Measure (maybe because of the two numerical values) but wasn't acting as measure in the Chart until I included the City in the chart itself.
I believe that due to the mixture of measures and attributes in the formula, you should use the data flow option.
Thanks for the answers!
Example 1:
Add to My Calculations "case when N>100 then 'A' else 'B' end". I`d like to use this as attribute in charts, as X-axis.
Example 2:
Add to My Calculations "case when N>100 then 1 else 0 end". I`d like to use this as measure in charts, as Y-axis.
I know I can add this calculations to data flow or even to SQL.
The question is what My Calculations result type depends on?
This is correct for data sources and data flow results.
I`d like to do the same for My Calculations results.
There is no way to force it being attribute vs metrics in the front-end.
Maybe you need to use data-flow component to add it to your dataset appropriately.
What is the measure/attribute that you are having problems with? if you describe it better we could help more efficiently
Yes,
If you are just uploading a spreadsheet you can change the attribute/measure definition by editing the data source.
If you use Data Flow, then you must include an aggregation step where you can define measure and attributes.
For more info please check https://www.rittmanmead.com/blog/2016/10/data-visualisation-desktop-data-loading-2/
Thanks for the tip on a calculation containing a measure becomes a measure.
I needed this because I want to subtract two datetimes to get the number of hours between. The only problem is that it became an attribute and I need it to be a measure.
So, here's my formula:
("End Date & Time Date"-"Start Date & Time Date")*1440+("Headcount"*0) [extra sources removed for clarity]
Kind of sad that I have to add Headcount*0, but that's how I solved it. Oracle, we need the ability to control whether it's a measure or an attribute, or you have to somehow be smarter. Subtracting two times almost always should result in a measure.
Maybe sometimes it needs to be an attribute ... like subtract 1 week from <Event Date> which is date datatype and present as attribute.
Then the resulting column "Event Date LW" can also be used as an attribute.
That said, most of the time, date fields used in calculation formulae result in measures, not attributes <shipment delivery delay in hours/days>.
This may not be the exact question, but relates to the thread : there is a function you can use to turn a metric into an attribute in DF : Attribute(). See this blog+video giving some backrgound with it :https://twitter.com/philippe_lions/status/765933698663510016
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4
So I have an action passing a value to another workbook. On the other workbook, I have an expression filter and a parameter I created and it does not seem to work. Any ideas. See the images
We know you can directly export workbooks and folders from within OAC, and we know you can migrate OAC content using the FDI Content bundle. However, it's unclear what settings or steps are required in order to ensure any calculations in "Shared Objects" still carry over. When making a .dva artifact export from OAC for…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
