TM1 Forum

Hi,
Is it possible to calculate dateDiff like excel in TI or Rules ?
Return string : Nr of Days - Nr Hours - Nr of Minutes - Nr of Seconds

Thank you

Hi all,
I've exactly same issue with you but I don't have any cell cube security in my app.
Do you have solve this issue ?
Thank you in advance for your reply

PO

Thx for your reply.
I've seen this example but it isn't work with my application. I don't understand
Do you have TM1 server example that illustrate this function ?

Thank you in advance

hello,
I'm with 9.5.2 and I can't use the function consolidatedavg

Can you help me with a concrete example please?

thank you

Hello,

I'm trying to use this exe with CAMpassport.
I've the CAMPassport from C8 but it doesn't work.
Whath the good syntax.
Thx in advance

Hi Steve,

I'm very interrested in you Archival TI's.
Do you finally achieve your work ? Can you share it with us?

Thx

Pierre

Hello everybody,

I'd like use "." like decimal separtor and not "," on TM1Web to input a value into a cube with a numeric element
Do you think it's possible ?

Thx

Hello everybody, I want to calculate YTD and I wrote this rules ... SKIPCHECK; ['YTD N' ] = if(NUMBR(ATTRS('4 Time Month', !4 Time Month, 'Month Num'))=1 % (ATTRS('4 Time Month', !4 Time Month, 'Month Num')@=''), DB('A Sales Analysis', !2 Company, !5 Version, 'MONTHLY N', !4 Time Month, !2 Applicati...

Hi,

Is it possible to do this by TI ?

Thx

Hello Everybody,

Is it possible to configure the size of the windows "Subset Editor" on TM1 Web
When I click to open a dimension in TM1 Web, I'd like to have the popup full screen by default and the windows advanced actived.

Do you think if it's possible ?

Thx

Hello,

Who's any experience Cognos Data Manager & TM1 9.4.
I have a DBMS driver error when I test the connection and I think my parameters of connection are correct

Can you help me ?

Thx

Thank you for your answers
Finally, I've done that ...



David,

Yes we are from EP world. We are currently building process for integration between Analyst/Contributor and TM1. Do you have some example to help us ?
Thank you

Hello Everybody.

how do you achieve this by rules in the 2nd Cube ?
In the 2nd cube, 25000 is the sum of line 1 and 3 in the 1st and 4000 is line 2



Thx in advance

Re, I have found.... I have done a mistake in attributes. I use a rule in the dimension Client_Tout : ['SousSousGroupe' ] =S: if(ellev('Client_Tout',!Client_Tout)=0,elpar('Client_Tout',!Client_Tout,1),stet); ['SousGroupe' ] =S: if(ellev('Client_Tout',!Client_Tout)=0,elpar('Client_Tout',DB('}ElementA...

Thank you Scott for your response
I have created the attribute Group in Client_Tout and replace the feeders but that's doesn't work.
However, I belevied in your solution beacause she's logical...

I don't understand why this feeders does'nt work!!!

Any idea ?

Thx

Hello Scott, Thank you for your answer. When I check feeders, it returns no feed.... in the both cube -> My Feeder's rule is incorrect but why ? I don't understand why that doesn't work... Perhaps, In those 2 cubes, I have 2 differents dimensions for the customers ??? If I put N:, I only have value ...

Hello everybody, I have a problem when I want to feed between 2 cubes. My first cube contains Datas updated via TI and my second cube gets values from the first cube via a rule. Below the rule of my first cube FEEDERS; ['S1','Réalisé', 'Volume' ] => DB('s Prev_Ventes_SousGroupe', !Annee, !Commerci...

Ok I've found...
in the tm1.cfg we have MaximumViewSize parameter. The default value if this parameter is not set is 100

Hello

I want to open a cube with a big volumetric.
I've this error message : SystemOutMemory.
Where can I change the memory's parameter ? in the .cfg ? Which syntaxe ?

Thx

Hello,

Who's an experience with tm1 api and more specialy TM1BlobCreate, TM1BlobPut,...
Do you have some examples ?

Thx