TM1 Forum

That seems to have worked perfectly. Thank you so much for your help.

Hi All, I have a period dimension that is by day. days roll up to months, months to quarters and quarters to years. I am trying to create dynamic mdx that will return the current month and previous month This works to return the current month FILTER(TM1SUBSETALL([report_HDD_fiscalPeriodByDay]) , [re...

That functionality may no longer work as it will not allow me to save the process

They are processes that touch all dimensions. When we run then as part of our normal loads they do not cause issues because we can run then serial but if someone runs them adhoc or now they need to run them manually more often we are seeing the instance hang and have to be restarted which causes dat...

Thank you for the reply. It is definately not the number of threads but the interactions between processes that share some dimensions.

I am looking into the Synchronization of processes functionality now.

Hi there, Does anyone know if it is possible to set the MTQ parameter to 1 at the beginning of a process and then to 45 at the end. We running normally at 45 bit there are a few processes who cause issues if other processes run at the same time. Just trying to avoid having to set MTQ manually each t...

It was cell security after all. We have a high level dimension product that then has sub dimensions like budget_product etc. It was the lowest level dimension that had the cell security on it.

Thank you for all the help

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?