Sylvain Roy
Comments
-
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...
-
Thanks for your input Femke. Could you elaborate on which two dates you would use? In the fact table, we only have one date which is the date at which the sales was posted. In the example below, yo...