TM1 Forum

Its hard to say exactly but heres what I would do roughly 1. Run backup script from scripts directory to create zip backup of PAW content stores 2. Backup paw.env file 3. Stop paw services from stop script 3. Run clean script 4. Copy paw.env file back to configuration folder of new install 5. run st...

Beware of the client front ends. Anything with TM1 formulas will break (Excel with formulas, Active Forms) In turn that means any published websheets using that cube are likely to break. You get a little lucky with BI as Cognos reports *Might* not break since you can specify the default member to be...

Your statement is a little confusing. CellGetS is only for use in TurboIntegrator. It would simply return the value of a cell based on the supplied cube and dimensions. It shouldn't be able to be used in a rule. For rules you should be using DB(). If a TI is using CellGetS and you it says you have t...

This has been pretty helpful as well. It will tell you what is and isn't supported in TM1Web by Excel Menu


http://www-01.ibm.com/support/docview.w ... wg27042154

Couple of things here 1. Im able to make it work with PAW 39. However you may want to add the extra set of [] to force the Hierarchy name just in case you use hierarchies. FILTER( TM1FILTERBYLEVEL(TM1SUBSETALL( [Organization]), 0), LEN([Organization].[Organization].currentMember.Name) > 18); 2. If y...

IBM Business Analytics Youtube Page
https://www.youtube.com/channel/UCS3gkk ... shelf_id=6

Under Planning Analytics Workspace there are currently 33 videos

Have you looked to see if you have any Anti Virus Software or any specialized logging software? I know its not TM1 but we had an issue with IBM Watson Content Analytics where some kind of logging program would get triggered when we crawled data for a collection and the server would attempt to build ...

You could request the Qlikview developer to drop data to a file for you as part of the Build Script in Qlikview. It's not very hard to do in Qlik.

Hi David The major bad point of CAM Security is that you cannot set up a user in advance. As you know the user is only created when they first sign in. Paul Simon Ahh but you can! Now that TM1 has Java Functions you can call the BI SDK to get the CAMID of any user you wish to add to TM1. This allow...

Take a look at the REST API. You can pretty easily migrate TI's by just copying the JSON from one environment and posting it to the REST API in another.

Not sure if this is the same behavior but a while back we came across something like this. Essentially if you click into an application at a subtotal level on the approval hierarchy you get a sandbox for that instance of data. You can perform some work and leave it in blue (uncommitted etc.) Now if ...

Is it not possible to pass parameters into a vb script through the use of a TI that would open your excel book change certain cells, refresh the workbook, then save the workbook in a temp location. Then after that you would call a TI process that could email attachments, (Take a look at blat.exe or ...

If im not mistaken I think the new release will be to the IBM Cloud Version of TM1 first with On Premise coming middle of next year.

FYI this kind of search can be done using the RestApi. I would recommend downloading the chrome "Advanced Rest Client" if you want to play around with it. http://tm1server:api-port/api/v1/Processes?$filter=contains(PrologProcedure, 'ViewZeroOut') or contains(MetadataProcedure, 'ViewZeroOut...

Sorry for the pseudo code, In my attempts to simplify it down it has in turn become more confusing. Here is the actual rule. This rule is part of the Consolidated Cube and it is reading data from the Capital Planning Cube. All dimensions match or are able to have a hard coded value except for the Co...

We have a cube where data is pulled from another cube based on an attribute. Something along the lines of ['Expense'] = N: DB('Cube 2', 'Element 1', ATTRS( 'Dimension2, !Dimension2, 'Source Element Name'), 'Element 3'); It would seem that in this case we would need to write a conditional feeder in o...

I believe there is also a setting on the BI Configuration for setting the default namespace. Its blank by default and I remember somewhere having trouble getting SSO to work without setting that. May want to take a look.

We logged this issue for 10.2.2 and I can confirm at least for us this is fixed with FP1

I'm not following exactly but what you want to do sounds simple to do in report studio. You should be able to create a calculated measure and then create whatever calculation you want. You can access prompt values, measures, dimensional attributes, etc. for example if you needed to multiply the meas...

This is easily done using basic excel functionality to concatenate a string that represents the BI URL you want. Read up on the BI URL API and then simply create the url and use it in the HYPERLINK function in excel. This generally only works as a websheet due to the limitation of the number of char...