As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery mode. The in-memory analytics engine allows the users of Excel or Power View to base reports on tabular model objects. Having shown how to handle date-based information using the Multi-dimensional model, Dennes now turns his attention on the in-memory tabular model.
2016-03-31
4,032 reads
A method to create and populate Date and Time dimension tables for a data warehouse project.
2014-01-21
9,594 reads
Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes.
2013-02-04
791 reads
2011-05-31
6,069 reads
T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.
2011-07-04 (first published: 2010-06-14)
3,756 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-11-22
I'm going to be writing an ASP.net app in C# that stores scanned invoice images in a database along with some other information about the invoices in the record. If there were no images involved, I'd already be halfway done, but I just don't know how to work with them yet. I've been working with […]
2004-09-28
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-15
You cannot remove the identity property from a column. You can disable the property using SET IDENTITY INSERT.
2004-01-19
1 reads
quote: Tschuss (did I spell that right?) almost! I think the small mistake is due to a lack on your keyboard. Tschüss We german speaking ones take pride in having such a stupidity as letter ä, ö. ü. Very smart, indeed!!! And yes, it was not his granny, but his great grandmother. From time to […]
2003-08-14
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers