Search found 21 matches

by sk1080in
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: 434

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't imagine ...
by sk1080in
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: 434

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...
by sk1080in
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: 434

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
by sk1080in
Mon Jan 15, 2018 1:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web showing Bold
Replies: 4
Views: 874

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 ARE NOT IN BOLD...
by sk1080in
Mon Jan 15, 2018 1:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web showing Bold
Replies: 4
Views: 874

Re: TM1 Web showing Bold

Andre_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?
Thanks Andre
by sk1080in
Fri Jan 12, 2018 12:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web showing Bold
Replies: 4
Views: 874

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...
by sk1080in
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: 1137

Re: How to Keep Active form expanded

EvgenyT wrote:Never really used it myself, but give this a try ToggleDrillState ( MDX Function )

Cheers

Evgeny
Thank you
by sk1080in
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: 1137

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 ...
by sk1080in
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: 1137

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...
by sk1080in
Tue Feb 21, 2017 11:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web Global Homepage
Replies: 6
Views: 1096

Re: TM1 Web Global Homepage

Thank you everyone, the above resolved the problem.
by sk1080in
Tue Feb 21, 2017 11:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web Global Homepage
Replies: 6
Views: 1096

Re: TM1 Web Global Homepage

gtonkin 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)
Thank you
by sk1080in
Tue Feb 21, 2017 1:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web Global Homepage
Replies: 6
Views: 1096

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 web, the home page i...
by sk1080in
Wed Sep 14, 2016 1:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web display properties
Replies: 0
Views: 436

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...
by sk1080in
Tue Feb 09, 2016 11:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web session time out
Replies: 3
Views: 845

Re: TM1 web session time out

Thanks Paul,

It is 10.2.2....Will the same solution works ?
by sk1080in
Tue Feb 09, 2016 11:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web session time out
Replies: 3
Views: 845

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.
by sk1080in
Tue Feb 09, 2016 11:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web Export to pdf
Replies: 0
Views: 442

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
by sk1080in
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: 2346

Re: MDX , create subset by value in other cube

Brilliant Solution, Thanks for that. You are a Star.
by sk1080in
Tue Mar 24, 2015 2:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX , create subset by value in other cube
Replies: 8
Views: 2346

Re: MDX , create subset by value in other cube

Thanks a lot everyone, it has worked for me. Last question...Can I pick something from between as well ? Like start from 4th Character and pick 2 Characters ?
by sk1080in
Tue Mar 24, 2015 1:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX , create subset by value in other cube
Replies: 8
Views: 2346

Re: MDX , create subset by value in other cube

Thanks a lot, it is working fine, however giving all levels of elements starting with the 3 characters selected. Can it be restricted to 0 Level only ?