TM1 Forum

Thank you. I did not try putting 2 cellputs under the if. I had tried a second if with the same criteria that did not work.

This appears to be working now
Thank you for the help

I have a cell put on the data tab of a process. What i need is the Rate Value to be put against 2 elements. Where it says if SourceNum @= 1 I want to put that Rate into values of 1 and 3 in the Price Rate dimension Everything I have tried has not worked and google has been no help. Is this possible?...

I am wondering if you can use ConsolidatedCountUnique with a "where" type clause in a TM1 rule. I am trying to customize the way the consolidation work. As you see in the attachment, at the level location everything is rolling up as I would like. If the location had volume for a day in the...

I am building a TI process that looks for value at all the records at an intersection and increments another intersection by this value but I am not sure if I need to define a source and target view or if I can just do a calculation and if so how. Source intersection Cube - Sales Period Dimension = ...

I am wondering if it is possible and if so how you could use MDX to limit the values returned in a drop down by the user logged in. User opens a TM1Web data entry form and has to enter data for 4 companies they are responsible for. Currently when they select the drop down they see all the companies ...

I have 2 processes, the first has a parameter on it to enter a single value, the other has no parameters on it at all. I want to create a master process that uses ExecuteProcess to run both processes. When it runs the first process in the list it would prompt them for the parameter, then the second ...

Thank you for the reply. I have a ticket open with our ETL team to look at this but they are notorioulsy slow and I am trying to deply something soon.

Do you have an example of parsing the file in VB?

Hello, I am totally new to this and was wondering if I could be pointed in the right direction to learn more about parsing a text file to another file in a proper format. The data comes in like this and I am trying to do things like get the values between the **, capture the date, and all other data...

Some more details as I have gotten farther. In the Data Source Query of my TI process I have the following section that returns properly in the Preview CASE WHEN upper(A.TOWN) like '%HALIFAX%NS%' or upper(A.TOWN) like '%BEDFORD%NS%' or upper(A.TOWN) like '%DARTMOUTH%NS%' then 'Y' ELSE 'N'END AS NS_M...

thank you

Hi gurus,
Is there a way to do wildcard search in a TI process?

If (element like Rad*)

Any help as always is appreciated

I was also trying something like this but can't get the second half to default to previous month...always says invalid mdx statement [fixed_asset_fiscalPeriod].[fixed_asset_fiscalPeriod].[2011.12] : FILTER(TM1SUBSETALL([fixed_asset_fiscalPeriod]) , [fixed_asset_fiscalPeriod].[NextPeriod] = [CONTROL]...

Thank you for the help. When I try that updated with the actual dimension name and date format, I get everything from Dec-11 to Mar-27 returned by the mdx. Did I mess it up somehow? {{SUBSET(TM1FILTERBYLEVEL( {TM1SUBSETALL( [fixed_asset_fiscalPeriod] )}, 0),0,VAL([fixed_asset_fiscalPeriod].[JUL-22]....

Hello everyone, We have a zero level fiscal period dimension that shows dates in the following format JUL-22. These dates go all the way out to 2027. I am trying to write an MDX subset that will return all data for all periods prior to current month. If I ran it is July-22 I would like all fiscal pe...

The data is in Cognos Analytics coming is in data module from a TM1 cube. The report is just displaying data results, there is no user input.

I will look at our data load processes and see what is there

Could you point me in the direction of some steps or something to google on for this. I am new and my searches are returning nothing useful
Thanks

Hello, I am wondering if it is possible/how to copy the string measure value from the leaf level to the consolidation level. I have a date string that shows on the report at the leaf level but not at the consolidated levels of the same report. I am trying to see if it is possible and how to copy the...

Thank you so much. I will give this a try

This sounds like a good idea but I am a bit lost. So each subnm would have a checkbox and that check box would contain logic to see if it is in use? - not sure how to do this and then the could unselect the checkbox and rebuild the sheet - would there need to be anything needed in the checkbocx logi...

I have basically a set of columns in PAX with the ability for the user to filter from a drop down generated by a subnm pointing to a subset. The issue I have is there is no way to clear out the selections the user made if they want to remove a filter. Is there a way to do this through a button using...