Rakesh Ramblings

All you need to know about Microsoft Business Intelligence !
  • Rakesh Ramblings

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

    • 0 Comments
    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...
  • Rakesh Ramblings

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

    • 1 Comments
    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...
  • Rakesh Ramblings

    Hide the Drill through Action URL Link when Exported to Excel

    • 0 Comments
    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...
  • Rakesh Ramblings

    How to Script Data from a Table ..?

    • 0 Comments
    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...
  • Rakesh Ramblings

    Asynchronous Output in SSIS

    • 0 Comments
    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...
  • Rakesh Ramblings

    Intresting Question on MDX !

    • 0 Comments
    There was an Interesting MDX Query Which i cam through in MSDN Forum Posted by Piasevoli thought its worth Sharing with All. . with member [Product].[Product].[AllProducts] AS [Product].[Product].[All Products] ,BACK_COLOR ="&H0000D00D" MEMBER...
  • Rakesh Ramblings

    Reporting Services - Running Total at Page Footer

    • 0 Comments
    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...
  • Rakesh Ramblings

    What’s with the Error Count in SSIS ?

    • 0 Comments
    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...
  • Rakesh Ramblings

    AND or OR in MDX !

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

    Dynamic Link Libraries to find current month in SSAS

    • 0 Comments
    Here is My thought on using .dll to find the Current Month in an Easy Way ! Way of Finding Current Month Using SSAS Assemblies Context:Instead of Burdening Your SQL Engine and Analysis Engine to get the CurrentMonth by Creating a View and Adding the Attribute...
  • Rakesh Ramblings

    Load Cube Metadata Into SQL database

    • 0 Comments
    Howdy Folks ! Hope this will be Helpful Way of Finding Cube Meta Data Using SSIS Script Task Context: To Find the Metadata about the Analysis Services Cube Many Approaches can be taken. This Approach Doesn’t Store Cube Metadata in the Cube itself...
Page 1 of 1 (11 items)