TM1 Forum

Thank you so much for this postings. It's very helpful. It worked for me when I changed the Visible to "0-xlSheetHidden" on the "Cognos_Office_Connection_Cache" which was not visible. It only shows on the VBA window of Developer menu.

Thanks. I see some add-ins subfolder under the Addins folder that you referenced, i.e. Power Map Excel Add-in, Power View Excel Add-in, PowerPivot Excel Add-in. Under each of those folders, there are verious .DLL files. I am not good enough to understand what are those .DLL files are for, and how ar...

Thank you, Paul.

Can you provide more details for me to check? Where can I find the AddIns folder?

Thanks,
Phong Nguyen

Hi: I am installing TM1 Perspectives. When I do the Excel Add-in, after I map the IBM Cognos TM1 Perspectives (in the Excel Add-ins window) to tm1p.xla file, I got the message "can't find DLL entry point LoadLibraryA in Kernel32.dll". The TM1 Add-in does not show in Excel. I tried deleting...

Thanks Wim. When I set vAccountLastRow = '' in the Prolog, now all rows have blank in the account columns. Below is the asciioutput file. "","t "," ","Period N","ame "," FIN CNF US" "","----","-- ","------...

Thank you so much Steve!

Sorry for being so new at TI coding. It gives me an error that I also need to define vAccountLastRow. I think that because the code
vAccountThisRow=If (vAccountThisRow@='' , vAccountLastRow , vAccountThisRow);
is at the start of the data tab.

Thanks again!

Hi, I am using Perspectives, version 10.2.2. I am working on a data file that has blank / repeating value on the Expense Account column, see example below. I would like to write a TI code to have those blank rows to have the same value as the row above, until it see a new value, i.e. from Feb-2018 t...