cancel
Showing results for 
Search instead for 
Did you mean: 

Dimension members -Question???

Former Member
0 Kudos

Is it possible to add dimension members using script logic?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

If you are thinking about adding new dimension members to dimension, then there is no way to do that using script logic.

Script Logic is used to handle and modify the application data, not the master data.

Former Member
0 Kudos

Thanks for your reply.

i am working on TOP down allocation..since we cannot write data to a parent member, i want to create a dummy base member for an entity to store the total and then do the allocation.

how to do this? currently i manually updated the entity dimension by adding a dummy base member.

is there anyother way to do this?

Former Member
0 Kudos

Why not create a dummy member permanently in the dimension? You may use that member to store your totals and use it in WHAT region for allocations.

I don't think adding a single member for the purpose of calculations will create problems.

Former Member
0 Kudos

Hi,

We cannot modify the member sheet from the script logic. Script logic works on 3 tables - fact, fac2, and factwb. However, the dimension members are maintained in separate tables. So, no feasibility of modifying the members from script. You will have to maintain the dummy members in the member sheet directly.

Hope this helps.

Former Member
0 Kudos

Thanks all for ur replies.