TM1 Forum

VMM and VMT settings control the stargate cache. VMT sets how long a view request should take before it caches the view. Default is 5 seconds I believe (This is TM1 Server create timing so taking 15 seconds over the web could mean a 1 second TM1 Server time and 14 seconds of network and webserver). ...

Might sound simple but that kind of view leads me to believe zero supression has been turned on and you arent showing all elements for all combinations.

For some reason when we start the source view from the cube we want to export the columns come out in order. When we use a dummy cube and a while loop to assign variables V1-n the come out of order. It's behaving oddly when we switch the view from one cube to another.

Thanks for the info..working on it now.

We aren't using an extra cube, just a generic cube that has 15 dimensions or so. This way the variables tab has enough variables in it to cover any cube we may export from the process.

We are trying to create a generic cube exporter that essentially uses a fake cube to populate a bunch of variables generically named V1, V2, etc. Using a while loop and TABDIM we can construct the Variables for each dimension related to a cube and then use Expand to convert the string to actual valu...

There is a way to do this all in excel. You need to get familiar with the offset formula and using hidden sheets with active forms. You can use an excel drop down list that has a dynamic range as specified by your offset formula that references the hidden active forms. Users will pick the function w...

So stupid question....does this mean that a TI Process can call and run a Java application? Is that what I am hearing? Yes, you can now call java functions in TI. We were able to use Eclipse during the beta to create callable Java classes. They basically work like your existing TI functions but the...

While you cannot alter the FM package you can achieve the levels by naming them in the }HierarchyProperties control cube. Beyond that there isn't really anything you can do to modify the look and feel of the metadata model within FM. A big benefit to TM1 however is the ability to have calculated att...

Its not avaialable in 9.5.2 but in 10.1.1 and higher you can use the PublishView function in a TI. Also, all you need to do is set their rigths on the cube to Admin. I wouldn't make them temporary server admins to do this. (Just making sure this wasn't the road you were headed, it might be a licensi...

CAFE Points of Note 1. You DO NOT need to publish your cubes through FM when using the TM1 enabled version of CAFE 2. Its faster because it uses a new API to talk to TM1 which is far less "chatty" over network than Perspectives 3. CAFE conforms users into views currently rather than allowi...

Do you have a sample of what the link would look like when pointed to the .xlsx blob? I first went in and picked a .xls file then edited the back half of the string to change the folder over to }Applications\etc.\etc.\.blob.

Doesn't seem to pull up for me on login.

FYI you no longer need to peform a CellGetN to variable and then use (Value + CellGetN Variable). There is a new function as of version 10 called CellIncrementN which will peform this operation for you.

1 less line of code right!

Not sure if it's the same but we logged a bug for 10.2.1 FP2 Enterprise BI for not being able to load web sheets in iWidgets. IBM was able to reproduce and logged it with development.

EDITED, sorry slightly different issue. We were getting Java.Null.Language.Pointer when refreshing a published active form. "Already logged and accepted as a bug with IBM. They are looking to fix for RP2." COGCQ00850463, from PMR 74318,227,000 We played around with the sheet and got the er...

One last thing to be careful of. There is currently no easy mechanism to know when all TI's executed in parallel have completed. For example, if you wanted to trigger a Cognos BI Report to run after the cube was loaded, you would need a way to track the status of all the TI's that were running. Curr...

If a process encounters a major error it will quit, this is the designed behaviour and there isn't anything you can do about that. There is no equivalent (as far as I am aware) of On Error Resume Next as in VB and VBA. You can increase the tolerance for minor errors by manipulating the variables On...

I dont think you need 2 config files here. You can specify the process sections [process - process1], [process - process2] in the config file and instead of putting the process= under the [TM1RunTi] section you would specify it on the command line. This will eliminate the need for multiple files. N...

With that freedom you could use the jquery ui calendar widget , which is very cool and probably the kind of thing you are after. I've done a good bit of web development in my day and the whole jquery development platform is awesome. What I would love to see (even though it will never happen) would ...

If you are using web sheets I would think you could open up an excel file that looked like calendar through the url api. And then using the hyperlink function in the calendar area you could pass the clicked value back to the original page. Kind of a Janky way to do it but it would be interesting to ...

I dont think you need 2 config files here. You can specify the process sections [process - process1], [process - process2] in the config file and instead of putting the process= under the [TM1RunTi] section you would specify it on the command line. This will eliminate the need for multiple files. No...