Sign in
|
Join
|
Help
in
Current Tags
Prologika (Teo Lachev's Weblog...
Prologika
(Entire Site)
Prologika Forums
Business Intelligence to the Masses
Home
Blogs
Media
Forums
Prologika
This Blog
Home
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
Dimensionalizing Pivoted Measures
Referencing Parameters in SSRS Calculated Members
SSAS WHERE vs. Subselect Puzzle
Memory-based Dimensional Model (MDM) on the Horizon
Sorting Dates in a PivotTable Report
Tags
.NET
Analysis Services
Articles
Business Intelligence
General
Kilimanjaro
Microsoft Office
Reporting Services
SharePoint
SQL Server 2008
Writing
News
Visit prologika.com for information about Teo's publications, the latest on the Microsoft Business Intelligence initiative, and more...
Reporting Services Links
Reporting Services Home Page
Reporting Services Public Newsgroup
Brian Welcker's Blog
Tudor Trufinescu's Blog
Chris Hays's Blog
Lukasz Pawlowski's Blog
Bob Meyer's Blog
Reporting Services Team Blog
Reporting Services User Education Blog
Russell Christopher's Blog
Robert Bruckner's Blog
Chris Baldwin's Blog
John Gallardo's Blog
Robert Bruckner's Blog
Reporting Services MSDN Public Forum
Analysis Services Links
Home Page
Public newsgroup
Mosha Pasumansky's Site
SQL Server Analysis Services Site
Data Mining Site
Mosha Pasumansky's Blog
Marco Russo's Blog
Dejan Sharka's Blog
Chris Webb's BI Blog
Blog Roll
Microsoft Excel 12
MSDN RSS Feeds
Kent Tegel's Blog
Karen Watterson's Blog
Nick Barclay's BI Blog
Archives
January 2009 (1)
December 2008 (2)
November 2008 (3)
October 2008 (5)
September 2008 (3)
August 2008 (10)
July 2008 (4)
June 2008 (4)
May 2008 (4)
April 2008 (2)
March 2008 (2)
February 2008 (2)
January 2008 (2)
December 2007 (5)
November 2007 (3)
October 2007 (2)
September 2007 (4)
August 2007 (11)
July 2007 (5)
June 2007 (5)
May 2007 (5)
April 2007 (9)
March 2007 (9)
February 2007 (6)
January 2007 (3)
December 2006 (4)
November 2006 (6)
October 2006 (5)
September 2006 (6)
August 2006 (5)
July 2006 (6)
June 2006 (8)
May 2006 (3)
April 2006 (6)
March 2006 (6)
February 2006 (7)
January 2006 (8)
December 2005 (14)
November 2005 (11)
October 2005 (1)
September 2005 (3)
June 2005 (8)
May 2005 (5)
April 2005 (1)
March 2005 (1)
February 2005 (1)
January 2005 (3)
December 2004 (4)
November 2004 (1)
October 2004 (2)
September 2004 (4)
August 2004 (9)
July 2004 (1)
Prologika (Teo Lachev's Weblog)
Teo Lachev is a consultant, mentor, and author focusing on the design and development of Microsoft .NET business intelligence solutions. Read about Teo's work and life. Registered users can post comments.
Browse by Tags
All Tags
»
Analysis Services
(
RSS
)
Articles
Business Intelligence
General
Kilimanjaro
Reporting Services
SharePoint
SQL Server 2008
Writing
Dimensionalizing Pivoted Measures
Issue You have a table with pivoted measures, such as: Use the following statement to create and populate the table: CREATE TABLE pvt ( VendorID int , DateID int , MaturityAmount1 int , MaturityAmount2 int , MaturityAmount3 int , RepricingAmount1 int...
Posted
Dec 15 2008, 07:43 PM
by
tlachev
with | with
no comments
Filed under:
Reporting Services
,
Analysis Services
,
Business Intelligence
Referencing Parameters in SSRS Calculated Members
Issue : You author an SSRS report that connects to a cube. You want to create a calculated member that uses a report parameter. For example, the Selector calculated member in the following query returns 1 if a given employee has exceeded 1 million in...
Posted
Nov 09 2008, 07:09 PM
by
tlachev
with | with
no comments
Filed under:
Reporting Services
,
Analysis Services
SSAS WHERE vs. Subselect Puzzle
I've been involved recently in a quest to optimize an SSAS 2008 long-running query that would return the 12-month history of a KPI. Since the KPI was displayed on a dashboard page alongside other KPIs and charts, it was important to optimize the query...
Posted
Oct 23 2008, 08:53 AM
by
tlachev
with | with
no comments
Filed under:
Analysis Services
,
SQL Server 2008
Memory-based Dimensional Model (MDM) on the Horizon
As the news arrived today (see Mosha Pasumansky blog , Chris Webb blog , and Marco Russo blog ) , the BI Conference revealed what has been brewing for a while in the Microsoft BI nest. Project Gemini, which one may call Memory-based Dimensional Model...
Posted
Oct 06 2008, 09:27 PM
by
tlachev
with | with
1 comment(s)
Filed under:
Analysis Services
,
Kilimanjaro
Sorting Dates in a PivotTable Report
Issue: You use Excel as an OLAP browser connected to an SSAS cube. You've defined the name of the Month attribute in the Date hierarchy in the format MMM-YYYY. While months are sorted in an ascending order in Excel, descending sorting doesn't...
Posted
Sep 10 2008, 09:06 PM
by
tlachev
with | with
no comments
Filed under:
Analysis Services
Personalized Cubes
Scenario: You need to personalize the captions of calculated members or/and KPIs of an SSAS cube. For example, a solution vendor may need to deploy a cube to multiple clients. Instead of maintaining separate cube definitions, the vendor may prefer to...
Posted
Sep 01 2008, 09:33 PM
by
tlachev
with | with
no comments
Filed under:
Analysis Services
,
SQL Server 2008
Nasty SSAS 2008 Bug
There is a nasty known bug with SSAS 2008, where if a query that requests two measures with Sum and LastNonEmpty aggregate functions side by side and the query uses NON EMPTY (which all OLAP clients use by default), the server forces the measure with...
Posted
Aug 15 2008, 08:11 AM
by
tlachev
with | with
1 comment(s)
Filed under:
Analysis Services
,
SQL Server 2008
Static Credentials
A new week comes with new issues... I ran into an interesting issue today with Windows integrated security and SharePoint. I was troubleshooting an issue on a behalf of a Windows user that connects to an SSAS server. To repro the issue, I used the SharePoint...
Posted
Aug 11 2008, 10:08 AM
by
tlachev
with | with
no comments
Filed under:
Analysis Services
,
SharePoint
Yet Another Post About Analysis Services HTTP Connectivity
With risk to iterate the obvious, here is a lesson learned from the trenches: Scenario : You want to let external users browse an Analysis Services cube over the Internet. Setup : You have followed the steps in the Configuring HTTP Access to SQL Server...
Posted
Aug 01 2008, 10:30 PM
by
tlachev
with | with
2 comment(s)
Filed under:
Reporting Services
,
Analysis Services
Microsoft SQL Server 2008 Feature Pack RC0, June 2008
Today, Microsoft released an updated feature pack for SQL Server 2008 RC0. Among other things, it includes: A web downloadable installer for Report Builder 2.0 which is not included anymore with the SQL Server 2008 setup An updated version of the RS add...
Posted
Jun 10 2008, 07:51 AM
by
tlachev
with | with
no comments
Filed under:
Reporting Services
,
Analysis Services
,
Business Intelligence
,
SQL Server 2008
Intelligencia Query
Chris Webb, a fellow MVP and MDX guru, who's blog is a must-read for all SSAS junkies, was kind enough to let me take a look at the Intelligencia Query product he's been working on for a while with Andrew Wiles. Chris announced the product back...
Posted
May 14 2008, 10:37 PM
by
tlachev
with | with
9 comment(s)
Filed under:
Reporting Services
,
Analysis Services
,
Business Intelligence
SSAS HTTP Connectivity and SharePoint
Scenario You won't enable SSAS HTTP connectivity via a SharePoint site. Issue You followed the instructions in the Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003 whitepaper but you get " Failed to...
Posted
May 12 2008, 07:58 AM
by
tlachev
with | with
1 comment(s)
Filed under:
Analysis Services
Applied Microsoft Analysis Services 2005 Goes E-Book
I happy to announce my book "Applied Microsoft Analysis Services 2005" is now available as an Adobe PDF e-book. The first retailer that Google Alerts reported to sell it is Diesel Ebooks . It should soon pop up on all popular ebook retailer...
Posted
Mar 27 2008, 08:16 AM
by
tlachev
with | with
no comments
Filed under:
Writing
,
Analysis Services
,
Business Intelligence
Last Non Empty Affairs
Enterprise Edition of Analysis Services 2005 and 2008 supports semi-additive functions, such as LastNonEmpty, LastChild, and so on, to facilitate working with semi-additive measures, such as account balances and inventory snapshots. For example, the screenshot...
Posted
Feb 06 2008, 06:51 PM
by
tlachev
with | with
no comments
Filed under:
Analysis Services
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques Whitepaper Available
The Microsoft CAT team has released a new whitepaper Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques. "Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model...
Posted
Dec 21 2007, 07:54 PM
by
tlachev
with | with
no comments
Filed under:
Analysis Services
More Posts
Next page »
Copyright © 2005 Prologika, LLC