TM1 Forum

I have never tried this, but have seen some documenation on controling the page length in tm1 web.

Search in the documenation for
CubeViewerRowPageSize
CubeViewerColumnPageSize

Shawn, I have experienced both issues you have listed. It has been over 6 months since I figured them out. For the first one, I used a similar workaround. Basically 1 main ID that would control the contributor packages. For the second one, I found out that the error is very generic and the issue cou...

the prolog tab does not read in the datasource.

move this statement to the data tab:
scol6input = V3|V4|V5|-|'Rate' ;

Stella, It seems the manufacturing plant value is determined by the rows, if so then you already have the proper implementation of looping through the periods and having a separate cellputn for each plant. When you say "one number", is that the same number being posted to all manufacturing...

tomok, you are correct. thanks for catching my mistake.

I guess the morning coffee's effect have not kicked in yet.

I agree with Martin in that it is a case by case basis. In my limited experience, I have noticed that regular dimension maintenance has been of a lower priority and most dimension updates are actually caught during data loads. For this, I create an unmapped bucket in the dimension and add any new me...

I would just split out your code into the prolog, data, and the epilog tabs. Prolog: CurYr=’20’|SUBST(Period_Name,5,2); CurMth= SUBST(Period_Name,1,3); vCube = 'Reporting'; vDimName1 = 'Month'; vDimName2 = 'Year'; vTemp = 'SystemUseOnly_Load' | STR(RAND, 10, 8); vViewName = vTemp; vSubName = vTe...

I believe you need 1 more: [code['Testing_Measure'] = N: if( Attrn('OV_Item', !OV_Item, 'Scrap_Value')=1 % Attrn('OV_Item', elpar('OV_Item',elpar('OV_Item',!OV_Item, 1), 1), 'Scrap_Value')=1 % Attrn('OV_Item', elpar('OV_Item',elpar('OV_Item',elpar('OV_Item',!OV_Item, 1), 1), 1), 'Scrap_Value')=1 % A...

For the most part, I prefer to do dimension maintenance as a separate process prior to the data load. I do, however, still have steps in the metadata for the load process to add any new members to avoid any errors during the load. This section has a check to first make sure if the element does not e...

I have survived with similar restrictions in the past. It is not that bad. I was able to successfully do almost all the tasks for my position. IT would do monthly maintenance and that would be only time the machine would be re-booted. In an emergency situation, I could just email IT to re-boot. What...

When you are setting string values in a rule, you have to place a "S:" immediately to the right of the equal sign.

Try:
[]=S:IF(((ISLEAF=1) & (!}Groups @= 'ProductPersonel') & (!RevenueMeasure @= 'Revenue Gap')), 'NONE', 'READ');

sdm,

If you are clearing out ALL data for a list of cubes with no regard for specific element restrictions, your process could be much simpler if you utilize the CubeClearData() function as rkaif pointed out.

You have 2 options: 1) add the code that lotsaram posted to the beginning of the data tab. 2) create a new variable in the Variables tab with that code. It will then place the code for you in the generated statements section of the data tab. This will require you to assure that your cellputn functio...

Dan,

You are performing conditional checks on the data tab? for which you have a dynamic subset?

What processing are you performing on the data tab that would require the subsetgetsize command?

Chris, You are recreating the dimension because the consolidations change, right? Insted of deleting all elements, why not just loop through the dimension and only delete consolidated elements. I prefer to go this route and have never had the issue you described. It will keep all level 0 members int...

I have found it best to use a TI process to clear out my data. I like to create a dynamic view with dynamic subsets and run the clear out from there. This allows me to clear specific sections of the data without having to manually create views everytime. It also allows me to clear data for any cube ...

Are you using the viewzeroout function? If so, then how are you getting record counts.

If you are looping through the view to get record counts, then are you assigning a blank or 0 value to all cells on the data tab?

You can also use this:

SubsetCreateByMDX(subset, '{TM1DrillDownMember({'[Dimension].[Element]'},ALL,Recursive)}');

Tom, This can definitely be achieved. I have not tested this but saw a similar implementation in an application. You would create an intermediary cube that would have dimensions from the other 2 cubes: Dept, Job Code, Earning, GL Account, GL Budget Measures In the Payroll Budget Cube: Skipcheck; Fee...

Martin, You are correct that for the most part Contributor is just TM1 Web mixed with TM1 Workflow. A Contributor application in the 9.5.1 version has 2 folders to show the planning nodes. 1) Contributions folder - this contains a list of all level 0 members in your approval hierarchy. They are just...