Topic
  • 5 replies
  • Latest Post - ‏2012-08-03T08:42:22Z by vipirailo
vipirailo
vipirailo
63 Posts

Pinned topic Can i show attributes in data form?

‏2012-07-24T13:17:16Z |
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 to TM1

Thanks in advance,
Vladimir
Updated on 2012-08-03T08:42:22Z at 2012-08-03T08:42:22Z by vipirailo
  • Rizwan.Kaif
    Rizwan.Kaif
    197 Posts

    Re: Can i show attributes in data form?

    ‏2012-07-24T13:31:58Z  
    Yes 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
  • Rizwan.Kaif
    Rizwan.Kaif
    197 Posts

    Re: Can i show attributes in data form?

    ‏2012-07-24T13:51:57Z  
    Yes 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
    You can also use the DBRA() function in the websheets to pull out the values of the element Attributes.

    Rizwan Kaif
  • vipirailo
    vipirailo
    63 Posts

    Re: Can i show attributes in data form?

    ‏2012-07-25T14:55:09Z  
    You can also use the DBRA() function in the websheets to pull out the values of the element Attributes.

    Rizwan Kaif
    Hi, 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?
  • Rizwan.Kaif
    Rizwan.Kaif
    197 Posts

    Re: Can i show attributes in data form?

    ‏2012-07-30T20:19:22Z  
    • vipirailo
    • ‏2012-07-25T14:55:09Z
    Hi, 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?
    The 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.

    Cheers!
    Rizwan Kaif
  • vipirailo
    vipirailo
    63 Posts

    Re: Can i show attributes in data form?

    ‏2012-08-03T08:42:22Z  
    The 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.

    Cheers!
    Rizwan Kaif
    Hi 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
    Thanks again
    Vladimir