TM1 Forum

Hi all,

Thank you for your help, much appreciate.

Thanks and Best Regards,
Yukiya

Hi Alan, Thank you for your advice. We have two cubes (one is Revenue and another is Combination). Revenue contains Location, Product, Year and Month as dimension and Combination (this contains Location and Product as dimension) hold Entity. I need to build another cube RevPerEntity and it contains ...

Hi all, We have two cubes (Cube A and B). Cube A contains D1, D2 and D3 dimensions and Cube B contains D4 which is combination of D1 and D2. I need to build another cube (Cube C) and it contains D1, D2 and D4. I tried to set [!D1, !D2, D4:DBRW(B, !D1,!D2)]=N:DB(A,!D1,!D2); in Rules Sets of Cube C, b...

Hi there, We are using TM1 10.1.1 and I'm investigating features of TM1 10.2. I understand we cannot use Cognos Insight if InteguratedSecurityMode in our configuration file (tm1s.cfg) is 2 (IBM support team advised to me it should be 1). Users wish to use integrated login (IntegratedSecurityMode=2) ...

I had a same error when I install TM1 to Windows 7 32 version, and I resolve it using by following procedures. 1. Run cmd 2. Execute regedit 3. Find below key and delete it: HKEY_CURRENT_USER\SOFTWARE\Classes\CLSID\{ B54F3741-5B07-11CF-A4B0-00AA004A55E8} 4. Back up it 5. Delete it Hope your problem ...

Dear all,

Thank you for your reply.

Regards,
Yukiya

Hi Martin,

Thank you for reply.

This problem is when we uninstall TM1 9.0.1 on Windows 7 environment.

Does anyone have an idea?

Regards,
Yukiya Ishimaru

Hi there,

When I uninstall TM1 9.0.1 from Windwows 7, I got an error 1720.
So, does anyone know how to uninstall it without error?

Regards,
Yukiya Ishimaru

Hi there,

I found Hotfix 12 (both of server and client) and Hotfix 13 prerelease on download site, however there is no details.

Does anyone have details on Hotfix 12 and Hotfix 13?

Thanks,

Hi Martin,

Thank you for your quick response.

I already read it, and renamed tm1RibbonX.xlam due to another problem (I had a same problem of post: http://forums.olapforums.com/viewtopic. ... 96&p=11954) before renamed it.

Any suggest?

Hello, We are using TM1 9.0.1 currently, and upgrading to TM1 9.5.1. I developed reporting tool on Excel with VBA, and about one hour and half is spent to create 125 reports on TM1 9.5.1, however about four hours is spent for same reports on 9.5.1 (even though I test them on same PC). Does someone h...

Dear all,

Thank you very much for your advice.

Regards,

Yukiya

There is not an information of TM1 9.5.1 with SQL 2000 (SQL 2000 is compatible database with TM1 9.5) in required Software Environment at IBM web site.

So, does someboby use TM1 9.5.1 with SQL 2000?

Regards,
Yukiya Ishimaru

Dear all,

Thank you very much for your advice.

Regards,

Hi there,

We have a plan to upgrade TM1 next year.
I found latest stable version of TM1 is 9.5 at Wikipedia, however I found some negative comments at topic about 4 months ago.
So, could someone please tell us which version is a most stable version?

Thanks and Best Regards,
Yukiya Ishimaru

Hello, I've tried to automatically run a macro on Excel file with Macro which contains "In Spreadshee Browser". At the moment, we have to press the cube button before running a macro, and we'd like to apply it into macro. So, could you kindly tell me how to apply updating process into macr...

Dear Rizwan,

Thank you for your great advice.
I could setup a rule.

Yukiya

Hello, I could not save a rule due to ambiguous. It has some dimensions (for example, year and staff code, location, etc.), and year and staff code have same element. When I tried to save a rule on Rules Editor with year, TM1 warned as ambiguous of both of SKIPCHECK and FEEDERS - element of year and...

Dear Andy,

Thank you for your great advice.
I could setup ELISANC function on Excel using attachment file.

Hi all, There is ELISCOMP formula to check existing parent element on Excel, however I'd like to know any formula which check grandparent element on it. For example, there are three element (Sydney, NSW, Australia) and Australia is consolidated of NSW, NSW is consolidated of Sydney. In this case, EL...