I need to design data form that shows a few attributes in columns of form.
Lets say i have accounts in rows with 2-3 attributes and period in columns. So my data form should has accounts and attributes with intersection of period. Users would enter some data.
How such design could be achieved? Pls, suggest me some workaround and where it can be done (web form, excell etc)
I'm new to TM1
Thanks in advance,
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
5 replies Latest Post - 2012-08-03T08:42:22Z by vipirailo
Pinned topic Can i show attributes in data form?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-08-03T08:42:22Z at 2012-08-03T08:42:22Z by vipirailo
Re: Can i show attributes in data form?2012-07-24T13:31:58Z in response to vipirailoYes you can have Attributes in the TM1 Websheet. You just have to use the DBRW() or DBR() formula in the Excel spreadsheets. In the formula just point to the }Elements_Attributes_dimensionName cube
Re: Can i show attributes in data form?2012-07-25T14:55:09Z in response to Rizwan.KaifHi, Rizwan and thanks a lot for the idea.
As per my current TM1 experience i have to spend a day understanding what you mean :)
Let me list my steps
1. I created excel sheet via Perspectives using one of the cube View
2. Then i added 2 columns with formulaes like these "=DBRA("RLH:Actions",$A7,"Code")" , "=DBRA("RLH:Actions",$A7,"Measure")" and saved the xlsx file
3. I've uploaded worksheet via Architect onto TM1 server in my application
4. i've drag'n'dropped sheet into app via TM1 Performance modeler. Saved and deployed app
Are these steps correct?
Now i can open websheet in my app, can enter values, they calculated automatically but i can't do the commit. Changed cells are blue. Pls, help where am i wrong
You'll be so kind if you could explain me what is pro's and con's of using websheet vs other methods of submitting data. Are the TM1 cube rule applied to websheet?
Re: Can i show attributes in data form?2012-07-30T20:19:22Z in response to vipirailoThe steps which you have listed are right. DBRA() function can be used to retrieve the current attribute value as well as to Write the element attribute.
Have you tested the spreadsheet in Perspectives itself? If it is working in Perspectives it should work on the web as well.
Re: Can i show attributes in data form?2012-08-03T08:42:22Z in response to Rizwan.KaifHi and many thanks Rizwan. Finally it gets worked. Sorry for last reply.
It looks like were was some sort of error in approval hierarchy
Now i'm going further and have some other questions. I'll be posting them in new threads