Analysis based on result of another analysis +

Question

Hi

I know how Analysis based on result of another analysis works but my question is can I tag/flag these records that came from the other analysis, like this:

As you see below, analysis 1 has a list of 5 orders, analysis 2 would have a filter to show orders based on another analysis which is the 5 orders (order number from 1 to 5) and flag them, you see in column called based on another analysis 'Y' and would show another list of orders 6 to 10 and would be flaged as N...so basically is there a way for me to know which order diplayed in analysis 2 is based on result of analysis 1 or not?

Joe Choueiri-Oracle · Answer

Thanks @Gianni Ceresa

It seems the only way as you said by writing the logice of Analysis 1 in the formula of a column in the analysis 2 but still going through challenges, can I give you another scenario which is more close to what I am trying to do.

I have an analysis, made of booked orders in current quarter.

Some of these orders in this analysis are renewals but I can not tell which one, the system does not have any field to show me that.

The only way is to look at another analysis where it shows which orders/subscriptions that are expiring so if that customer id # of the expiring subscription can be found in the first analysis where has all kind of orders and that customer has an order/subscirption starting /booked date right after the expiry date of the original order then it is a renewal order so need to flag it. Sorry if I confused you.

Gianni Ceresa · Answer

If your analysis 2 filters based on the results of 1, doesn't it shows only order # 1-5?

What you are asking does sound, to me at least, more like a logical / functional dependence than what "based on results of another analysis" is, which is a real WHERE condition in the query.

And as any WHERE condition, it limits the returned rows instead of flagging them somehow.

To achieve what you are asking you should consider writing the logic of analysis 1 in the formula of a column returning Y or N.