TM1 Forum

http://www.bihints.com/monitoring_chore ... ail_part_2

prob you can do something like the above tutorial.

Have you tried the following code?

mySubsets = myServer.Dimensions[dimension_name].PublicSubsets;
sSubset = mySubsets[subset_name];

when you mention common, what is it referring to ? From the hierarchy, common and license looks like a consolidation element instead of an attribute. The number that you are providing is a count of how many work station there are ? I presume your source data looks something like the following ? work...

I have exactly the same issue as you have a while ago. When excel is converted to tm1web there might be certain things that cant be recognized by the code that does the conversion. I just try an error to find out the answer.

Has the changes for license and common attribute been updated on the workstation dimension ? or you are looking for solution on how to update the attribute on the workstation dimension ?

when you install Architect and Xcelerator on the client workstation, is it login as administrator or the normal user login ?

hi manoj, just incase if you are asking how to put levels of data into table, i can provide you with some idea how this can be done before using ODBC connect. On your TI code you can use 3 variable, Level0, Level1, Level2 Then you can use ELLEV to check what level is the element in the structure. if...

It is important to know the behaviour of TM1 as well. Some you may find it on the Tm1 developer documentation from IBM. Some you will only find out after working on the software for a while. Small things like the sequence of the dimension plays an important part in determining the cube performance. ...

Have you tried putting " ' " before the date ? Sometimes using the excel convert format doesnt really work. But putting a single quote before the date can be for sure that it is a string instead of a date.

You can use dos to append the new logfile to an existing log file.

ExecuteCommand('cmd /c type para.log >> paraTemp.log',0);

haha... thats right. that would resolve all the sequence issue.

that looks like a resonable solution that doesnt require much work to maintain it. but would like to further emphasize that using dimix, the sequence of element created in the dimension is important. eg if Jun is created subsequently all the days follow by Jul and all the days, therefore it will com...

using the rules define by declanr, I guess it is possbile if the year and the month date dimension is combine into one dimension and use attribute to define prior day according to the existance of the data but this will require alot of work to maintain the attribute as well.

Looks like a good idea. but i would like to confirm about the rules. using the rules given wouldnt it mean May-14 = (May-07 + May-08 + May-09 + May-10 + May-11 + May-14 ) / 6 ? May-05 0 May-06 0 May-07 187,989 May-08 203,375 May-09 236,468 May-10 106,078 May-11 426,669 may-12 0 May-13 0 May-14 296,7...

Not too sure if it can be done via rules as you are looking to skip days which is 0. I tried using TI process to do it and it is achievable. Create a view of all days at N element level and years and set "Skip Zero /Blank values". temp1 = temp2; temp2 = temp3; temp3 = temp4; temp4 = temp5;...

you wanted to have a suppress zero using TI code instead ?

have you tried using
ViewExtractSkipZeroesSet (Cube, ViewName, Flag);
or
ViewColumnSuppressZeroesSet(Cube, ViewName, Flag);

http://publib.boulder.ibm.com/infocente ... sub-30.gif

Will this be something you are looking for ?

did you have an earlier version installed previously ? did it uninstall successfully without giving any error ?

correct me if i am wrong, the ClientPropertiesSyncInterval parameter is used to trigger the logging by certain interval and not by changes made on the STATUS cell in }ClientProperties ? normally how a cube logging works is it will log as an entry on the log file when the cell is changed from "&...

just a guess, have you tried right click on the file "Run As" an administrator ?