TM1 Forum

Ok Ok let me check your idea, thank you so much

HI declanr, thanks for your answer but i cant alter the dimension and this calculation is to every day, this is the granularity.

I good idea but in this case it is not possible

Thanks

Hi people, i need your advice This is the situation I have a Date Dimension with 4 levels. This is the structure Year->Quarter->Month-> Day and i have a measure called Rolling Year Sales= Sales to the previous 12 months. I get you an example suppose that the current date is 2013-05-10, then the Roll...

Hi people, how are you? I need your help with a issue, i would like to move data between two cubes using turbo integrator, i wanna simply move all data from source cube to target cube, two cubes have the same dimensions , the same structure, just i wanna move data changing versions. Any suggestion. ...

Wow friends , this is so strange so as viewing a link which Alan referred me (http://www-01.ibm.com/support/docview.wss?uid=swg27023379) , In a CX guide this command is mentioned. Exactly, Turbo integrator Guide, page 36 (http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.1.0/tm...

Hi everybody, we have installed Cognos Express 10.1 , and i would like to do a .bat using the command tm1runti but i dont find it. I searched in all folder and nothing.

Could you help me with this ?

Thanks!

Hi people, i got, i used the code given by ryan. i had to put it in Metadata Tab so as working and append this line in the end SubsetDestroy(sDim, sObjName). I did a SQL statement which it return the days that i need. Well That's all. Thank you so much. SQL select * from dwh.dim_fecha where fe_fecha...

Hi Alan , thanks! i'm going to read this just now. Exactly im a programmer but i dont know the syntax to work in TI. Really Thanks

Hello Martin, thanks for your answer. I have a Im new using Tm1,the idea is going to delete date by date, isnt? but how can i do parameters? you told me that i had to create an pStartDate and pEndDate parameters. how can i declare them? i would like to delete from current date to current date - 2 mo...

Hi everybody, i need your help with a problem I want to reload the last 2 months of data into a TM1 cube. I can use the data functions to workout when the beginning of the last month was. From there I basically want to remove all data greater than that date. The date dimension is in the format of yy...

Hello thank you very much for your reply. You're right, i made ​​a mistake in translation. Excuse me for my english. Like you said put the qualifier C:. And get results in the month but at the level day i have only zero values​​. i have a question, im writing this rules in the cube "Cubo_Diario...

Hi people, how are you? Im new using Tm1 , i have experience using another tools like Cognos Transfomer but Tm1 is too diferent. I really need your help: I have a cube with a date dimension (year->quarter->month->day). I have a measure called num_visits . The rollup for this measure must be : - To t...