TM1 Forum

Not an immediate solution, but I think the new Attribute Hierarchies might resolve this for you without rules.

I'm sure I'll be quickly corrected but I think that will be in FP4 that is due this month...

want to share some of their favourite moments as well? Other than the "Learn JAVA Programming" in 45mins? Hmmm.... I think for me it was finally seeing a little more cohesive plan from the IBM guys on where they want to take the software going forward, its just a shame that by the time th...

FYI - Can't remember if it was Ronnie or Hubert that confirmed that we'll soon be able to use REST to do the same as TM1 Top (aka. Boot user sessions from the server)

There was already a demo of a HTML based TM1 Top shown at the Conference (that just displayed the current sessions).

Dynamic or static subsets?

I noticed some odd behaviour similar to this with Dynamic Subsets...

Just be careful with DBRA, it can be a bit flakey, we've noticed that it doesn't always work, though a DBRW on the Attribute Cube works fine.

I would suggest using 1 or the other as I haven't had CAFE + Perspectives play nice together.

From my observations, you need to "Move or Copy..." the sheet you want.
That has kept the bits & pieces that you need on the new workbook...

Have you looked at the TM1 documentation at all?

As a hint, right click "Processes", select new process, select IBM Cognos TM1 "Cube View", Browse, select (or create) your view.

Then Google up "ASCIIOutput"

Hi Robin,

I agree, but this is not causing an issue with the other cubes with just as much data & the same rule.

Just seems odd that this relates to 1 cube & only with the Period consolidations

so should my "post" command use "https"?

Hi All, We have been having some performance issues with the calculation of our Year-to-Date values in our Regulatory Reporting cube. If I select a Consolidated Accounts structure + Jun 2015 YTD , the query will complete in about 1 second. If I select our Jun 2015 YTD consolidation against a leaf le...

I'm now trying to use SSL so make the connection a bit more secure. I have: Updated the tm1s.cfg with the below parameters: HTTPSPortNumber=XXXX UseSSL=T My HTML landing page is: http://myTM1Server:XXXX/tm1web/test/test.html My POST request is: https://myTM1Server:XXXX/api/v1/Cubes('Fin_GL')/Views('...

Any pointers on how to go about investigating how TM1 is handling the reallocation of memory?

From the Perfromance Monitor last night we were seeing 112GB of RAM used & 62GB of this was in Garbage (on a server with 92GB of RAM).

Hi All, Has anyone experianced the Drill to Transactions (to an MS SQL DB) to cause an increase in the Memory in Garbage? We seem to have a spike in the RAM usage about 1 week out from Month End which is when users start hammering the server with queries for their Financials & Transactions. From...

MikeF wrote:The rule works fine and gives the right results, but consolidations aren't showing the totals

How have you set up your consolidations in the .cfg file?

Have you tried to drop the "N" from the rule?

Option B!

Hi Lotsaram, The goal was to shift the store of data out of Excel and into to a central repository in TM1. We have a few templates that have "links" to other templates and recalculating can take 20mins or more to complete. My thinking is that it'd be more efficient to have this as a retrie...

So TM1 Top theoretically shouldn't exist under 10.2 either?

Interesting as it's working fine for us...

If you have a look at the Automation section of the CAFE documentation I think you might find something like what you are proposing, though there will still be a requirement to connect back to the TM1 Server (unless you want to slip in a "random number generator" in there to pull numbers f...

Hi All, I've been working with our users on some of their pain points in relation to their templates and TM1 performance came up quite often. On investigation we could see that it was quite common for the teams to have multiple spreadsheets all linking to TM1 via DBRA/DBRW formulas, with a spagetti ...

Hi All,

Has anyone managed to tweak their install process so that the TM1 Addin is activated in Excel & not the BI Addin?

Thanks,
RJ