TM1 Forum

Steve,

Yes, Alias is present and I manually checked.

I remodeled the web sheet with modified MDX to retrieve the child items sorted in order to workaround this and it is working fine without using Alias's in TM1RPTROW.

Rodger, TM1RPTROW with MDX is used to get a list of alias element names in specific order and used DIMNM(.., DIMIX(..)) to get the actual dimension element name. It doesn't work in both Excel perspectives and TM1Web - just returned empty. I tried hard-coding DIMIX with alias element name in excel pe...

Hi, We recently upgraded from TM1 v9.5.2 to v10.1.1 along with a lot of TM1 Web excel files. DIMIX and DIMNM are used extensively to get the dimensional element from the Alias element name and it worked perfectly fine in v9.5.2 However DIMIX is not working in v10.1.1 when used as said in below docum...

Hi, Is there an easy way to convert all TM1Web active forms data to UPPER case when users enter data in lower-case? I tried dimensional attribute formatting (cube displays value in uppercase however still it stores in lowercase and displays lowercase in TM1Web), TM1 Excel perspectives conditional fo...

Sorry for not being specific - issue is in the RULES. Sample code - check for data validation (business requirement) and concatenate custom error messages to 'Valid_Err' ['SaleType', 'AView', 'Year', 'Valid_Err'] =S: IF(DB(..) @= '', (DB(...,'Valid_Err') | '; Item does not exist in the A_Master'), C...

Hi, We need to concatenate validation strings i.e. validation error messages from different parts of the rule/conditions and we are facing an issue in string concatenation (using pipe - |) wherein only 254 bytes are allowed. Looks like our validation error exceeds this limit and they were not displa...

Hi Alan/Martin, Thanks a lot for your time and inputs - it worked, example mentioned in the link was really useful and I replicated part of it. 1. Create temp view/subset (ViewCreate & SubsetCreate) 2. Loop through the dimension and add item_numbers to temp subset (SubsetElementInsert) 3. Assign...

Hi, We have a requirement to clear/delete cube or dimension partially via TI - Cube have 3 dimensions Code, Item_nos and Measures. Code - 01, 02, 03..99 Item_nos - 01_a1, 01_a2, 02_a1, 02_a2,...etc Measures - m1, m2, m3, ...m123 REFRESH: On setting parameter pCode=01 in TI, we need to load new value...

@jorelb :idea: - thanks a lot, it worked. Go to Tools -> Options -> calculation tab and turn on Manual instead of Automatic. @lotsaram - our users integrate TM1 excel data with other application to form a finacial report by inserting a new worksheet in the same excel file and via VLOOKUP formulas. T...

Hi,

Thanks!! I tried harcoding the cubename however it ended-up in blank cells on reopening the excel.

Is there any workaround to save the data and make it available in excel offline?

Thanks,
Logan

Hi, I have an issue in saving data in excel i.e. when connected to server, i can see data (using TM1RPTVIEW/TM1RPTROW/SUBNM/DBRW) and able to save it however when I close and re-open the excel, I was not able to see previously saved data. All data retrieved via DBRW was gone and I can only see blank...

Hi, Please find attached the snapshot of what we needed - 2nd column (RESALE) is a drop-down column with static values populated and users want to change rows-1,2,3 and 7 from 'RESALE' to 'Cost Method' (we have 200+ records and it is painfull to change cells one-by-one). We have to go through each a...

Hi, There are a few columns in Active form designed as a drop-down box with 5 values and it takes 3 second to change one line of value in drop-down box i.e. to change value from 'A1' to 'B1' for 10 selective records, 'B1 to C1' for 35 consequtive records, 'C1 to D1' for 20 records etc. It took almos...

Hi, Tried everything however none of them worked-out in excel. Finally, added a new column in the cube with numeric value '1' if there is an 'Item'/'Please', included this new column to active form, summed-up to get the count and the column was hidden. This is the workaround to get that done :-) Tha...

Hi, We have below calculation to calculate number of cells in BX column with specific text (starting with 'Item' or 'Please') and is working fine in Excel however when we view the count in TM1 web - it always displays '0' (TM1 9.5.2 / Excel: 2003) = SUM(COUNTIF($BX:$BX, "Item*"), COUNTIF($...

All, Sorry - it was 9.1 and not 9.2.1 and their user base is > 200 First of all - I have no idea why my client was downgrading, they just want their app in 9.1 instead of 9.5.2. When questioned, they said "licensing issues" and I am not sure of what might that be. I had already suggested t...

Hi, Our client is downgrading existing application from TM1 9.5.2 (in which it was created) to old version 9.2.1 due to licensing/some other issues - could anyone please clarify below queries 1. Is it possible to downgrade TM1 9.5.2 application to TM1 9.2.1? 2. What are the possible issues that we m...

Sathish,

Can't you just add a query-level filter like Quantity <> 0 and Revenue <> 0 - this will filter out all 0-value records.

Logan

Excellent!! Thanks for the code.

Logan

}StatsByCubeByClient is not working in 9.5.2 too...I tried testing with cube changes, start/stop service to start over, dimension & cube update but none of these actions made any changes to }StatsByCubeByClient cube - shows 0 for all.

Logan