Skip to main content
O
osanalyst
Newcomer
June 13, 2023

Trying to link an adj form to a cube view

  • June 13, 2023
  • 2 replies
  • 0 views

Hi I'm trying to link this form to an Headcount correction form but when I navigated to this linked form, It shows me in the Group adj column green cells. How can I make them imputable?

osanalyst_0-1686650927236.png

 

2 replies

E
OneStream Employee
EricOsmanskiOneStream Employee
OneStream Employee
June 13, 2023

Hello - can you provide more information. Is this a CV that is attached to a Form Template and then attached to a Workflow Profile? Is the Group Adj column property Can Modify Data marked set to True? Is the Group Adj column at a POV at can be input to? Is the Entity you are trying to input to assigned to a Workflow Profile that has a Forms workflow active? 

O
osanalystAuthor
Newcomer
June 13, 2023

yes, to the first two questions and also the last one. this is the pov. the problem is with the UD7 (Audit ID).Everything that is not under AU_InputsTotal cannot be input on beforeadj (unfortunately this is the case), And everything under AU_InputsTotal is not available for journals.
If we manage to input adjinputs through forms, we can use an existing adjustment UD7. If not we need to create a new member for this. 
But then I don't know how to make it work with workflows and workflow channels

osanalyst_0-1686657962721.png

osanalyst_1-1686657980217.png

 

E
OneStream Employee
EricOsmanskiOneStream Employee
OneStream Employee
June 13, 2023

Ok, I am not sure I am following this. The UD7's you mention in the previous post are not in your CV, so I am not sure where M_RET90 falls in the UD7 hierarchy. What is the POV of one of the cells you are trying to input to? What dimension is in the columns? 

P
PhilB
Newcomer
June 13, 2023

I noticed in your cell POV that you have origin set to O#AdjInput.  Typically, that origin member is used for journal entry adjustments, not for form input. Can you confirm what the "Adjustment Type" property on the A#HC_REG account is? It should be either Journals, Data Entry, or Not Allowed. If it is set to Journals (the default setting), you would not be allowed to use O#AdjInput with a form. You would need to do one of two things:

 - Change your Origin member to O#Forms (or O#BeforeAdj)

 - Change the Adjustment Type property on your account to be "Data Entry". You just need to be very careful making this change as you would no longer be able to post journals to that account (since the adjustment type has been changed).

    Terms & ConditionsAccessibility statement