Log in | Register

Suhas Kudekar, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Suhas Kudekar, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

SuhasKudekar

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

About Suhas Kudekar

This author has not yet filled in any details.
So far Suhas Kudekar has created 6 entries.

PowerPivot and PowerView now available in Excel 2013

In Excel 2013, much of that functionality, including the infrastructure that supports it, is built directly into the Data Model in Excel. Without installing a separate add-in, PowerPivot and PowerView add-ins are installed by default. But they are not automatically enabled.  You have to do some menu/dialog box acrobatics to turn them on, but […]

By |August 1st, 2012|Categories: SQL Server|Tags: , , |0 Comments

Get comma separated list in SQL and MDX.

To get comma separated list in SQL as well as in MDX use below queries.

1 – SQL

Select Name from Sales.SalesReason

GO

Select Name from Sales.SalesReason

SELECT

SUBSTRING

(

(

SELECT

‘,’ + s.Name

FROM

Sales.SalesReason  s

ORDER BY

s.Name

FOR XML PATH(”)

)

,2,200000 ) AS NAME

2 – MDX

WITH

SET [COMMA] AS [Sales Reason].[Sales Reasons].[Sales Reason].MEMBERS

MEMBER [MEASURES].[COMMATEST] AS

Generate

(

[COMMA]

,[COMMA].CurrentMember.Name

,”,”

)

SELECT

NON EMPTY

{

[MEASURES].[COMMATEST]

} ON 0

FROM

[ADVENTURE WORKS];

 

Regards

Suhas Kudekar

Like us on FaceBook  |  Follow us on […]

SQL Server – Change the Look & Feel of the Report Manager.

Why we need to change the Look & Feel of the Report Manager?

Ans- If we have different environments to deploy the reports like QA, DEV, PROD. that time User/Developer can get the more idea once open the Report Manager.

First we need to get some definition of what is Report manager.

Definition – Report Manager is […]

By |June 6th, 2012|Categories: SQL Server|Tags: |0 Comments

SQL Server – SQL+MDX in one Apartment (Hybrid Query).

While replying on the MSDN Forums Most of the time people ask on how to write SQL+MDX both in single place means.

1-      Certain data like aggregated data from MDX Query.

2-      Select that data from SQL Query and get these data in table to show on reports.

I already answer couple of the question on forums […]

By |May 25th, 2012|Categories: SQL Server|Tags: |4 Comments

SQL Server – VertiPaq Engine Renamed as xVelocity in SQL Server 2012.

VertiPaq engine is currently only available to PowerPivot for Excel in SQL Server 2008 R2. After the amazing success of PowerPivot for Excel in the previous release of SQL Server 2008 R2 this engine moved to the server side with the same InMemory BI and compression and it’s called the VertiPaq Engine or the […]

No More BIDS Exist in SQL Server 2012

Once you will installed SQL Server 2012 you could not find the BIDS to develop SSAS/SSIS/SSRS application. BIDS will replace with SSDT i.e. SQL Server Data Tools. Comparison of SQL Server 2012 Vs SQL Server 2008 R2. You can get more idea on below Screen shot how SQL Server 2012 looks compare with SQL […]

By |May 24th, 2012|Categories: SQL Server|Tags: |0 Comments
Newsletter_Footer