Microsoft SQL - Analysis Services (SSAS, Cube)

SSAS deployment error: Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.

The first search on this error yielded some blog posts that says to check SQL server version. It suggested that I couldn't deploy a SSAS project originally set for SSAS 2008 to a SSAS 2008 R2, which didn't make sense to me. Combined with the fact that the error message was telling me to call customer support. Why do I need to call customer support unless something catastrophic happened?Turns out that one of the file on the SQL server is corrupt. I could simply delete the database on the SSAS server ......

Posted On Thursday, June 21, 2012 4:18 PM | Comments (0)

SSAS processing error: Client unable to establish connection; 08001; Encryption not supported on the client.; 08001

After getting the cube to successfully deploy and process on Friday, I was baffled on Monday that the newly added dimension caused the cube processing to break. I then followed the first instinct, discarded all my changes to reverted back to the version on Friday, and had no luck. The error message (attached below) did not help as I was looking for some kind of SQL service error. After examining the windows server log and the SQL server log, I just couldn't see anything wrong with it.After swearing ......

Posted On Thursday, June 21, 2012 4:09 PM | Comments (24)

Date Dimension: use date in YYYYMMDD format if your granular level is a single date

It still surprises me how many people set up the DateDimID as Identity(1, 1).If you use YYYYMMDD format, then on some reports, you can even display the date without navigating to the Date dimension to show label. In the same deal, you can use YYYYMM for a monthly date dimension, and YYYY for a yearly date dimension.[Update 2012-10-16]I now realize that what I said before was a clunky way to build dimension (hey I didn't say I was the expert. :D) And using only that argument going up against Kimball's ......

Posted On Wednesday, March 14, 2012 11:39 AM | Comments (0)

Data warehouse design principle, a very good post to always steer me back in the right direction

Whenever I start doubting my design of Data Mart or Cube, I always come back to this article and read it again.  It helps me keep my design simple.

http://dwbi1.wordpress.com/2010/06/17/one-or-two-dimensions/

Great post!

Related post:
http://dwbi1.wordpress.com/2011/02/26/denormalising-a-fact-table/

Posted On Wednesday, March 14, 2012 11:34 AM | Comments (0)

PowerPivot, Silverlight PivotViewer, Excel Services, Performance Point, Project Crescent from STL BI Use Group

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-... ......

Posted On Thursday, May 19, 2011 9:21 PM | Comments (0)

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski