Struggling with something and hoping you help/add insight. I am preparing a forecasting template and would like the
user to input a string value at the intesections of all "SFC Account line item(s)" and "Line item description" as per screenshot below.
My Problem is that the they need to be strings instead of values. The months will hold the forecast values in question.
So.... Is this possible to set that intersection to a string even though the "Value" measure is numeric???. I do not want to stack another dimension on the Columns to keep it as simple as possible.
advertising forecasting final.png (49.14 KiB) Viewed 4179 times
7Zark7 wrote:Struggling with something and hoping you help/add insight. I am preparing a forecasting template and would like the
user to input a string value at the intesections of all "SFC Account line item(s)" and "Line item description" as per screenshot below.
My Problem is that the they need to be strings instead of values. The months will hold the forecast values in question.
So.... Is this possible to set that intersection to a string even though the "Value" measure is numeric???. I do not want to stack another dimension on the Columns to keep it as simple as possible.
In TM1 cubes whether a cell is numeric or string is defined by the element type of the LAST dimension in the cube as per the original dimension order. So with your example if the period dimension was last AND the Line Item Description element type was S then you would be able to input a string into the cell with the view layout exactly as is. If the title element displaying "value" is from the last dimension in the cube then you would have to stack. Fine if the interface is Excel or a websheet, no good if the UI is Contributor.
7Zark7 wrote:Have not used this before but this looks like it might provide the solution:
AllowSeparateNandCRules=T
Are there any caveats when using this parameter??
This won't help unless you observe the rules for defining N and S cells from the last dimension in the cube.
Cheers. I guess i can have my months in the measures dim or something like that ( obviously not best practice ), and then rule drive it back in to the month dim later and perhaps hold it the values inititally at a global "no month" variable...
Just another thing, do reckon i just move the period dimension to the last slot instead? I was thinking of rule driving it back, but its probably overkill. The only thing I guess
is that you get a period dimension with some strings that are obviously not period related. What are your thoughts on this? I am thinking best practice here, but in this example perhaps its
not practical? And if this is the case, i guess then my measure dimension is kind of redundant ( do i bother to keep it??), if im using my period dimension as in replacement of the measure dim.
Obviously would not have to go down this path, but I here tm1 websheets can be used in contributor in the latest build, so this sort of thing can be avoided.
Hopefully you won't take this the wrong way, but I would recommend that you take the standard intro to TM1 administration class to help you get up to speed on some of these issues. You have some fundamental misunderstandings of how TM1 works, and a little upfront training will save you a LOT of time on the backend (vs. just trying to learn as you go from the docs and this forum). Your "solutions" to this problem are going to make things a lot worse down the road.
To answer your question, it looks like "Value" is an element in your last dimension. You should add "Line Item Description" to that dimension, not period. Chances are you're going to need to set up an Excel template for data entry and not try to force it into the cubeviewer.
Thanks mate. But my problem is that. The client will be inputting the data straight into contributor to make use of work flow, not excel or tm1web. If i was building this in TM1websheet / excel then per best practice the measure dimension would always be last.
I need to keep the view cells open, and stacking multiple dimension on the columns will get messy as I will need to zero suppress, so the thought was to use One dimension will work better. The problem, is I need a period dimension on the columns but also would like to add a string element for description. The only way to do this is to place the Period dimension last OR put elements in the measure dimension that resemble periods. Just wondered what the best approach is here. I can place the period dimension last but it just looks weird, but i will avoid putting period elements in the measure dimension to make my view work.
