TM1 Forum

Bump for this. I'm using 9.5.2 and am running multiple TI's on top of a .csv file, which in turn is output from a SAS query. I'm exploring the possibility of directly querying the DW using the same SAS code via the ODBC link. Possible? Easy? do I just need access to the relevant ODBC link and the SA...

Thanks All, much appreciated. Tahoma 8pt did the trick.

Thanks, I saw this - What i'm asking is what is the initial font set at?

Hi,

OCD Alert.

Random question, but one that bugs me - What is the default font for the TM1 rules editor? When I paste rules in with a different font, I can never get the same font to match it.

Cheers.

Guys, Bit of help with feeders if possible.... I'm using a rule which roles forward rates each month (in a split time dimension). It puts last month's rate in this month unless something else is entered this month. It uses an input and output nominal, rolled up into a reported nominal, with Input we...

I should add, SKIPCHECK; is turned on and I'm not feeding anything currently (Although advice on the latter is welcome!)

Thanks,

Simon

Hi guys, I'm trying to perfect ratios on a basic P&L cube and do different things at different levels, and i'm having some trouble. I'm calculating a simple ratio on a cube as follows; ['Gross Commission/Income']=['Commissions']\['Income']; Where ['Gross Commission/Income'] is a ratio nominal in...

Hi, I am having trouble with feeders and specifically feeding a rule where the feeder value could be Zero. Here are my rules; SKIPCHECK; ## Variances ## ['ActvsBud%']=(['ActvsBud']\['Budget']); ['Prior']=N:DB('Reporting_MAP','Actual',!Scheme_Summary,!Accident Year,!Cover Type,!Company,!LineOfBusines...

Thanks for your assistance guys, it appears we've solved the issue. It was a ODBC driver configuration setting that needed to be activated - specifically in ODBC Driver Configure -> Conversions tab, there is an option titled “Convert Binary data (CCSID 65535) to text” - This gave me readable string ...

I do indeed know what data is in the columns. If I output the table to a csv file and use that, it is all readable with no issues.

For example...

the column GBLT above contains either "AA" or "BA" - nothing more.

Any ideas?

Yes, the preview/error message remains the same with the unicode box ticked/unticked.

Hi, I'll preface this with an 'i'm new, be gentle' - i've read the posting tips so hopefully i'll summarise my issue succinctly. I'm attempting to write a create cube process that reads from an iSeries/JDE table via ODBC link (64bit) See the screenshot for my issue, but i'm getting pink shaded cells...