Search found 117 matches

by yyi
Thu Feb 14, 2013 3:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CubeSetLogChanges - Best Practices
Replies: 11
Views: 5143

Re: CubeSetLogChanges - Best Practices

Sorry Guys, I should have elaborated further. Yes, it's true PI is on but not concerned about that because they're mostly after-hours chore(s). Object was to clean up the log files which were including logs from processes, and it made looking for real user changes difficult when the file size is rea...
by yyi
Wed Feb 13, 2013 5:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CubeSetLogChanges - Best Practices
Replies: 11
Views: 5143

Re: CubeSetLogChanges - Best Practices

:?:
If there is a while loop in the prolog with attrputs and the CubeSetLogChanges(' ',0); is in the same place - does it still log the cube changes?
by yyi
Wed Feb 13, 2013 2:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Relational drill thru - Web formatting
Replies: 6
Views: 2840

Re: Relational drill thru - Web formatting

Well, It seems there is an enhancement request with IBM that someone put in a while ago to enable websheet style edits. :o

Meanwhile, I'll just have to match the stlyle in the cell grid section using drill.css ...
by yyi
Wed Feb 06, 2013 3:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Relational drill thru - Web formatting
Replies: 6
Views: 2840

Re: Relational drill thru - Web formatting

Okay, what i've found so far is in ..\inetpub\wwwroot\tm1web folder, the page RelationalDialog.aspx has a few style sheet references; drill css01.png the drill.css seem to change stlyes for the data section (.cell{ } class) and for the rest of the page such as the data header, not sure where it is.....
by yyi
Tue Feb 05, 2013 2:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Relational drill thru - Web formatting
Replies: 6
Views: 2840

Re: Relational drill thru - Web formatting

Ow c'mon guys, there must be a way to apply styles to the dataset header (Fields). The default formats are terrible..
Relational Drill.png
Relational Drill.png (5.86 KiB) Viewed 2809 times
by yyi
Fri Feb 01, 2013 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Session timeout 30s after open a workbook !
Replies: 4
Views: 1875

Re: Session timeout 30s after open a workbook !

erm yes, well hopefully we'll get some more web discussion in this forum from now on.. meanwhile, you could try publishing the workbook to get a better indication of what's happening. i'm assuming you're opening from the navigation pane. on the web help (the link on tm1web header section) there's so...
by yyi
Fri Feb 01, 2013 9:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Setting numerous cell values using TM1 Java API
Replies: 5
Views: 2239

Re: Setting numerous cell values using TM1 Java API

Don't know how to batch send cell values. If it's slower than t.i. have you tried parsing to a table array and call tm1Chore.execute()
by yyi
Thu Jan 31, 2013 11:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Relational drill thru - Web formatting
Replies: 6
Views: 2840

Relational drill thru - Web formatting

Hi Everyone, Does anyone know how to format the page that opens when you select drill thru in tm1web? Default table format looks like Bold Times New Roman with 0 padding for header and rest being Arial Normal displayed in a bland b&w theme. Not sure if it's possible to find a style sheet to modify.....
by yyi
Fri Jan 25, 2013 4:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Tools Issues And Discussions (Was *KEY_ERR Tracer)
Replies: 63
Views: 25213

Re: TM1 Tools Issues And Discussions (Was *KEY_ERR Tracer)

just a quick thought but a different module name might work?

Code: Select all

Debug.Print Module1.ELISANC(vDim, vAnc, vDsc)
by yyi
Fri Jan 25, 2013 2:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A drill process that returns data in a CSV file?
Replies: 7
Views: 2937

Re: A drill process that returns data in a CSV file?

[msoffice driver x64, x32]
http://www.microsoft.com/en-us/download ... n&id=13255

TI ODBC to x64 DSN for csv/txt driver will give access to designated folder for SQL

eg: select top 10 * from User01.csv where ...

Hope that helps
by yyi
Mon Jan 14, 2013 5:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SAP Newbie
Replies: 2
Views: 3449

Re: SAP Newbie

Thank you moby91

Looks like a lot of reading to do and also need to make more friends with IT, ECC and dept controlling Cognos 8.4.
Just downloaded package connector and need other parts to get a connection going...
by yyi
Wed Jan 09, 2013 6:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SAP Newbie
Replies: 2
Views: 3449

SAP Newbie

Hi Everyone, Does anyone know the 1st steps to establish connection to SAP (ECC 6.0) using TI ? There seem to be some posts relating to people who are already running queries but nothing for people who have only used text file, odbc [system dsn] or none. And i've had a look at the FAQ as well (Thank...
by yyi
Wed Jan 09, 2013 12:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel ODBC drivers in 64 bit Tm1 9.5.2 Server
Replies: 7
Views: 6394

Re: Excel ODBC drivers in 64 bit Tm1 9.5.2 Server

Hi I think there is 64-bit ODBC driver for Excel, you can download it from here: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255 It seems the 64-bit ODBC driver(s) for Excel and other MS Office programs will work as long as there is no 32-bit Office on the same machine. Th...
by yyi
Tue Jan 08, 2013 6:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Squished subset elements
Replies: 4
Views: 1363

Re: Squished subset elements

thanks for links Robin & Michel!

i couldn't think of a search string that described what was happening
by yyi
Tue Jan 08, 2013 5:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: executecommand() with batch files
Replies: 29
Views: 19077

Re: executecommand() with batch files

vCommandLine = 'E:\path of success.bat';
also noticed that your command line doesn't have "cmd /c " before the "E:\*.bat"
i found on my instance, it needs the prefix before the path & bat file name
by yyi
Tue Jan 08, 2013 5:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Squished subset elements
Replies: 4
Views: 1363

Squished subset elements

Hi Everyone, :?: Has anyone encountered this problem when opening up the subset editor from server explorer (ver 9.5.2) subset_squished.png and when the user clicks on the green tick, tm1 perspectives and excel crashes with no error message(s). it's currently limited to one particular machine which ...
by yyi
Thu Jan 03, 2013 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ELISANC Worksheet Function
Replies: 5
Views: 4021

Re: ELISANC Worksheet Function

Original author's zip attachment is a blank worksheet with "Elisanc()" function written in the module [Alt-F11] my additional code can be used by substituting/putting in 1. your dimension name 2. your alias 3. a cell name "n_Level" somewhere on the sheet for the descendant 4. a cell name "v_Consol" ...
by yyi
Thu Jan 03, 2013 4:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ELISANC Worksheet Function
Replies: 5
Views: 4021

Re: ELISANC Worksheet Function

Thank You, and here's some additional vba to list all the parents in between ancestor and descendant: (so it can paste into subset editor) Public vDim As String, vAnc As String, vDsc As String, vPar As String, vTree() As String Sub build_up_single_hierarchy() Dim c As Excel.Range, nPar As Integer, i...
by yyi
Tue Oct 23, 2012 4:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCII Output formatting question
Replies: 5
Views: 2009

Re: ASCII Output formatting question

# take out double quotes
# use semi-colon instead of comma
DatasourceASCIIQuoteCharacter='';
DatasourceASCIIDelimiter=';';


Thanks for the posts everyone!
by yyi
Tue Jul 17, 2012 1:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementAttributes_Dept N:numeric attribute not working
Replies: 6
Views: 4304

}ElementAttributes_Dept N:numeric attribute not working

I might just be missing something really simple, but a rule in an element attribute cube on a numeric element compiles but is showing nothing, cells are not grey and trace calculation doesn't work !? And all the string attribute rules are fine:- eg: string attribute rule - okay ['dept01', 's_attr01'...