Search found 12 matches

by 4rtem
Thu Jan 19, 2017 11:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wait:IXCur on user login during TI data load
Replies: 6
Views: 5837

Re: Wait:IXCur on user login during TI data load

Do not use CubeSetLogChanges.
If you want to turn on/off logging in the cube set the LOGGING property on the
}CubeProperties cube directly.
That worked for me.
by 4rtem
Mon Aug 22, 2016 3:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wait:IXCur on user login during TI data load
Replies: 6
Views: 5837

Re: Wait:IXCur on user login during TI data load

No operations with TM1USer() and }Clients dimension and any of control cubes/dimensions.
Statistic cubes are active on the server, maybe it is the source of locks...
I will turn it off tomorrow and check if it helps.
by 4rtem
Mon Aug 22, 2016 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wait:IXCur on user login during TI data load
Replies: 6
Views: 5837

Wait:IXCur on user login during TI data load

I have a TI data load process that causes users to wait during integrated login. This situation is reflected in TM1Top in the following way: USername: ??? State: Wait:IXCur (UserName) - (Client) Function: SystemServerConnectIntegrate Obj Lock Status: Client This TI process does not create subsets, c...
by 4rtem
Mon May 30, 2016 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Corruption of ActiveX objects on 10.2.2 FP5
Replies: 13
Views: 8786

Re: Corruption of ActiveX objects on 10.2.2 FP5

Did you solve the problem? I have 32809 error after upgrading to 10.2.2 FP5. All clients are FP5 as well.
Action buttons are not working...
by 4rtem
Fri Feb 05, 2016 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives on High Definition (Retina Screens)
Replies: 5
Views: 4890

Re: TM1 Perspectives on High Definition (Retina Screens)

I also solved the issue for myself decreasing resolution to 1900x1200.
But now I have the same issue with potential client.
CAFE still does not cover flexibility of Perspectives.
by 4rtem
Tue Oct 20, 2015 7:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly Poll 201510_201511 - Do you plan to use CAFE as a replacement or supplement for Client and Why?
Replies: 7
Views: 6677

Re: Monthly Poll 201510 - Do you plan to use CAFE as a replacement or supplement for Client and Why?

I believe that all TM1 community is waiting when TM1 cafe will cover all spreadsheet functions of Perspectives.
Working through Citrix is really disappointing, while we do not have other opportunities in case of complex reports.
by 4rtem
Wed Sep 16, 2015 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives on High Definition (Retina Screens)
Replies: 5
Views: 4890

TM1 Perspectives on High Definition (Retina Screens)

Does anybody have such problems with TM1 Perspectives on Retina screen?
See the screenshot attached.
I have 10.2.2 FP4 installed and it looks that way :(
by 4rtem
Tue Jun 02, 2015 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: number of days in month for rule calc ?
Replies: 8
Views: 8490

Re: number of days in month for rule calc ?

I use following formula in TI where period is 'YYYY-MM':
vMonthLastDate=DATE(DAYNO(TIMST(DAYNO(pPeriod | '-15')+30,'\Y-\m') | '-01')-1,1);

The logic behind is to find first date of next month and deduct it by 1.
by 4rtem
Wed May 14, 2014 3:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Default drill format
Replies: 1
Views: 1856

Default drill format

I have problem with formatting drill results in Excel. I have drill view that has formatting with no decimals and thousands separator. It is displayed exactly as expected within Cube Viewer. But when I make drill within excel worksheet, I have completely unreadable formats with no separator and vari...
by 4rtem
Tue Apr 08, 2014 3:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View() function in the multiple sheets report
Replies: 6
Views: 4631

Re: View() function in the multiple sheets report

Thanks, will make one View function per sheet.
by 4rtem
Tue Apr 08, 2014 7:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View() function in the multiple sheets report
Replies: 6
Views: 4631

View() function in the multiple sheets report

Hi! I have something like 15 worksheets report that reference one reporting cube, but different slices, all figures are pulled by DBRW. Currently I'm trying to optimise performance of the whole report. I have figured out that I need something like three View() functions to cover required slices. Sho...
by 4rtem
Tue Apr 01, 2014 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 captions disappear, Excel 2007, tm1pRibbonX, Persp 10.2
Replies: 1
Views: 2018

TM1 captions disappear, Excel 2007, tm1pRibbonX, Persp 10.2

I have known issue when TM1 button captions disappear in Excel 2007 described at least at 1. http://www.tm1forum.com/viewtopic.php?f=3&t=5168 2. http://www.tm1forum.com/viewtopic.php?f=3&t=6287 According to those links I have following solutions: 1. Upgrade to Office 2010 (not possible due t...