Oracle Analytics and AI

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
More Solutions
Oracle Business Intelligence Applications Forum

How to create two fact in an analysis to show in tile

Muhammad Hyder

Hi,

How to create two facts in an analysis

first fact: Count(Customers) where product equal to/ is in "xyz"

second fact: count(customers) where product is not equal to "xyz"

Regards

MD Hyder

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Either in the RPD with distinct logical columns based on filtered LTS (reusable, dynamically reacting to dimensionalities) or in an analysis with the "FILTER x USING y" functionality:

Example here: http://slc02okg.oracle.com:7780/analytics/saw.dll?Answers&path=%2Fshared%2FOTN%2FFiltered%20Fact%20Columns

Prodney / Admin123 to log on