Dear All,
Need some help....
I want to make a form as attached.
What kind of dimension that I need?
And what should i do when account description doesn't have any account no?
Could I make the form without add any new element in account name dimension?
Could anyone help me?
Thanks,
TM1 - Form
-
mariatjahjadi
- Posts: 9
- Joined: Wed Oct 19, 2011 9:09 am
- OLAP Product: sql
- Version: tm1 9.5
- Excel Version: 2007
TM1 - Form
- Attachments
-
- Form
- form.JPG (29.28 KiB) Viewed 2456 times
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: TM1 - Form
In essence, what you have with the Account "Description" is a sub-account. Your best solution is going to be to add those sub-accounts to your account dimension and have them children of the accounts they belong to. One other possibility would be to create a separate dimension for them and use zero-suppression to make them show up only in accounts they correspond to but I wouldn't do that unless the sub-account could possibly show up under more than one parent.