What is the full custom number format for making zero values display the symbol "-" in TM1?
thks!
Search found 51 matches
- Mon Oct 26, 2020 6:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Custom Number Format to Make Zeros display -?
- Replies: 4
- Views: 1999
- Wed Sep 20, 2017 2:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Feed this Rule ??? pls help!!!
- Replies: 3
- Views: 2760
How to Feed this Rule ??? pls help!!!
DEAR ALL,
Cube1:
Dim1,Dim2;
Cube2:
Dim1,Dim2,Dim3,Dim4;
Rules in Cube2: [] = N: DB('Cube1',!Dim1,!Dim2);
How to feed the above rule in Cube1 rule?
TKS 4YOUR Help!
Cube1:
Dim1,Dim2;
Cube2:
Dim1,Dim2,Dim3,Dim4;
Rules in Cube2: [] = N: DB('Cube1',!Dim1,!Dim2);
How to feed the above rule in Cube1 rule?
TKS 4YOUR Help!
- Wed Mar 22, 2017 9:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process compile error
- Replies: 3
- Views: 3122
TI Process compile error
Dear all,
I use the function of "CubeRuleAppend", but a compile error show when save the TI Process, anny one who knows the resean?
thks
I use the function of "CubeRuleAppend", but a compile error show when save the TI Process, anny one who knows the resean?
thks
- Mon Nov 28, 2016 1:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web can not get TM1 Server after the SSL upgrade
- Replies: 10
- Views: 6682
Re: TM1Web can not get TM1 Server after the SSL upgrade
I tried a variety of ways, still can not get the server list, very sadddddddddd
- Fri Nov 25, 2016 9:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web can not get TM1 Server after the SSL upgrade
- Replies: 10
- Views: 6682
Re: TM1Web can not get TM1 Server after the SSL upgrade
oh TM1 version:10.1, thanks.gtonkin wrote:please confirm the version of TM1 you are experiencing this issue on.
- Fri Nov 25, 2016 3:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web can not get TM1 Server after the SSL upgrade
- Replies: 10
- Views: 6682
TM1Web can not get TM1 Server after the SSL upgrade
Dear All,
In accordance with the IBM document, the upgrade of the SSL, i can log in to server througth the Achitect, but there is a problem, access to TM1Web, can not get any TM1 Server in the droplist.
TM1 Version : 10.1
OS: Win2003
Web is IIS
Tks for all your help!!!!
In accordance with the IBM document, the upgrade of the SSL, i can log in to server througth the Achitect, but there is a problem, access to TM1Web, can not get any TM1 Server in the droplist.
TM1 Version : 10.1
OS: Win2003
Web is IIS
Tks for all your help!!!!
- Mon Oct 17, 2016 6:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: can not display dimension name in cube viewer
- Replies: 0
- Views: 1478
can not display dimension name in cube viewer
Dear all,
recently, when I open the cube view, I found that the title position dimensions could not be display in cube viewer, the bellow screenshot.
TM1 version is 9.5.2
Thanks for your help!!!
recently, when I open the cube view, I found that the title position dimensions could not be display in cube viewer, the bellow screenshot.
TM1 version is 9.5.2
Thanks for your help!!!
- Wed Apr 08, 2015 9:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process to Allocate Account Balances
- Replies: 3
- Views: 4580
Re: TI Process to Allocate Account Balances
There is a picture about allocation design in my project, i think it coult help you.
- Mon Mar 23, 2015 9:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Active Form error
- Replies: 1
- Views: 2421
TM1 Active Form error
Dear All, I has created several of active form reports in excel sheets, but some times, when double click the consolidation element for show all of the elements, the excel stop working, with the error windows pop-up.Just like the attachment image. TM1 version is 9.5.2 and the excel version is 2010. ...
- Thu Jan 15, 2015 1:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Write the feeders for this special Rules
- Replies: 3
- Views: 4522
Re: How to Write the feeders for this special Rules
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 conso...
- Wed Jan 14, 2015 12:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Write the feeders for this special Rules
- Replies: 3
- Views: 4522
How to Write the feeders for this special Rules
Dear All, A question about Feeders, there is a Cube Names Cube1, Dimension: Pro_Company, Sal_Company, Product, Year, Month, Account. Elements Pro_Company: Total Company Company A Company B Company C Sal_Company: Total Company Company A Company B Company C OutSale Account: Amount --------------------...
- Wed Nov 19, 2014 7:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to write the Rules for the latest non-zero value
- Replies: 1
- Views: 2253
How to write the Rules for the latest non-zero value
Dear all,
I have a Cube of Cost Price by month, some of months, the cost price is zero, but i need the latesst non-zero price for the calculation, just like the ATTACHMENTS.
How to write the Rules for the Calc Price?
ths!
I have a Cube of Cost Price by month, some of months, the cost price is zero, but i need the latesst non-zero price for the calculation, just like the ATTACHMENTS.
How to write the Rules for the Calc Price?
ths!
- Mon Nov 17, 2014 3:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Same name in two dimesions
- Replies: 2
- Views: 3097
Same name in two dimesions
Hi all,
How to write the TM1 Rules, when same element name in two dimensions in one cube?
How to write the TM1 Rules, when same element name in two dimensions in one cube?
- Tue Nov 04, 2014 8:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: how to force the cubes don't run automatically
- Replies: 7
- Views: 4866
Re: how to force the cubes don't run automatically
If we talk about the time it takes to just log in to TM1 using a pure TM1 interface, then Load on demand has no effect on it. This parameter simply moves the cube load time from server startup phase to the point when you try to open the cube (the click/double click on the cube ). Furthermore, if I ...
- Tue Nov 04, 2014 8:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: how to force the cubes don't run automatically
- Replies: 7
- Views: 4866
Re: how to force the cubes don't run automatically
tks for your help!!
- Tue Nov 04, 2014 7:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: how to force the cubes don't run automatically
- Replies: 7
- Views: 4866
how to force the cubes don't run automatically
Dear all, I have one question: There is a TM1 system which has 128 cubes built in, when I try to log in, it takes more than 2 minutes to load those cubes, I just wondering that is it any method to force those cubes do not automatically loading, only when I click the cube it starts loading instead. T...
- Sun Jun 08, 2014 7:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 API for C# .NET
- Replies: 1
- Views: 2320
Re: TM1 API for C# .NET
I had fixed this problem, if C# using the API functions in "Applix.TM1.API.dll", we must add the dll file of "log4net.dll" for this application.
- Fri Jun 06, 2014 11:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 API for C# .NET
- Replies: 1
- Views: 2320
TM1 API for C# .NET
Dear All, I'm learning the C#.NET recently, but a problem obstruct me. Thera a simple code for TM1AdminServer Object initialization. TM1AdminServer admin = new TM1AdminServer("", "tm1adminserver"); But, when application run this code, a exception threw. “Applix.TM1.API.TM1AdminSe...
- Mon May 26, 2014 1:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI error with the csv file datasource
- Replies: 4
- Views: 3730
Re: TI error with the csv file datasource
Dear All, I beated by a strange error from TM1 Process. Its a simple process, data source is csv file, the file localed in a LAN PC, TM1 process colud preview the data, but, when i run the process with admin account in TM1, a error popped, Colud not open the datasource. Please help me with this, th...
- Fri May 23, 2014 8:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI error with the csv file datasource
- Replies: 4
- Views: 3730
TI error with the csv file datasource
Dear All, I beated by a strange error from TM1 Process. Its a simple process, data source is csv file, the file localed in a LAN PC, TM1 process colud preview the data, but, when i run the process with admin account in TM1, a error popped, Colud not open the datasource. Please help me with this, tha...