How to implement 'except' function in framework manager

[vvasireddy9]

I have a requirement to pull account codes from 'master_table' excluding the account codes in 'exclude_table'. I tried 'except' function which didnot work as it seems to be a dmr function only. Looking for a way to achieve this. Any suggessions are appeciated.

VJ

[MFGF]

I have a requirement to pull account codes from 'master_table' excluding the account codes in 'exclude_table'. I tried 'except' function which didnot work as it seems to be a dmr function only. Looking for a way to achieve this. Any suggessions are appeciated.

VJ

Select both the Master_Table and Exclude_Table query subjects, then go to Actions > Define Query Set. Specify a name for the result Query Subject, and make sure the Operator is set to "Except".

Also make sure that both query subjects have the same number of items, with the same data types.

Cheers!

MF.

[vvasireddy9]

Hello MF.. Thanks for responding.. I believe you are refering to report studio in your response. I am trying to implement this in Framework Manager.. is it possible? FYI.. this is a relational model.. not DMR.

VJ

[Lynn]

Hello MF.. Thanks for responding.. I believe you are refering to report studio in your response. I am trying to implement this in Framework Manager.. is it possible? FYI.. this is a relational model.. not DMR.

VJ

Query sets are are done in FM. Take a look at the chapter on modeling relational meta data for detailed explanation. It starts on p. 82 in the 10.2 version of the guide.

[MFGF]

Hello MF.. Thanks for responding.. I believe you are refering to report studio in your response. I am trying to implement this in Framework Manager.. is it possible? FYI.. this is a relational model.. not DMR.

VJ

Hi V,

I believe I am in fact referring to Framework Manager :) Report Studio doesn't have an "Actions" option on the menubar. Did you even look in FM? It seems puzzling that you would spend more time writing this reply telling me I'm incorrect (without verifying it was true) than it would have taken you to have tried my suggestion? Follow the steps I wrote above. It works. In Framework Manager. With a Relational Model. Not DMR. :)

MF.

[vvasireddy9]

MF - Apologies.. I should have read your message thoroughly. Its just that I implemented 'except' in RS and not in FM in the past, I assumed you refered to RS without even reading properly. Anyways, it worked. Thanks a bunch.. VJ