TM1 Forum

Thanks for the valuable suggestion, I will try it out and keep you guys posted.

Thanks

Hello Folks, I am trying to do a calculation where I have to show the user the last 90 day sales average from each day. Below is the given output that i am expecting (For easy understanding purpose I have taken total of last 3 days for each day). "Date", "Sales", " Last 3day...

Thanks for the prompt reply, Yes, The Live Environment's webserver is the same one where i have developed the original application, but the TM1 server are different for both the application. Sorry, I dint knew this that you can't install 2 Contributor applications with the same name on the same serv...

Hi Friends, I am moving my contributor application from the development environment to the Live Environment, However when i try to import the contributor application on the Live server using the 'Import Option' it gives me an error. I have run the “}tp_admin_delete_all” process for the new server th...

jim wood wrote:Did you read the thread I linked above? It covers the subject in a lot more detail.

Yes sir, That is excellent and too good for a newbie like me. Thanks a lot.

jim wood wrote:

In your rule you specify HR yet you have not set that in your feeder.

Hi Jim,

Thanks for the prompt reply.

I have set all dimension which are not in the source cube to there total consolidation level, 'HR' comes under the total consolidation level named 'President'.

Feeding Cubes 101: What is the determing factor as to whether or not you actualky have any dental insurance premium in the Dental Insurance Cube? Isn't it the Enrollment Status? If so, why would you feed from a lookup cube that just contains the rates by status code??? Hi Tom, Thanks for the reply....

Hi, How do i write a feeder for a target cube which has more dimension than the source cube. Here are my dimension Dental Insurance Cube Function Facility Department Central Nature Employee Scenario Year Months Measures (Employee Premium LC, Employer Premium LC,Enrollment Status) Insurance Driver Cu...

I have two contributor application in my contributor planner. I have deployed one application successfully but when i try to deploy the other one I am getting the error as "unable to create security group for this application groupcreationlimit should be 29 so i changed my tm1s.cfg file and ke...

I have two contributor application in my contributor planner. I have deployed one application successfully but when i try to deploy the other one I am getting the error as "unable to create security group for this application groupcreationlimit should be 29 so i changed my tm1s.cfg file and kep...

Hi Gregor, I am sorry , Nature and Central Nature both are same. Extremely sorry for this mistake. Thanks for your time I appreciate that. Hi Steve, Thanks for the solution. What I did is I wanted to calculate the regular hours of the employee and the formula was (working days * 8)* No of employees....

Hi friends, I have an HR Cube having the following dimension Function Facility Department Nature Employee Scenario Year Months Employee Measures. I am trying to get data from a Employee master cube having dimensions Facility Department Nature Employee Scenario Year Months Employee Master Measures. I...

You'd often use rules to do this kind of simple allocation, in pseudo code this looks something likes this. [Allocated Head count]=N: [Input Headcount] * DB ( Departmental allocation rates); If you are using TI to do this it may be a bit of an overkill plus with rules you will get your results in r...

Hi Jim,
It's ok, Thanks for your time appreciate that.

Hi freinds, I am trying to filter out the Nature code using the MDX query, however I am not getting the expected output. I am trying to filter records for Nature code by using the Employee records cube where the Employee measure shift is 1. Is there anything wrong in this MDX query? I have attached ...

Thanks Tom, I will try by suppressing zeroes.

Hi Jim,

Thanks for the reply, I am a newbie so I was just asking if the approach adopted is alright, or is there any other way to do such things.

Hi friends, I have a cube named HR, Having following dimensions. Function, Facility, Scenario, Serial No(1,2,3,4) Department Account Code, Measures-Employee Name,Allocation %,Amount, Allocated Department, Allocated Account Code. The design is some employees are working in different department howeve...

Hi Folks, I have a Sales Cube having dimension like. Year Month Product Line Market Segment Company Scenario(Actual,Budget) Measures(Amount LC,Amount USD) The requirement of the client is something like this. 1. He gets an annual sales number, and he wants to spread it across months based on % which...

Thanks guys, you have been very helpful.I know that this question was a spoon feeder.My sincere apologies for that. I will make sure that doesn't happens next time, I have too many things to do too little time to do that :roll:. It is basically a challenge that sometimes we have to accept and I have...

Sorry for that.

I have just got into TM1 and directly on to the project and I am the only technical and functional person in the team and I have deadlines to meet, so it was out of desperation.

Thanks for your valuable time and guidance. I will keep that in mind.