Ranking within an hierarchy using DAX

  Hierarchy is one of the mostly wide functionalities in any model. So, the usual question will be how do you RANK a City across ALL the cities for sales or Country across all the Countries for sales .   Lets say I need to RANK the City for the Country which it belongs and…

2

Whats up with ALL(Table) + ALLExcept + ALL(Table[Column])

I was Quizzed with Ranks in DAX and during my exploration few intresting things were found. Here are my findings on how ALL and ALLExcept function behaves with contexts ! ALL(Table) will not apply for any of the contexts (Row,Query,Filter etc.)  ALLExcept (Table,Table[Column]) will apply the context only when Table[Column] is specified in any context…

0

To Hide Data Feed icon in Report Manager for Reporting services 2008 R2

Hi ,This is a Strange Requirement which my client asked me whether its achievable to Hide the Data feed icon shown in the ReportManager..As directed by my PM I said i will check it out and let you know..No commitments to client JLT is an advise to me by my PM . Here is how…

2

Hide the Drill through Action URL Link when Exported to Excel

Reporting services 2008 (and later Version) gives more flexibility by adding few fine things which will make a BI developer like me like the Product even more.SSRS 2008 2008 (and later Version) Provides Globals! Render.FormatName which decides what can be achieved to the Data Region (Table, matrix, Chart, Gauge, etc…) when Rendered in different formats….

0

How to Script Data from a Table ..?

Hi,Most of the time we need to script data of a table which holds configuration Values or Date Dimension Tables for later use….obvious that its a waste of space to take a entire database backup !….SQL Server provides a functionality to export table data (Insert Values script) to a .SQL file…Here is a Step by…

0

Asynchronous Output in SSIS

Hi Folks,I was supposed to do a Currency Currency Required for my Cubes.This Could have been achieved using Currency Conversion Methods in Cube itself.Thought of giving a try in ETL(Integration Services) itself as it will be easy and Fast. I am using a Asynchronous Buffer Output to achieve the Same.Unable to post the original Data…

0

Intresting Question on MDX !

There was an Interesting MDX Query Which i cam through in MSDN Forum Posted by Piasevoli thought its worth Sharing with All.. withmember [Product].[Product].[AllProducts] AS [Product].[Product].[All Products],BACK_COLOR =”&H0000D00D”MEMBER [Product].[Product].RemainderAS Aggregate( [Product].[Product].[Product].MEMBERS – EXTRACT( TOPCOUNT( [Date].[Fiscal Year].CURRENTMEMBER * NonEmpty([Product].[Product].[Product].MEMBERS, [Measures].[Internet Sales Amount]), 3, [Measures].[Internet Sales Amount] ) ,[Product].[Product]) ), BACK_COLOR =”&H0000FFFF” set TopSetWithReminder asGenerate( [Date].[Fiscal Year].[Fiscal…

0

Reporting Services – Running Total at Page Footer

I was questioned by my client to display the Running Total at the Page Footer ,Initially thought it was an easy task …Just Refer the Text Box where the field was Placed and do some small Rework would yield the Result,,But NO !!!! !!!It Turned out to be harder than what i expected.After some amount…

0

What’s with the Error Count in SSIS ?

I was in for a surprise when one of my team-mate threw me a requirement in SSIS. Let me brief the scenario …there are files in the FTP and it was supposed to load data from the flat files to the staging area with absolutely no change or transformation indeed a dump I call it…..

0

AND or OR in MDX !

Most of the time I encounter questions from MSDN users who often get confused with AND and OR behavior of MDX    

0