Search found 5 matches

by lemon103
Wed Feb 20, 2013 6:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export to Excel
Replies: 4
Views: 5644

Re: Export to Excel

We are running into the same issue on TM1Web after 9.5.2 FP3 upgrade.
Do you mind sharing how this was resolved? (if it was)
by lemon103
Fri Feb 05, 2010 2:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX subset sort by Alias
Replies: 9
Views: 29839

Re: MDX subset sort by Alias

I am defining the subset dynamically by TI Process.
SubsetAliasSet cannot run before SubsetCreateByMDX because the Subset would not exist yet.
And running SubsetAliasSet after SubsetCreateByMDX does not have an impact.
by lemon103
Thu Feb 04, 2010 4:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX subset sort by Alias
Replies: 9
Views: 29839

MDX subset sort by Alias

Hi All, I am trying to create a MDX subset sorted by an Alias. It seems the ORDER MDX function works for every attribute EXCEPT the aliases. i.e. ORDER({[Employee].Members}, [Employee].ZipCode , BASC) works but ORDER({[Employee].Members}, [Employee].FullName, BASC) where FullName is an alias does no...
by lemon103
Tue Feb 02, 2010 4:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Navigate Application Folder via VB API
Replies: 2
Views: 2814

Re: Navigate Application Folder via VB API

You are totally correct.
I got it working now.
Thanks!
by lemon103
Tue Feb 02, 2010 2:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Navigate Application Folder via VB API
Replies: 2
Views: 2814

Navigate Application Folder via VB API

Hey Guys, I am looking for sample code to download and open Excel workbooks posted on the Application folder. I have already figured out how to download a BLOB from the }Externals folder and open it as an Excel file if I know the filename. But the problem is to figure out what the filename is in the...