If you have worked with Analysis Services dimension data security for a while, you know that MDX allowed/denied set expressions can become rather complex. You might be tempted to externalize these expressions in the cube script for brevity or reusability reasons. For example, you might decide to add a calculated member that returns a list of allowed partners that the user is authorized to see…
Read articleAll TechEd 2011 breakout sessions are available online on MSDN Channel9 website. Here the links to mine: Top 10 Reasons to Upgrade to Microsoft SQL Server 2008/R2 Reporting Services Can Your BI Solution Scale? Enjoy and vote!
Read article
While I've been busy at TechEd talking to BI enthusiasts, professionals and wannabes and delivering sessions, the news is out about the new BI roadmap and BISM positioning. See: T.K. Anand blog T.K. Anand & Ashvini Sharma recorded session What's New in Microsoft SQL Server Code-Named "Denali" for SQL Server Analysis Services and PowerPivot"? Sean Boon, Carolyn Chao, and Sabrena McBride recorded session Abundantly "Crescent":…
Read articleThe slides and source code for my TechEd 2011 North America session are available for download on the Prologika website (requires registration). If you haven't registered, please click the Join link in the upper right corner. My breakout sessions are: DBI205 - Top 10 Reasons to Upgrade to Microsoft SQL Server 2008/R2 Reporting Services Rich in demos, this session presents top reasons to upgrade to…
Read articleWatching the TechEd keynote during which it was announced that we have some 10,000 people attending TechEd this year. On the BI side of things, Amir Netz, Distinguished Engineer at Microsoft, came on stage to unveil some of the new features coming up in Denali and demonstrate the BI continuum story in Denali (PowerPivot, SharePoint with Crescent reporting, and Corporate BI). The Corporate BI model had some 2…
Read articleMy TechEd sessions got finalized. This would be my sixth TechEd to go to and present at (this one conveniently located in my home city). This time I am honored to have three sessions (two breakout sessions and one interactive session). You can't attend, you should be able to find me hanging around at the DBI booth. Code Session Day Time DBI205 Top 10 Reasons…
Read articleAfter dropping the Microsoft Business Intelligence Indexing Connector, Microsoft is working on an advanced content crawler, code-named Project Barcelona, that will index BI content, such as SQL Server, Excel, SharePoint, Reporting Services, Analysis Services, SSIS. Although initially aimed at DBA/ETL developers, its ambitions go well beyond that. According to the team blog, "At the end of the day, we want to build a set of…
Read article
