TM1 Forum

Hi guys, In my model I have several process that run data from a database to cubes. But before that I have to use viewzeroout to clean the period that is going to receive the data. I am trying to create the view on prolog, then use the view zero out and after that destroy it. The problem is when I u...

Hi Wim,

It worked fine.

Thanks a lot for helping.

Best regards,

JR

Hi guys, I have a cube like this: img1.PNG On the top I have the dimension of period. I want to create a process that will copy data from one period to another. I tried to do this using the view of the cube as source: img2.PNG But the period that I am going to copy every time that I run the process ...

Hi,

I realize that the ODBC connection was 32-bit while the server was 64-bit. Then we did the connection again as 64 bits and it seems to solve it.

Thank you!

Hi guys, I have a process with some process that use data from ODBC. For some reason since yesterday when I try to run a IT process that read data from database I get a error on log file. In theory nothing have changed since then, but I would like to know if someone has some tip for this kind of pro...

I'm trying to generate the same view on tm1web to show the error. I only copied the vue file. I've checked the view on dev and many of dimension of the cube aren't set with subsets. There is any problem with this? If it is, it might not working because of that. As soon as I get the error I'll post h...

It is that!
AMAZING tomok.
You saved me.
Thanks a lot man!!!

tomok wrote: ↑Tue May 22, 2018 2:14 pm It might be due to the question mark (?) in the query. TM1 could be thinking you are trying to insert a parameter.

Hi guys, I have a query that is running (attached) on sql server and after a copy and paste on tm1 turbo integrator it doesn't work! It's crazy and I don't know what to do anymore. The message on log is "[SQL Server]Unclosed quotation mark after the character string ' '. " I've checked man...

Hi, i've tried that but I face the same problem. The type error is different, but didnot work too.
Thanks.

declanr wrote: ↑Tue May 22, 2018 6:59 am Or create the view in TM1 Web so you dont have to perform the migration.

Hi Paul. Yes, I have a dev environment. I have created the view there on Architect, then I got the .vue file on datafiles folder and put it on datafiles of PRD environment. After that I stopped and started the service of sdata, but the view didnot appear on PRD. Do you know where am I missing the po...

Hi guys, I am trying to create a new view of a cube in Performance Modeler (I would like to do this on Architect, but on the customer I can't use Architect on PRD environment because of restrictons of firewall and etc), and I can just set up few dimension on the rows, but after a while I got this er...

Wrong. If you do it syntactically correct and the user has the permission it is correct. Again: look at the logfile. Hi, I take a look at the log and I got this: 2620 [c] ERROR 2018-05-09 14:24:01.679 TM1.SQLAPI 37000[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword '...

Hi guys, I think I realize what is the problem. The query get data from the database FINFINDBS_PRD, but in the middle of the query we get data from another database as you can see in code: ------------------------------- ,(select count(*) from [DWHTRA].[dbo].[DIMPOD_BI] where datini between (dateadd...

Hi Orlando. Yes, when I try select * from any table works fine. The user on TM1 is the same that I tested on sql server management studio. The ODBC connection was made in windows, just selecting the database, user and password. Sorry about my ignorance, but how it works about creating a view in SQL ...

Hi Willi, I can't get any log because the process is not running. I put the query on the process and press preview to see if it works, but i've checked now and there is no log file of doing that. Do you know where can I find a tutorial that shows me what I can't use on query on TM1? Thanks! You get ...

Yes,

I ran it on studio with the same user that I am using on Turbo Integrator.

I think that query is using something that TM1 might not accept, don't know.

Thank you for the reply.

Best regards.

Hi everyone, I have a query on turbo integrator (ODBC connection it is ok and running and the query works fine on SQL Server Management Studio). But some reason I got the error "SQL Statement Failed" when I try to put this on TM1. I have tried to found something on internet but nothing is ...

Hi, I have a cube with 3 columns, 2 of 3 are dates and the third one is the number of weekdays. How can I do this on TM1? I have read some topics here at forum about this, but also using a calendar cube I didnot understand how to put this working. On this calendar cube I have to put all days of the ...

Hi all, For internal questions on my customer, I would like to open directly a tm1web view from a cube, without using the default tm1web link. I have read some topics here in forum about the TM1 Web URL API and after researching a little I found a example to test on IBM website, like this: http://lo...

Hi Paul,

I understood what happened. I have a process running everynight with a different name that I want and it was using "refreshmdxhierarchy" on epilog.

Now I've changed it on process and hope to keep right.

Best regards,

Gabriel