TM1 Forum

I removed the rules in security cubes...now my dilema is...everytime i add new elements in that dimension its always none...so i have to do it manually on the TM1 Dimension security. How can I reset it to having all new added element be on a "WRITE" security.

I was wondering if anybody can lend me a hand. Since its a lil different linking planning with TM1. I have a data entry cube where there is drop down dates. I need the value from this cell intersection base on the chosen drop down by the user to transfer to its respective date. I decided to create a...

Hi Guys, Just a question I wrote a rule to change the security of dimension base on the attribute of that dimension. I have a process that add elements on that dimension. How come when I check the cube, the cube's rights is update but not the actual access to those elements? The only time it updates...

Hi I was able to dig through some codes for executing processes in VBA...even though I don't get any error...is there anyway that you can help me troubleshoot the codes to get them working? Sub Representation_Warning() Dim Representation_Remark As Range If Range("Representation_Remark").Te...

I was wondering I'm doing a process wherein the upload is to be done by the client and once the first few statements has been done I want to set security on them automatically...but being an oridnary user. Is there anyway I can incorporate a TI that calls involves statements that write on control cu...

I was wondering I have 1 cube as a data entry wherein he can drop down months as a picklist then filters the number of days available in a month to determine the date to be used. I need to create a reports of all items for all hierarchy that chose the date. Is it possible to make the String value fr...

If you like to pass on security to another non-technical user but restrict them from changing any settings like adding more users than allowed or editting the max connection. Is there anyway to do this to be able to restrict these changes. To ensure that the allowed license & connection is follo...

How does TM1 determine the value of this so I'm aware of this and any suggestions. I'd like to run a TI process to input field base on the current time & date when the process is ran. The time and month is correct but when it comes to the year and the date it doesnt get the right value. For exam...

I'd like to ask I know this is more of a Excel question. I have one cell with the TM1User function being used. I'd like to copy & paste it on a string element. However, I noticed if I do Special Paste>Value manually the formula is not overwritten but if I do copy the macro to the button with a m...

Has anyone successfully integrated TM1 9.5.1 with IBM Cognos 10 BI with regards to the Framework Connection as well as the TM1 Portlet.

Is there anyway to write an MDX to get the current date element in a month-date dimension?

Okay thanks...I guess ive been so concentrated into reading the cube view and never bothered reading the other stuff...Thanks.

How do I create a view to limited to specific elements only? I'm creating this as part of a TI that loads that data 3 times a day daily....I need to zero out the certain elements in certain dimensions specifically date, year and measures for that date so I can refresh the data as scheduled. I have o...

I was lookin into the Drill process of TM1. What's the difference with both since I see drill process as like TI while Drill Assignment are like creating rules. Are drill process dynamic base on the cell you drill through from the orginating cell? What guide give a better detail of the drill through...

The first rule I gave in my initial post does work but since I'm having a trouble feeding it Source Cube: base_years base_months base_machines measure_capacity Destination Cube: base_years base_months_dates base_products base_machines measures_capacity Since from what I got from people's opinion, it...

Thanks guys for your opinions. I guess I'll just have to settle with using TI to transfer the data, however I'm stuck in a dilemma cause I'm try to just create a staging cube just to protect it from any changes . But how do I define the source cube's specific dimension "base_months_dates" ...

Yeah sorry about that. ['# of Spindle'] => DB('PRODUCTION_capacity', 'TOTAL YEARS', !base_years, 'TOTAL PRODUCTS', !base_machines, '# of Spindle'); I'm just about to try out you gave to adjust the rules but if adjusted my rules to the format you gave me...would the feeder I created on the ASSUMPTION...

How do you feed rules with what if statements, since i'm using what if to check the attribute of the cube against the source cube with the same # of dimension only different level. Its kinda frustrating since I tried everything even Feedstring though I know its morely if the output to appear is a st...

I'd just like to check with you guys, when you zero out a cube with a mix of string & numeric elements and the string containing a picklist. Shouldn't the picklist be cleared of any content during zero out? I just want to check is this is normal or not in TM1 since for none picklist string eleme...

I'd like to know since IBM general plan is to integrate the features of TM1 with EP. I'm not sure yet of the full feature of TM1 9.5. but I did some research online and saw they have license of TM1 Offline. Is there really such a thing or is this just additional confusion when it comes to the licens...