Set Analysis to Match Dimension

[#1]

Hi Everyone,

I am struggling with creating a Expression for a SUM that will match my selection for my dimension

Dimension:

=IF(AccountAlias.FlagCommitmentFee = 1 OR AccountAlias.FlagAmendmentFee = 1 OR AccountAlias.FlagExtensionFee = 1 OR AccountAlias.FlagRenewalFee = 1,FGL.NativeLoanKey,Null())

Expression:

=If(Dimensionality ( ) > 8,

    SUM({$<[FGLL.GLPostDate] = {">=$(vRollbackEffectiveDate)<=$(=DATE(FLS_FullDateNum))"}, AccountAlias.FlagCommitmentFee = {"1"}>} AGGR(FactGLL.TransactionAmount,FGLL.NativeLoanKey,AccountAlias.Fees,FGLL.GLPostDate,Investor_SLF)) * (-1)

    )

Basically I wouldl like to know how to do ORs in the Set Anaylsis syntax and can't quite figure it out.

[#2]

What you could do is create a new field on the script:

if(AccountAlias.FlagExtensionFee = 1 OR AccountAlias.FlagRenewalFee = 1,1,0) as OrFlag

Then you can do:

OrFlag={"1"}

[#3]

I sort of have what I need...  Just not sure how to combine them.

SUM({$<[FGLL.GLPostDate] = {">=$(vRollbackEffectiveDate)<=$(=DATE(FLS_FullDateNum))"} >} AGGR(FactGLL.TransactionAmount,FGLL.NativeLoanKey,AccountAlias.Fees,FGLL.GLPostDate,Investor_SLF)) * (-1)

and

SUM({<AccountAlias.FlagCommitmentFee = {"1"}> + <AccountAlias.FlagAmendmentFee = {"1"}>} AGGR(FactGLL.TransactionAmount,FGLL.NativeLoanKey,AccountAlias.Fees,FGLL.GLPostDate,Investor_SLF)) * (-1)

[#4]

Alright, do the fields

AccountAlias.FlagCommitmentFee and AccountAlias.FlagAmendmentFee come from the same table? If they do then creating a new field if either equals 1 should allow you to do this:

SUM({$<[FGLL.GLPostDate] = {">=$(vRollbackEffectiveDate)<=$(=DATE(FLS_FullDateNum))"}, OrFlag={"1"}>} AGGR(FactGLL.TransactionAmount,FGLL.NativeLoanKey,AccountAlias.Fees,FGLL.GLPostDate,Investor_SLF)) * (-1)

[#5]

I can't just do that at the moment.  I do not have the "Load Script to work with".  I only have the QVW that is generated from the QVD's

[#6]

Oh alright, I haven't had the chance to work with QVD's, but Would something like this work?

Load *,

if(AccountAlias.FlagExtensionFee = 1 OR AccountAlias.FlagRenewalFee = 1,1,0) as OrFlag;

Select *

From .......QVD

?