MEMBERSET I cannot use the attribute function.

[former_member708342]

Hi Community,

I am creating a model in order to calculate the Amortization of the investments of a company. I have created a Generic Dimension called Investments, and among the properties of each of the investments is the investment date and the date of completion of the amortization.

The process to calculate amortization is as follows:

1. The user adds a new member in the table within the story, and when adding the new member, the user must enter the investment date and end date of the investment.

2. The Data Action is launched, the user has to enter the amount of the investment. The data action directly calculates the amortization for each of the months.

The only problem that I find is that in a MEMBERSET I cannot use the attribute function. I was wondering if there is any possibility to use those properties like MEMBERSET [d / Date]

Thank you in advance,

Carol.

[JefB]

You run the data action for 1 investment only right?
Did you try:

MEMBERSET [d/Investments] = %SELECTED_INVESTMENT%
MEMBERSET [d/Date] = PERIOD([d/Investments].[p/StartDate]) TO PERIOD([d/Investments].[p/FinalDate])

[nikhil1401]

Leticia,

Try

MEMBERSET([d/Date] = PERIOD([d/Investment].[p/StartDate])

Investment- Dimension

StartDate - Attrbute of Dimension with values 201901

Nikhil

[former_member708541]

Hi Nikhil,

Thanks for your answer. The problem is that the MEMBERSET I want to set for the date is of the style MEMBERSET ([d / DATE]) =[d/Investments].[p/StartDate] TO [d/Investments].[p/FinalDate] and this gives me an error. With the PERIOD function you mentioned, it does not allow me to set the MEMBERSET ....... TO [d/Investments].[p/FinalDate].

Do you have any other ideas?