TM1 Forum

We use something like this #.\hot_promote_process.ps1 my_process_name DEV UAT PATCH $processName =$args[0] $sourceEnv =$args[1] $targetEnv = $args[2] $method = $args[3] function Set-Header { param ( $EncodedText ) $header = @{ "Content-Type"="application/json; odata.metadata=none; oda...

Hello, We have a simple Powershell script to hot promote TI processes, and am looking to implement something similar for dimension metadata. I'm looking to replicate a dimension between 2 services using the REST API as opposed to TI. It should be an exact copy, including attributes. Does anyone know...

Just in case anyone's interested, I worked out how to remove the attributes property via Powershell: ... $response = Invoke-WebRequest -Uri $url -Method Get -Headers $header $x = $response.content | ConvertFrom-Json $x = $x | Select-Object * -ExcludeProperty Attributes $body = $x | ConvertTo-Json $u...

Yes, these are lost so need to be re-added, which is probably more work than removing the attributes property from the body.

Another solution I have found is to simply delete the existing process from the target server and then re-add: $url = $url = "http://${targetServer}:${TargetPort}/api/v1/Processes('$processName')" $header = Set-Header $targetUser $targetPass $response = Invoke-WebRequest -Uri $url -Method ...

File semaphores is what I use currently to control a parent process. I believe I read about using adding/removing attributes or elements and tested it a few years back, but never used in production. The file semaphores seem to work well enough. Wasn't there a post the other day about some additiona...

Has anyone else experienced issues with Perspectives functions in PAfE? We have a fairly large function dimension and it takes ~ 10 seconds for a single retrieve. My alternative REST API query is much faster. Existing IBM query: http://server:port/api/v1/Dimensions%28%27dimension%27%29/DefaultHierar...

Managed to figure it out: PATCH request: api/v1/Cubes('xxx') Body: {"Rules": "this is an error"} Response: { "@odata.context": "$metadata#Cubes/$entity", "@odata.etag": "W/\"e8d228a6c97159561df48d9ecf2a4c71a1a657b6\"", "Name&...

Hi All, I've worked out how to validate the existing or new rule for a cube, but can't find where in the documentation it shows how to attach. Does anyone know the function? request: api/v1/Cubes('xxx')/tm1.CheckRules body (blank to check existing rule): {"Rules": "this is an error&qu...

Hi Michael,

Thanks very much for the detailed explanation, and the FriendlyName suggestion which is a better solution that I had: Thanks,

Dan

Hi All, I'm having an issue with a query to get a user's default display alias: } escaping to %7D api/v1/Dimensions('}Clients')/Hierarchies('}Clients')/Elements?$select=Attributes/%7DTM1_DefaultDisplayValue { "error": { "code": "278", "message": "Unsuppor...

I have found a sample: modCreateCubeFromFile that seems to have all the necessary functionality I require.

We have a problem with sending data from Excel to TM1 as I believe the limit of the DBS/ DBSS formulae is 16 dimensions and we have some cubes with more. A few options are being discussed presently: Tm1Tools and use DBRW to copy/ paste UDF using REST API to write the data UDF using classic API to wr...

Hi guys, We're experiencing an issue with an older client version connecting to PA 2.0.4. We have a set of certificates that works perfectly when using perspectives or architect however we are using the VBA API to connect: TM1SystemServerConnectWithCAMNamespace and this is not working. Is there a wa...

My guess is that the stats cubes only start to get populated after the server has loaded and the startup chore has run, which makes sense to me. I would try running a nested TI process from the chore via tm1runti.exe and have the nested process do the waiting. TI process that's part of startup chore...

Try turning your calculations to manual in Excel:

Formulas -> Calculation Options -> Manual.

You can then manually calculate your spreadsheet by pressing F9

Did you read through the article? You should read it and make sure you understand it otherwise you're going to get stuck when trying to write rules with any kind of complexity. Your rule is a very simple one, something like: SKIPCHECK; [‘Sal_Company’:’OutSale’] = N: ['Pro_Company':'Total_Company’]; ...

You don't necessarily need to write your rule using a DB function as it's not an inter-cube rule and you're not using any functions within the DB. You can feed from a consolidation (i.e. Total_Company), which is the same as writing individual feeders for each of the node level children of the consol...

There are a few considerations here. If you keep track of how many months you've loaded for each year in a separate cube, you can reference this denominator using a DB() function in place of your hard-coded 12. Alternatively you can create a new measure to keep track of whether Revenue_meas1 is non-...

HI, We have it working in 10.2 FP2: "D:\Program Files\ibm\cognos\TM1_10_2_64_DEV\bin64\tm1runti" -i "D:\xxx\tiprocess.config" -connect instance_label -process cube_clear_view psCube="xxx" psMonth="2014_01" tiprocess.config contains the following information: [...