Viewing 7 posts - 1 through 7 (of 7 total)
You can find the latest price with the row_number window function:
WITH tmp AS( SELECT pt.ItemNbr, ...
May 25, 2021 at 1:26 am
I was not able to carry out the instructions as written. There was no way to specify a Name column. I created the named calculation as suggested but it took...
November 29, 2020 at 5:00 am
False alarm. I selected the wrong project. All is well. Thanks again to Jesus (De los Santos Rodriguez-360037, that is).
November 1, 2020 at 9:15 pm
Unfortunately, with that project I get this error while processing:
OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimTime'.; 42S02.
My DW2008R2 database has no DimTime but there is...
October 31, 2020 at 12:46 pm
It eventually took 5 hours and 6 minutes. I found the project in a folder sourceCode\sourceCode.zip\Kilimanjaro_RTM\AdventureWorks 2008R2 Analysis Services Project.
It is late now so I will try it tomorrow.
October 28, 2020 at 5:25 am
Thanks, Jesus. Your searching skills are better than mine. How did you find it?
Anyway, I am downloading it now. It is going to take about another 3 hours. Apparently the...
October 27, 2020 at 10:29 pm
Thanks, Jesus, but that link does not have what I need. That link points directly to various 2008R2 databases. At the top it has this link:
For multidimensional and tabular models,...
October 21, 2020 at 11:22 pm