TM1 Forum

Thank you for the responses. I will keep digging

Hi All, I have a form that I can enter into as Admin, but users cannot. I have looked to ensure the users are in the proper write group, there is proper cube security, there is no dimension or element security on any of the dimensions or measures, there is no locks or holds, and the users are not se...

mostly cube size. We are running into issues with the server getting too close to its limit and I thought one thing I could look at was cube sizes.

Thanks for the advice. I have tried the steps on a few of those links and always got a zero or no overfeeding back (which cant be true)

I will try the other listed in that link and see how it goes

Thanks again

Good day all, I have tried the shadow cube technique from CubeWise to identify overfeeding and either it is not working or I am not overfeeding (which I find hard to believe) Does anyone have any other tips/tricks to identify overfeeding. I am basically looking to reduce feeder file sizes to decreas...

Hi there, I am just wondering if it is possible to sort columns and attributes together or if the attributes are stuck having to stay after the dimension they relate to example currently looks like asset assetattrib1 assetattrib2 product trying to get to something like asset assetattrib1 product ass...

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...