"No base member in the selected members of dimension" script logic error

[Former Member]

Hi,

I tried to create a simple script logic:

*select (%incacc%,"[id]","account","acctype='inc'")

*xdim_memberset account = %incacc%

[category].[#budget_new]=[category].[actual] * 10

*commit

And i received the error "There is no base member in the selected members of dimension : ACCOUNT"

Anyone care to explain what the above means and how it can be rectified?

Cheers

[Former Member]

I just used SQL logic of *when .. *endwhen and *rec instead of using MDX logic.

[sorin_radulescu]

Did you received that message on the run time or when you tried to validate the logic?

If you received on run time for me it seems that you don't have any account with acctype = inc which is base member.

Regards

Sorin radulescu

[Former Member]

Hi,

I received the error when i validated the logic.

And i have account with acctype = inc.

Cheers