TM1 Forum

Hi Everyone I think this is the right Board index to ask a general questions. I have an active form with two dimensions on the rows and want to filter on a value in the column. It works great with 1 dimension on the row but how do I get it to work with two dimensions. The MDX below is for when there...

thanks Alan, I solved the issue. It was a spreadprecision parameter missing from the CFG file. I set it from 1e-8 to 1e-2 and my issue is now resolved.

Hi Everyone

Has anyone had any issues where in TM1 web you enter a value in a C level calculated field and it goes back to its original number? It happens on a few lines but some take the value in TM1 web. its very odd. Any insight would be greatly appreciated.

thanks

Hiten

Hi Everyone, I have a client that is using Financial Analytics Publisher (FAP) to produce more detailed cubes from Cognos Controller. The FAP refresh is somehow setting Cubes and Dimensions to “NONE” on every Security Update it does. One thing we could do is "mirror" the cubes and assign t...

Hi Everyone, Im trying to include another piece to my MDX statement that has a measure called "Exclude". So far my MDX statement is as as follows: {FILTER({TM1SUBSETALL([PPD_Fixed Cost Account])}, [PPD_Fixed Cost Mapping].( [FPS_Department].[161003], [PPD_Fixed Cost Mapping Measure].[BLI F...

Hi Everyone This might a question that may have been answered in past topics but is it possible to have multiple owners in a node. For example: The hierarchy may be: Eastern Region ->Maryland ->New York ->New Hampshire Is it possible to have more than one owner assigned to Maryland? I think the answ...

Thanks everyone, your posts helped me out and I got it to work

Hello, I am trying to write a RULE where in my Planning version i have a calculation C=A*B but in Actual C is an input. However I want to be able to open up my planning version and see the ACTUAL overwrite the first three months. I have written code to have TM1 block out whatever months are consider...

Hi There I am trying to run an ASCIIOUTPUT on a CELLGETS function in TM1 10.1. my code is below for the CELLGETS and ASCIIOUTPUT. In the CELLGETS, I know there is a value in the combination that is contained in the formula but I want the TI to produce an ASCIIOUTPUT. I dont know if my syntax is corr...

yes nested ATTRS, thanks, this is what I needed

Hello Everyone, I am building a RULE that I need to pull two attributes from one dimension. Essentially I am trying to obtain the sales for IO Fast Moving in a Product hierarchy that has Parts as one of the attribute members (belongs to Category attribute) and Fast Moving attribute member (belongs t...

Hi Everyone

I have a DBS formula, DBS($A$1,"server:cube",e1,e2) and I am trying to send values to a cube however the values are listed in a pick list. Is that possible to send values to a pick list?

thanks

Hiten

Hello everyone, Im trying to create a RULE that will do the following: Cube A (Source Cube): View Version OrderType (Initial Order, Repeat) ProductHierarchy (Total Parts, PartsLevel 1, PartsLevel 2, PartsLevel 3) Account (Total Sales) Month Cube B (Target Cube): View Version ProductCategory (Total P...

Thanks so much Tomak

Hello, I need to understand how to build a TI that will do the following: cubesource = Cube A cubetarget = Cube B the dimensions in Cube A are: View Version Entity FiscalYear Measures (Cost) the dimensions in Cube B are: View Version Entity Vendor FiscalYear Measures (Cost) I am trying to create a T...

Hi Jim

Correct the child values will have the same values so if there are 5 children they will have the same value, so i need the parent to have the same value.

Hi Everyone Im looking to build a rule that allows me to make the parent level equal to the child level. For example Child 1 and Child 2 have 19000 as a value, I would like to have the parent hold the same value and not consolidate the 19000 to be 38000. What is the function or rule to do this. than...