Sylvain Roy
Comments
-
Looking forward to test this!
-
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...
-
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...
-
Is there documentation somewhere on the Aggregate type option of a measure? Specially the Custom one? An how about the Partition by one?
-
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...
-
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:\...
-
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 ...
-
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 ...
-
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, ...
-
Thanks much for your input Femke. The datamodel looks like this: The calendar table is dPeriod and the fact table is fValueEntry. The other dimension tables contains information about the items so...