Browse Site by Tags

Showing related tags and posts accross the entire site.

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 , RepricingAmount2 int , RepricingAmount3 int ); GO...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 12-15-2008
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 sales for the dates specified by the user in the report...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 11-09-2008
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 as much possible. Rephrased to Adventure Works...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 10-23-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 (MDM) to draw a comparison with the Unified Dimension...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 10-06-2008
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 work; or rather Excel sorts them as strings. That's...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 09-10-2008
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 change the captions of certain calculated members...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 09-01-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 the SUM function to display empty. Steps to repro...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 08-15-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 "Sign in as a different user" feature...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 08-11-2008
Re: Actions and Stored procedures

Hi Teo, Thank you very much for the quik reply. Your comments are true. On week end i also find that drillthrough has a requirement that no more than one member can be specified for each axis. (as in MDX Soultions by Wiley, page 414). Thanks once again for the code posted by you to capture current context...

Posted to Applied Microsoft Analysis Services 2005 (Forum) by sanjay on 08-04-2008
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 2005 Analysis Services on Microsoft Windows Server...

Posted to Prologika (Teo Lachev's Weblog) (Weblog) by tlachev on 08-01-2008

Page 1 of 7 (64 items) 1 2 3 4 5 Next > ... Last »