Skip to main content
P
Priti_S_Satkar
Newcomer
December 7, 2024

Input form for Project planning

  • December 7, 2024
  • 1 reply
  • 0 views

Hi,

I want to build an input form for project planning where the projects are defined in UD1 dimension, but for the rest of the columns (Start date, End Date, and Contact type) there is no dimension defined. How can i build a input form via cube view if there is no dimension defined in Onestream. But Clinet wants to input the columns data (Start date, End Date and Contact type), in the system via form.

 

1 reply

M
OneStream Employee
MG3OneStream Employee
OneStream Employee
December 9, 2024

You would need to define a member in each dimension for any cell in the cube. So If you have project in UD1, you may have a small sub hierarchy in Accounts which includes a member for Start Date, End Date and Contract type. If you followed this approach you may have to use one of the annotation members in the view dimension to enter text in the cube. 

HOWEVER, you should consider a table based approach, e.g thing planning or a custom table as these may be better options for storing project information. We don't know your requirements but I would strongly suggest researching a table based solution.     

Terms & ConditionsAccessibility statement