TM1 Forum

Issue corrected with Tm1 server reboot

Thanks for the your replies !

Excel 2007 - I was not meaning to upload an xlsm fiel ( which is not allowed on 9.5.2) I have restarted web and excel services - the issue is effecting "all" of my web xlsx file . Guess I will bring down my app later today & also reboot the server - see if that resets anything - somewh...

Yes - did not work - this is 9.5.2 so uploads are xls or xlsx I "confused" something when I overwrote the test.xlsx web file with the myfile.xlsm - tm1web does not recognize xlsx file as legit file - when I try to open any xlsx file the web download box pops up - thanks for your reply

Tm1web (9.5.2) stopped opening xlsx worksheets -

? Think it started when I overwrote a test.xlsx file in web app folder with an excel xlsm file

any ideas ?

Thanks in advance

I was able to convert - my issue was the tab (aka cub) was using some old dimensions that did not have on the server -
after putting these dims on the server and restarting the tab file was converted to cub .

Thanks for your help
Lewis

I have an old tm1 cube - extension type 'tab' ( tm1 v6 ? v7 ?) - I thought I would
be able to drop it into my data folder and restart my service and it would get converted to
.cub - but it is not doing amything ( no messages in log file ..)

Any ideas ?
Thanks

Tm1 version 9.5.2

The "Die_group" rule is providing the correct results ( and is at the compiled with "C:") Not sure what that rule would look like (?) - I tried this ['All Die Groups','Run_Hours_Equiv_CAR']=C:['Run_Hours_Equiv_CAR'] but it does not work probably because 'All Die Groups' would hav...

The rule is checking if the dim element is "die_group" then it checks if for the scenario prior year for CARPRH = 0 or Run_hours = 0 if so skips else perform calculation . ['Run_Hours_Equiv_CAR'] = IF( ( lower(subst( !material_basic_nbr,1,9) ) @= 'die_group' ) , IF( ( DB('Ops_metrics', Att...

My original post was intended to elicit a general solution.

Here is my code ( modified for clarity) Thanks

I have a rule to consolidate only certain elements within consolidation groups ( ie cons_grp1, cons_grp2,…) ** cons_grp'x' rollup to cons_grps_all ** rules is only calculated for cons_grp'x' Issue: I cannot get cons_grps_all to accurately reflect the cons_grp'x' totals. I am feeding the rule but the...

I was trying to avoid any custom code - will play with it in my dev system. I have been been able to accomplish the client logout ( clumsily ) with hyperlink using the url action = logout , but still requires user action. When hyperlink is used in direct launch websheets the logout leaves a page tha...

I have embedded Tm1 webpages / views in sharepoint using URL API - when user exits SP and re-enters they have multiple IDs logged in since they are not logged off Tm1 when exiting SP. * same issue with direct opens using Tm1 URL API link and user closes page (IE/FF/Chrome) and re-enters . Is there a...

Unfortunately that did not work for me either

Seems to get past first install screen then I get popup > 'upgrade from 9.1 box message.

Ask IBM if there is an install log file output somewhere ( no reply yet ) .

I have ticket in with IBM so far nothing - will post results from ticket

Thanks

Still couldn't get it to work - thanks

No not yet- thought I would check with the real experts first to see if someone saw some
"undocumented feature" in my parameters

Will be placing a ticket shortly - will update post with information I get back .

Thanks

I am attempting to use the silent install for the first time - to upgrade to 9.5.1 clients from 9.1. Issue install not silent - required normal interaction - here are the parameters I used. ( also install did not enable excel addin or reset adminhost ) setup.exe /S /L1033 /QN INSTALLLEVEL=0 INSTALLD...

Client attribute > }TM1_DefaultDisplayValue < displays in 9.5.2 FP1 -
CAMID was still displayed in 9.5.2 base release .

Issue resolved > self-inflicted

The Excel version in my 9.5.2 environment had security setting to disable ( & hide notifications)
set for activex controls.

My public apologies to IBM for assuming this was a 9.5.2 release bug .

Regards
Lewis

I am in the process of moving to 9.5.2 FP1 from 9.5.1 HF10. When I open Excel sheets with action buttons created in 9.5.1 in my 9.5.2 environment the action button loses it properties and is not selectable for editing ( or anything else) . Only change between 951 and 952 setup - is in 951 I had one ...

English was selected - I switched to German and I was able to save dimension. I switched back to English and changed the list separator from , to ; and that also worked . I have ticket in with IBM - a 9.5.2 client fix is suppose to be in an October release - I will pass this on . * IBMs interim sugg...