Demystifying SSAS Date Dimension Attribute Types

This spreadsheet (via Google Docs) is my attempt at organizing the SSAS date/time attributes. Note that the spreadsheet has four tabs. FEEDBACK AND SUGGESTIONS FOR IMPROVEMENT WELCOME. [Direct link: http://spreadsheets.google.com/pub?key=pIsKma8AZfzY_KETerdpcAA&gid=2]

Self-publishing

"[Why is it that] self-publishing an album is cool (indie), but self-publishing a book isn't ('vanity' press)." (Via @thecreativepenn on Twitter)

UPDATE: 2012-07 This isn't as true anymore. With the rise of ebooks self-publishing has gained more respect.

...but if you want to test a man's character...

"Nearly all men can stand adversity, but if you want to test a man's
character, give him PowerPoint." - N. Duarte (Via twitter user @gtdguy)

App Store Suggestion - Ability to Flag an App as Interesting

Often when I'm browsing the Apple App store I come across something that I might want to buy, but just not now. The app Baby Names Plus is an example: I heard about it on the Mac OS Ken podcast and thought it was interesting, but not interesting enough to drop the 2.99 on right now (I know, I'm cheap). What I would like is the ability to flag it as "I want to come back to this later." Perhaps each of the drop downs ("App Store," "Music," etc.) in the newest iteration of the App store could have an additional item in the list - "flagged apps" perhaps. Anyone from Apple reading this?

Columbus

In 1492, Columbus sailed the ocean blue. And then—wait...what rhymes with "genocide"? (via Twitter: http://twitter.com/fedge/status/4812255805 ) ... yea, I like black humor.

ADOS

ADOS ... Attention Deficite Ooooooh Shiny!! (found on Twitter)

No cube or table listed under the selected database in the Excel Data Connection Wizard

Problem: No cube or table listed under the selected database in the Excel Data Connection Wizard.

Solution: In Microsoft Visual Studio set the cube's "Visible" property to "True"; republish the cube

Recently I was trying to connect from a brand new Excel document to a cube I had created in Analysis Services.

Where the problem is: In Excel 2007...

• Select the "Data" ribbon
• Select "From Other Sources"
• Select "From Analysis Services"
• The "Data Connection Wizard" opens up
• On the "Connect to Database Server" pane enter your server name
• Click "Next"
• The "Select a Database and Table" pane displays
• Select your database from the "Select the database that contains the data you want"
• "Connect to a specific cube or table" should be checked
• No cube or table shows up

The solution:

• Open your Analysis Services cube project in Microsoft Visual Studio
• In the "Solution Explorer" double click on your cube ("MyCube" for example)
• The "MyCube.cube" tab opens up
• In the "Measures" pane (or "Dimensions" pane, or...) right click on your cube (the root node) and select "Properties"
• On the "Properties" pane set "Visible=True"
• Republish the cube

Good luck!