Sylvain Roy
Activity overview
Latest activity by Sylvain Roy-
Sylvain Roy commented, We tried that, but then the aggregation is the sum of the ratios, rather than the sum of COGS divided by the sum of Gross Sales...
-
Sylvain Roy commented, This is great information. Is there a way we could do that in a virtual cube for a global calculation? For example, our users are asking for COGS/GS (Cost Of Good Solds / Gross Sales). The custom c...
-
Sylvain Roy commented, Is there documentation somewhere on the Aggregate type option of a measure? Specially the Custom one? An how about the Partition by one?
-
Sylvain Roy commented, Thanks Ole. I should have posted the answer here but I forgot. I found out that the email setup we where trying to use was the one in Server Management, but by coincidence we found out that there w...
-
Sylvain Roy created a post, ETL Studio email tool
Hello, As anyone succeeded at using the Email tool in the InMemory ETL Studio? We created a datasource : We know the server configuration works because there are emails sent to numerous users for ...
-
Sylvain Roy commented, I was able to run en ETL script from a Powershell, however, the Inmemory database does not show the refreshed data. The script is : & 'C:\Program Files\TARGIT\TARGIT Data Service\tiImport.exe' "C:\...
-
Sylvain Roy commented, Hi Marc, did you ever get an answer to your question. Similar to you, I would like to start an ETL job from a Powershell or command line...the actual goal where I work is to have the users order a ...
-
Sylvain Roy created a post, ubidots json datasource
Hello, I am trying to pull data out of ubidots api, which is a REST api, into an Inmemory ETL Studio script. I tried to use the json data source but really don't know how to format the url, the pat...
-
Sylvain Roy commented, Boe Pedersen, I created a cube on dPeriod, as well as a measure on TheDate (DISTINCT COUNT), but I was not able to add any shared dimension on that cube. The result is that the count is OK for the ...
-
Sylvain Roy commented, I actually tried creating all combinations for 2 years and the ETL throws : 10:55:04.452 ERROR : Could not add SQL select TheDate, ItemNo, VariantCode, LocationCode10:55:04.453 from tItemLocation, ...