TM1 Forum

Guys, I have a Time Dimension which has multiple hierarchies. Total Time -> Regular Time -> Year -> Quarter -> Month Total Time -> Current Time -> Current Year Total Time -> Current Time -> Current Month Please note that members for Year and Current Year are like 2010,2011, 2012.. Quarter are like Q...

Thanks ..

Thank you very much Paul, will try this ...

Yes.. I have around 8 yrs of exp on BI and ETL but now things on Planning and Budgeting comes up... so its new for me..Thanks

Thanks I followed what you guys have suggested and managed to make that working ..thanks for that.. I have created a excel pick list and populated that with certain static attribute values and have used TM1RPTROW and TM1RPTVIEW functions to pass the dynamic MDX based on the parameter and select only...

Thanks I followed what you guys have suggested and managed to make that working ..thanks for that.. I have created a excel pick list and populated that with certain static attribute values and have used TM1RPTROW and TM1RPTVIEW functions to pass the dynamic MDX based on the parameter and select only...

Thanks sir...and what do i do if i want to filter corresponding elements appearing in excel perspecitves... I have a reuqirement to have an attribute called employee manager, based on which a drop down should appear in perspectives. Selecting a particular employee manager would need to filter and re...

Okk thanks...so there is no direct way to populate a picklist with attribute values...actually my use case is to have a drop down on attributes and based on that filter the elements appearing in the perspectives..now seems like I will have to have a seperate attribute cube and try to implements.. Mo...

Hi ,

I have similar requirement where in I want to show user in excel perspective a picklist having all the attribute values. Can you please advise how you did this please.

Hi Guys, I want to populate a pick list with attribute values of an element in another dimension. Can I do that. I have an Employee Detail Dimension with lowest level being Employee Name (Having text attribute Employee Manager) I want all the distinct values of Employee Manager to be available in a ...

Can you please advise in detail in terms of How do i create selections for these attributes in Active form in Excel. Which MDX function I should use and how do I have a parameterized excel formula to generate a MDX statement and how that that will generate the employee rowset. I already have created...

Sorry but I have just start learning TM1 few days back as need to do some project from monday onwards. My previous post was similar though not intentional. It started with a requirements and second post was about what i thought could be a solution but didnt knew how to do that in TM1. I only have th...

Please advise how we can 1)Display text attributes say Employee Grade and Employee Manager for element Employee in perspectives 2)Define prompts and filters in perspectives to refine data in the cube view based on the attributes. For e.g. what if I want to have a drop down list showing all values of...

OK thanks for the help ..So it will create the dimension but what I actually want is .. 1)Have users be able to select any combination of location, department and enter data for payroll. But because I do not have 1 to many relationship between location and department hence cannot force a drill up an...

OK thanks..may be a bad design as any ways drilling up and drilling down would be an issue with many to many relationship between levels. Anyways doing prefix would be a stop gap fix that I have tried but then dimension elements which will be created will be like Deptt+City which is not acceptable. ...

Thanks for the help but, data is anyways in CSV, and is in .excel. Here on the post it is showing like a single line as formatting does not apply on the forum GUI.We do not want to pull it in a single line nor have it in single. Issue is not about pulling data, but the semantics. Please refer to the...

Hi Gurus, I have got a business requirement wherein I need to create a dimension similar to this. Left most being most detailed . As we can see here there are many to many relationships between the levels. While I can copy and paste each of these and create dimension manually in dimension editor , b...