Error in Data Action SAC - Too many member combination

[andreag412]

Good morning,

I have an error that keeps recurring. I created several variables for model dimensions in SAC and put them in the context of the "Advanced formula" step of Data Action. This is because the desired is to pass these values directly from history via input control.

But the error that comes up is always the same: "Too many combinations."

Is there any workaround?

[hartmut_koerner · Accepted solution]

Hi Andrea,

I think you need to make the assignment of Adj also fact data driven and not master data driven.
The trick could be to write
DATA([d/Measures]="Adj") = RESULTLOOKUP([d/Measures]="InitialValue") * 0 + @pAdj

Best regards
Hartmut

[andreag412 · Accepted solution]

Hi,

thanks for the help. the error is gone

[PRAT280]

Hi,

It seems the statement in line#14, its trying to write too many records. You may be passing node members for dimensions which will create cartesian combination of records for each base members. May i ask you to share the screen shot of the # of Members of each dimension ( shows when you hover the cursor) after you have entered your parameters

Thanks