TM1 Forum

Hi, I have a cube with 3 dimentions, and want to built an active form with dynamic MDX. CubeA: User, Product, Measure I set a MDX in dimension User,but no element is showed. {Filter( {TM1SUBSETALL( [User] )},[CubeA].([Measure].[Department])="DepA")} If I set a specific Product, the MDX wil...

Dear Drg & gtonkin,
The Expand() function works, the output file prints what I want. Thank you very much.


wendywang

Hi guys, I'm import a .csv file to TM1 cube with TI. The file format is attached. From column F to column Q which highlighted with yellow are product list. I don't want to hardcode each product code in TI, and want to set a loop in the TI code. vColumnIndex =6; while(vColumnIndex<=17); vtypeclass = ...

Hello,
Does anyone know how to set a default TM1 Adminhost in Performance Modeler login page? It's inconvenient to input a complex IP or server name manually when open Performance Modeler. Thanks.

Wendy

OK, I got it, thanks.

Hi both, Thanks for immediately reply. Before Change, #Region System FEEDSTRINGS; SKIPCHECK; #EndRegion ['IST%']=['Sold Out Qty']\['Shipment Qty']; FEEDERS; ['Sold Out Qty']=>['IST%']; ['Shipment Qty']=>['IST%']; After Change , I delete the feeder part. #Region System FEEDSTRINGS; SKIPCHECK; #EndReg...

Hello,
I just tried a simple feeder rule, but found it couldn't take effect until I restart the TM1 service.
Do I need to restart the service when I modify the feeder rule? I think it's not reasonable to restart the service every time. Thanks.

Wendy

Hi, When I use Cafe Annotation in excel, I found some problems, In case I add 3 annotations for a cell, 1.only the first annotation could be showed in the excel comment box when there were more than 1 annotations. 2.If I delete the first annotation, and relogin CAFE, refresh, but it always show the ...

Hi Brianl,
The MaxInactivityTimeout in my configuration is 3600, which means the CAFE can be active for 1hour after login, but it seems the session is logoff after 30mins. Is there any other configuration to modify? Thanks.

wendy

Hello,
I've done some tests on FP2, the dimension still can't move in Flex view. This tool is not so flexible.

wendy

It seems Cafe 10.2.2FP2 has repaired this bug, I have done some tests,and the excel screen didn't flash so many times as before.

Wendy

Hi Dan,
I have set the calculations to manual, but it doesn't work.
The F9 only can refresh the cells which has excel functions. Only the Refresh button in Cafe can retrive/refresh value from server.

Thanks
Wendy

Hi, When I insert some formulas in flexview in Excel, if I click the Refresh button in CAFE pane, the excel screen will keep refreshing and flashing. The more formulas I add in excel, the more Refresh time it needs. In one of my worksheets which cotain 1200 formulas, it takes more than 5mins in Refr...

Hi guys,
I will download CAFE FP2 and do some testing. I will update the results to you.
Thanks

wendy

Hi,
Thanks for your suggestion.
But I have done many formats on this flex view, and lots of worksheets... and it means I need re-do all this worksheets....

wendy

Hi, I came across a problem when I used CAFE in TM1 10.2.2 to develop some forms. Steps: 1. I created a view A through TM1 Performance Modeler 2. I dragged the view A as a flex view in excel CAFE pane, and refresh the this form, it worked correctly.(ref.to attahcment) 3. Due to some reasons, I need ...