THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Reporting Services   (RSS)
Showing page 1 of 2 (16 total posts)
  • Write DAX queries in Report Builder #ssrs #dax #ssas #tabular

    If you use Report Builder with Reporting Services, you can use DAX queries even if the editor for Analysis Services provider does not support DAX syntax. In fact, the DMX editor that you can use in Visual Studio editor of Reporting Services (see a previous post on that), is not available in Report Builder. However, as Sagar Salvi commented in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 21, 2014
  • Review of the book SQL Server 2012 Reporting Services Blueprints

    Recently I had the opportunity to read the book SQL Server 2012 Reporting Services Blueprints written by Marlon Ribunal and Mickey Stuewe and published by Packt Publishing. First, I have to tell you that I am not a Reporting Services guy, I have much more knowledge on other topics such as Database Development, Performance Tuning, and so on. ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on January 25, 2014
  • Microsoft BI Security White Paper #ssas #powerpivot #sharepoint #ssrs

    There is a new whitepaper from Microsoft, Microsoft BI Authentication and Identity Delegation, which describes all the authentication and delegation scenarios with Microsoft BI technologies: Personal BI Scenarios (Excel) Team BI Scenarios (SharePoint) Corporate BI Scenarios (Reporting Services, Analysis Services) Federated BI ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 11, 2013
  • BonaVista Dimensions used as a report service

    Recently I have seen a long demo of BonaVista Dimensions. It is a product that is able to create reports and, most important dashboards. You can use it also without SQL Server and Analysis Services, just by importing data in a local cube file that you can model using its own simple to use user interface. But what is interesting to me (in this ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 26, 2011
  • The Microsoft BI Roadmap: BISM, UDM and Beyond

    Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 15, 2010
  • Reporting Services, MDX and the (unwanted) cascading parameters

    Reporting Services can be used in conjunction with Analysis Services, creating powerful reporting solution that can satisfy almost  any customer needs for “standard” reporting. For “standard” I mean solutions that has not be created using Excel and a Cube to give the user complete freedom (and responsibility) over data. In one of our current ...
    Posted to Davide Mauri (Weblog) by manowar on August 10, 2010
  • PASS Summit 2010 – BI Workshop

    PASS Summit 2010 Pre & Post conference are out! This year I’ll deliver the “Creating BI Solution from A to Z” seminar in which, as the title implies, attendees will see how to create a BI solution starting from scratch. Going through the dimensional modeling and the creation of the Datawarehouse, the implementation of the ETL process with ...
    Posted to Davide Mauri (Weblog) by manowar on June 30, 2010
  • “Excel found unreadable content” when exporting a Reporting Services report

    [This is just a quickie, I’m putting it up here for anyone that received the messages above and searches for it online!] Earlier today my team experienced some issues with a Reporting Services report that when attempting to export to Excel would cause Excel to throw the error “Excel found unreadable content” (I really should have got a screenshot ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 22, 2010
  • Custom Aggregations Values in SQL Reporting Services with Tablix Filters

    In these last days I’ve been working on a BI solution for a logistic company. One report I have to create has a particular behavior that can make life a little complex if you’re using Reporting Services: the value used in rows and column totals is not calculated in any way, but is just taken from the database (SSAS in this case), just like any ...
    Posted to Davide Mauri (Weblog) by manowar on July 24, 2009
  • Reporting Services and the WriteChunkPortion stored procedure

    Reporting Services (2005) uses the ReportServerTempDb database to store cached reports and temporary snapshots. Two of the stored procedure calls I see are WriteChunkPortion and ReadChunkPortion. Because I see that the MS ASP Session state manager also use the WriteChunkPortion call, and the parameter values, I am inclined to think these ...
    Posted to Joe Chang (Weblog) by jchang on August 5, 2008
1 2 Next >
Privacy Statement