http://www.sqlmag.com/authors/author/author/5033871/rsscomment/5033871en-USFri, 25 May 2012 10:26:06 GMTFri, 25 May 2012 10:26:06 GMThttp://www.sqlmag.com/article/data-modeling/financial-reporting-with-analysis-services#commentsAnchorMon, 28 Feb 2005 06:25:39 GMT
I am a novice at AS and still do not understand how to restore the sample database. Which file "isn’t .CAB" ? Whan I browse from Analysis Manager to restore that database it only allows selection of CAB files.]]>bredinsMon, 28 Feb 2005 06:25:39 GMThttp://www.sqlmag.com/article/data-modeling/financial-reporting-with-analysis-services#commentsAnchorhttp://www.sqlmag.com/article/quering/what-time-is-it-#commentsAnchorFri, 02 Apr 2004 08:48:23 GMT
Article very good. I am looking for how can I design my time dimension or query my cube to get averages for the 6 or 12 last months. The last six months includes months of the current and previous year or days of the current and previous months.]]>Roberto Barrantes Fri, 02 Apr 2004 08:48:23 GMThttp://www.sqlmag.com/article/quering/what-time-is-it-#commentsAnchorhttp://www.sqlmag.com/article/data-modeling/financial-reporting-with-analysis-services#commentsAnchorTue, 30 Mar 2004 07:22:04 GMT
You can restore the database, the file isn’t .CAB!!!]]>Oded Dror Tue, 30 Mar 2004 07:22:04 GMThttp://www.sqlmag.com/article/data-modeling/financial-reporting-with-analysis-services#commentsAnchorhttp://www.sqlmag.com/article/data-modeling/financial-reporting-with-analysis-services#commentsAnchorThu, 25 Mar 2004 07:51:30 GMT
While I like the article, unfortunately I am unable to use the downloaded code. The article says: "To use the sample databases, download the .zip file at InstantDoc ID 41783, open the file in a directory of your choice, and restore the OLAP database." But it does not explain how. In the analysis services if you have to restore an OLAP database, it asks for a file with a .cab extension but when the downloaded zipped file is unzipped I observe that there are several files with different extensions and as such neither the article tells you how to restore the OLAP database, nor can I find a suitable method in the Analysis services to restore from those files. I was even trying to find a readme file but I could not find any. Could you please let me know as how I can restore the OLAP DATABASE from the several files that I have. THANKS]]>ROY SINGER Thu, 25 Mar 2004 07:51:30 GMThttp://www.sqlmag.com/article/data-modeling/financial-reporting-with-analysis-services#commentsAnchorhttp://www.sqlmag.com/article/database-development/customize-time-dimension-member-names#commentsAnchorFri, 21 Dec 2001 08:36:23 GMT
This is one of the best articles I have seen on Analysis Services Time dimensions. Well done Mr.Levin, please continue in this vein.]]>Chris McDermott Fri, 21 Dec 2001 08:36:23 GMThttp://www.sqlmag.com/article/database-development/customize-time-dimension-member-names#commentsAnchorhttp://www.sqlmag.com/article/database-development/the-right-place-for-calculated-members#commentsAnchorTue, 24 Jul 2001 11:33:12 GMT
This is a litlle vague. How exactly is the dimension added?]]>Tim Harris Tue, 24 Jul 2001 11:33:12 GMThttp://www.sqlmag.com/article/database-development/the-right-place-for-calculated-members#commentsAnchor