Search found 23 matches
- Mon Jun 21, 2021 12:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to access Instance within Server after restart
- Replies: 3
- Views: 3153
Re: Unable to access Instance within Server after restart
Thank you Alan, I will update now....Issue stands resolved...Was accidently using wrong admin host...
- Sun Jun 20, 2021 11:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to access Instance within Server after restart
- Replies: 3
- Views: 3153
Unable to access Instance within Server after restart
I access TM1 through User ID and Password. After restarting the service by logging on the server, I am able to access the Instance from client machine with same ID and password, however unable to access the instance within server. I am using the same ID and password at both places. Do you know why w...
- Mon Dec 17, 2018 10:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to get all table names on ODBC connection
- Replies: 7
- Views: 6459
Re: How to get all table names on ODBC connection
I would also use some client tools to connect to the database but if you only have TI then use it. "Only having TI" is a very rare if ever occurrence. There are numerous lightweight SQL IDEs which don't require install. And in those very locked down environments such as large banks I can'...
- Mon Dec 17, 2018 10:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to get all table names on ODBC connection
- Replies: 7
- Views: 6459
Re: How to get all table names on ODBC connection
I would also use some client tools to connect to the database but if you only have TI then use it. I use the following: SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES Should return the tables then you can use: SELECT Column_Name FROM INFORMATION_SCHEMA.COLUMNS Where Table_Name='<tablename>' Thank...
- Mon Dec 17, 2018 12:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to get all table names on ODBC connection
- Replies: 7
- Views: 6459
Re: How to get all table names on ODBC connection
Thank you Wim
- Mon Dec 17, 2018 12:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to get all table names on ODBC connection
- Replies: 7
- Views: 6459
How to get all table names on ODBC connection
Hi,
Is there a way to get all table names in Turbo Integrator Process by selecting ODBC as datasource type ? I have few queries already working, however need to explore more tables but donot know the name of other tables.
Thanks you
Is there a way to get all table names in Turbo Integrator Process by selecting ODBC as datasource type ? I have few queries already working, however need to explore more tables but donot know the name of other tables.
Thanks you
- Mon Jan 15, 2018 1:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web showing Bold
- Replies: 4
- Views: 4010
Re: TM1 Web showing Bold
If it's not a formatting problem then I wonder if it's http://www.ibm.com/support/docview.wss?uid=swg1PI91427&myns=swgimgmt&mynp=OCSS9RXT&mync=R&cm_sp=swgimgmt-_-OCSS9RXT-_-R ? The heading is : PI91427: TM1 WEB SHOWS IN BOLD SOME LINES OF A WEBSHEET WHILE IN PERSPECTIVES THOSE LINES...
- Mon Jan 15, 2018 1:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web showing Bold
- Replies: 4
- Views: 4010
Re: TM1 Web showing Bold
Thanks AndreAndre_Wium wrote: ↑Fri Jan 12, 2018 6:00 am Is it a worksheet using an Active Form? If so, have you checked the formatting definitions for that Active Form?
- Fri Jan 12, 2018 12:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web showing Bold
- Replies: 4
- Views: 4010
TM1 Web showing Bold
Hi, I have multiple worksheets in a workbook and all worksheets except one is correctly displaying the values (DBRWS). The issue is everything on the this worksheet is coming bold. I have tried various methods, bolding and unbolding again and updating on tm1 web, however this particular worksheet st...
- Fri Apr 21, 2017 11:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Keep Active form expanded
- Replies: 4
- Views: 3679
Re: How to Keep Active form expanded
Thank youEvgenyT wrote:Never really used it myself, but give this a try ToggleDrillState ( MDX Function )
Cheers
Evgeny
- Fri Apr 21, 2017 11:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Keep Active form expanded
- Replies: 4
- Views: 3679
Re: How to Keep Active form expanded
Does that TM1RPTROW formula use a subset, an MDX statement, or did you just leave the dimension selections in the hidden {AR} tab? If you just left it pointing to the hidden tab then every time you open the sheet it's going to default back to the elements in that tab. It's best to base the formula ...
- Fri Apr 21, 2017 6:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Keep Active form expanded
- Replies: 4
- Views: 3679
How to Keep Active form expanded
Hi, I have a Active form and the dimension used in TM1RPTROW has 3 consolidation level. Like All Employees - Direct / Indirect - Location.....Employee name I have published this on TM1 web and the need is to print this report by a subset, Which is nicely working as well. However the issue is that th...
- Tue Feb 21, 2017 11:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web Global Homepage
- Replies: 6
- Views: 4452
Re: TM1 Web Global Homepage
Thank you everyone, the above resolved the problem.
- Tue Feb 21, 2017 11:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web Global Homepage
- Replies: 6
- Views: 4452
Re: TM1 Web Global Homepage
Thank yougtonkin wrote:Looks like you are missing the "TM1:" in front of your websheet reference. Your slashes also look to be back, not forward.
Have a look here for some guidance (10.2.2 reference)
- Tue Feb 21, 2017 1:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web Global Homepage
- Replies: 6
- Views: 4452
TM1 Web Global Homepage
Hi, I am trying to set a global homepage in TM1 Web and using the below: <add key="HomePageObject" value="\\TM1Server\D$\TM1\TM1_Instance\DATA\}Externals\01NetPay.xlsx_20160610012458.xlsx;Type=websheet;Description=My Uploaded websheet;AllowOverwrite=false" /> When I login in TM1 ...
- Wed Sep 14, 2016 1:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web display properties
- Replies: 0
- Views: 1369
TM1 Web display properties
Hello, In the applications folder when I right click on one of the worksheets (Which is also published on TM1 web) to show the properties, In the display properties section, it shows the title dimensions and cell address. Can anybody help me to understand how to change it, or how the title dimension...
- Tue Feb 09, 2016 11:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 web session time out
- Replies: 3
- Views: 3423
Re: TM1 web session time out
Thanks Paul,
It is 10.2.2....Will the same solution works ?
It is 10.2.2....Will the same solution works ?
- Tue Feb 09, 2016 11:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 web session time out
- Replies: 3
- Views: 3423
TM1 web session time out
Hi,
Can anybody help me of what should be changed to increase the session timeout for TM1 web and what would be the steps to change it.
Thanks.
Can anybody help me of what should be changed to increase the session timeout for TM1 web and what would be the steps to change it.
Thanks.
- Tue Feb 09, 2016 11:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Web Export to pdf
- Replies: 0
- Views: 1437
TM1 Web Export to pdf
Hi,
When exported as snapshot or slice from TM1 web and then print to pdf from exported excel workbook..all works fine.
However, when same report is exported by using export to pdf in TM1 web directly... The formatting does not works correctly.
Can anybody suggest what can be wrong.
Thanks
When exported as snapshot or slice from TM1 web and then print to pdf from exported excel workbook..all works fine.
However, when same report is exported by using export to pdf in TM1 web directly... The formatting does not works correctly.
Can anybody suggest what can be wrong.
Thanks
- Tue Mar 24, 2015 10:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX , create subset by value in other cube
- Replies: 8
- Views: 6205
Re: MDX , create subset by value in other cube
Brilliant Solution, Thanks for that. You are a Star.