Data warehousing – Bringing down data twice but avoiding deleting on the data warehouse Fact Table
This is better explained with our example below. Example: · We had a situation where we were getting data down, but due to the nature of the data we were getting is we were missing data. · Also another note was the fact that we did not store the granular data, but aggregated the data, so due to this…
SSAS (SQL Server Analysis Services) – KPI – Comparing Date and Hour for the Previous Week or Multiple Values in your KPI Goal and Trend Expressions
What I wanted to do was to use a KPI in SSAS to compare values going back one week. But I wanted to get the same hour for the previous week. I could not find an example were it had used multiple values in a KPI Goal or Trend expression. All just used one value. Example: · For my…
SSAS (SQL Server Analysis Services) Tabular – Error when Processing – OLE DB or ODBC error: Server: The operation was cancelled by the user ..
The above error is caused when processing an SSAS Tabular database. NOTE:This only applies to when using MDX and an SSAS OLAP Cube to get your data into SSAS Tabular. NOTE 2:The reason that I use MDX and the SSAS OLAP Cube to get data in is for 2 reasons. · The first is that as we know it…