TM1 Forum

Hi, gurus
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 in TM1

Thanks in advance,
Vladimir

{Admin Note: moved to the correct forum. This is not an enhancement request}

I'm not sure 100% sure what you are asking for but if you are asking how to get my sttributes to show up in Excel then you should use the DBRA formula
DBRA(server:dimension, element, attribute)

Hi, Steve 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 say 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?

Performance modeler is latest version so does it work with DBRA? , previous versions you would have completed what you are trying to do in TM1web. Does it work if you open the https:/RLH/tm1web view and then open the websheet from applications (as opposed to performance modeler). There will be no need to commit the values

this may be part of the problem? http://www.tm1forum.com/viewtopic.php?f=3&t=7719

BigG wrote:this may be part of the problem? http://www.tm1forum.com/viewtopic.php?f=3&t=7719

Thanks for the link. I've forgotten to say i tested websheet under admin account. AFAIR admin has write access by the default so it can't produce access issue i think
It looks like i'm working in my local sandbox and i don't know how to sync changed data back to TM1 server. I don't see such button and Commit is greyed out. I'm working in IBM COGNOS TM1 APPLICATION by the following URL -http://localhost:9510/pmpsvc/pmpjs/work ... c277b57%7D

Maybe i have to add some lines in tm1 config or something else?

BigG wrote:Performance modeler is latest version so does it work with DBRA? , previous versions you would have completed what you are trying to do in TM1web. Does it work if you open the https:/RLH/tm1web view and then open the websheet from applications (as opposed to performance modeler). There will be no need to commit the values

Hi, i used PM to upload sheet into app and for deployment app only. Then i worked in tm1 application (http://localhost:9510/pmpsvc/pmpjs/work ... c277b57%7D it's my url)
Do i need another url to use? it looks like i missed out some basic principles of TM1. How can i sync sandbox data on TM1 server? Maybe i have to submit approvals hierarchy first as workflow prevented syncronization of sandbox on the server?

Thank you all. Issue was resolved. It looks like were was some sort of error in approval hierarchy