Search found 168 matches

by AmbPin
Tue Jul 02, 2013 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Converting to Static Excel Perspectives Report
Replies: 3
Views: 1531

Re: TM1 Converting to Static Excel Perspectives Report

Hello,
You can do this by:-
  • Select all cell in the Excel sheet
  • Copy all cells (Ctl-C)
  • Paste Special, Just the values
  • Paste Special, all formatting
You could record and tweak a macro to do this for you.
by AmbPin
Tue Jun 25, 2013 10:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alias not unique (TI)
Replies: 12
Views: 4073

Re: Alias not unique (TI)

Hello, Are you trying to change the value of the alias? If so then you may be being caught out by an alias that is still in use by another element. Consider the following simple dimension:- Element - Alias Year1 - 2012 Year2 - 2013 If I wanted to increment one year forward then you might try this in...
by AmbPin
Mon Jun 10, 2013 9:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hyperlink TM1 Web format
Replies: 11
Views: 3991

Re: Hyperlink TM1 Web format

Hi Andy,
Thanks for the tip. You can get around this limitation with some Excel functions by concatenating strings but this does not work for the Hyperlink function.
by AmbPin
Fri Jun 07, 2013 11:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hyperlink TM1 Web format
Replies: 11
Views: 3991

Re: Hyperlink TM1 Web format

Wow thanks Declan, I had not seen this page before:- http://pic.dhe.ibm.com/infocenter/ctm1/v9r5m0/topic/com.ibm.swg.im.cognos.tm1_dg_dvlpr.9.5.2.doc/tm1_dg_dvlpr_id10087SelectingTitleElementsforaWebsheetO.html#SelectingTitleElementsforaWebsheetObject_N905A3 I foresee hours of fun/frustration playin...
by AmbPin
Fri Jun 07, 2013 9:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hyperlink TM1 Web format
Replies: 11
Views: 3991

Re: Hyperlink TM1 Web format

I agree, picklists probably are the way to go instead of the subnm, but I don't see how would you tell the target application that "item Code A" was selected if the user clicked on a £100 hyperlink. We have done similar using an action button linking title elements but would love to know how to do t...
by AmbPin
Fri Jun 07, 2013 8:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hyperlink TM1 Web format
Replies: 11
Views: 3991

Re: Hyperlink TM1 Web format

Hi Declan,
That sounds really clever. So in my simple example below, you would have a hidden dbsa that sends back the value of the company subnm, but if the user clicked on the £100 hyperlink how do you tell the recieving sheet that the user selected Item Code a?
by AmbPin
Fri Jun 07, 2013 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 applications, Active sheet, “Action button” properties,
Replies: 7
Views: 1886

Re: TM1 applications, Active sheet, “Action button” properti

Hello,
Are you saving xls files or xlsx. If the latter then, if I remeber correctly, they are not displayed when you browse the list but you can type in the address/name.
by AmbPin
Thu Jun 06, 2013 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hyperlink TM1 Web format
Replies: 11
Views: 3991

Re: Hyperlink TM1 Web format

Hello,

You could use the text function wrapped arounf your dbrw:-

=hyperlink(A5, TEXTDBRW(stuff), format))
by AmbPin
Tue Jun 04, 2013 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rules Security in Server Explorer
Replies: 2
Views: 436

Re: TM1 Rules Security in Server Explorer

Hello,

Can the user actually save the changes? in my 9.5.2 world a test user with no privelidges can open the rules editor and make changes but cannot save (or delete) them.
by AmbPin
Mon May 20, 2013 8:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web - Error 149 - Write access denied
Replies: 1
Views: 876

Re: TM1 Web - Error 149 - Write access denied

Hello,
Is the "the other user having the same access" in all of the same groups?

I have had issues (exactly what I cant remember) with particular user accounts which seem to be cleared by deleting the account and re-creating.
by AmbPin
Mon May 13, 2013 8:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading data into TM1 using element Attributes
Replies: 8
Views: 1893

Re: Loading data into TM1 using element Attributes

Hello Jodha,
Based on the information you have provided, the approach that declan has suggested would seem to me be the best approach. Is there some reason, that perhaps is not described in your original post, that means you are looking for an alternative method?
by AmbPin
Tue May 07, 2013 12:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: More visibility into TI processes
Replies: 5
Views: 1195

Re: More visibility into TI processes

Ah yes I see.
Even having a chore with an about to start and about to finish task at each end wont help because as you say the chore in that case is the transaction wrapper.
by AmbPin
Tue May 07, 2013 10:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: More visibility into TI processes
Replies: 5
Views: 1195

Re: More visibility into TI processes

Will the users be able to refresh the websheet whilst processes are running ?
I see no reason why users who did not start the process would be able to. The user who did start the process may also be able to view from another tab or browser window.
by AmbPin
Tue May 07, 2013 7:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: More visibility into TI processes
Replies: 5
Views: 1195

Re: More visibility into TI processes

Hello,
One way you could achieve this is to have a simple cube which you update as your TI processes start, progress and end. You could have a TM1 web sheet pointed at this cube to enable users to see a snapshot of what processes are running and they are progressing.
by AmbPin
Fri May 03, 2013 7:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turbo Integrator snapshot to Excel
Replies: 14
Views: 4610

Re: Turbo Integrator snapshot to Excel

I agree with tomok. A well thought out Excel sheet will give you the best user experience and provide the opportunity to interact further with that data should people wish to perform further investigation of the high level results presented.
by AmbPin
Wed May 01, 2013 9:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Dynamic Subset using an attribute in another dimension
Replies: 10
Views: 5308

Re: MDX Dynamic Subset using an attribute in another dimensi

Hello, I came across this thread whilst looking for help on a similar challenge. I have a simple Assets cube and have created an MDX filer to show just those assets that have been disposed of this month. Filter( { TM1FilterByLevel( { TM1SubsetAll( [Asset] ) } , 0 ) } , [Assets].( [Asset Type].[????]...
by AmbPin
Wed May 01, 2013 9:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turbo Integrator snapshot to Excel
Replies: 14
Views: 4610

Re: Turbo Integrator snapshot to Excel

Hello, I was thinking about this from your earlier post:- Therefore a snapshot takes ALOT less time to generate on demand I assume you mean generating a snapshot to Excel from a cube view. I may be completely wrong here but I would have thought that the work involved for TM1 in the initial generatio...
by AmbPin
Wed May 01, 2013 9:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1web problem with IE 10
Replies: 4
Views: 1374

Re: Tm1web problem with IE 10

Hello,
I note that your profile info says you are using v.9.4. I dont think that is compatible with IE9 let alone 10. We are on 9.5.2 and have issues where people have IE9.
by AmbPin
Tue Apr 30, 2013 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turbo Integrator snapshot to Excel
Replies: 14
Views: 4610

Re: Turbo Integrator snapshot to Excel

Without knowing some more detail it is difficult to help but Could you put weekly consolidations in your time dimension Calculate the latest weeks consolidation in the spreadsheet/websheet An alternative approach might be to build a reporting cube with weekly slots that is populated via TI from your...
by AmbPin
Tue Apr 30, 2013 7:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turbo Integrator snapshot to Excel
Replies: 14
Views: 4610

Re: Turbo Integrator snapshot to Excel

Hello, I think you may be jumping ahead a little considering API programming and data exports at this stage. The requirement you have described (as I understand it) seems to be fundamental TM1/Excel functionality as suggested by lotsaram. My suggestion would be Build a report in Excel that shows the...