Comments for T-SQL.dk

Comment on Installing MS SQL Denali CTP3 failed by Siti

Siti — Tue, 15 May 2012 16:25:48 +0000

I have the same problem not haivng a tools option to remove, but I also do not have an item called SQL Server 2005 Management Tools Express item. Could you have possibly have meant SQL Server 2005 Management Studio Express. When I try to uninstall this one it tells me Microsoft Sql Server 2005 Tools is dependent on it. Did you get that as well. Thanks for this posting, I think it will get me closer to an answer.

Comment on SQLBits X – My almost final agenda by Fabiana

Fabiana — Tue, 15 May 2012 09:14:58 +0000

Thanks so much for this very informative. I know unndrstaed a little more about BISM and the two models in Denali. Now i need to install two instances of SSAS to get both models to play with! Doodles

Comment on “What should I do?” – Brett Favre by SQLBits X – My almost final agenda | T-SQL.dk

SQLBits X – My almost final agenda | T-SQL.dk — Tue, 27 Mar 2012 20:21:02 +0000

[...] the agenda for SQL Bits X was released, I had my take on what sessions I wanted to attend. Now, two full days ahead, I’ve managed to almost pin [...]

Comment on How to get SSAS to return the correct currency format. by Jens Vestergaard

Jens Vestergaard — Sun, 04 Mar 2012 22:14:33 +0000

Hi Chris,

I appreciate your feedback.
This particular example is to illustrate that it is possible to actually force a locale through. I’ve seen a lot of reports where the developer expected a different formatting based on the server settings, so from my point of view this was a re-occurring issue.
Of course, as you point out, this fails to support multiple locales in the cube. And make no mistake, I think your point is very accurate and when applicable, should be applied.

The deal behind the MDX construct in this example is, that a single MDX is injected with meta data about how the report, in this case every KPI of a dashboard, should be not only formatted, but also what KPI is to be displayed, what slicers are to be applied and so forth. So really, the solution runs with one currency only, but the MDX doesn’t know until runtime if the formatting is ‘Currency’ or ‘#.###.##’ or some third predefined formatting mask. The locale identifier injected is actually, now that I think it through once more, not driven by meta data – this might be something that needs to be changed (that way the data steward will be able to control what locale identifier is to be used on any given KPI).

/Jens

Comment on How to get SSAS to return the correct currency format. by Chris Webb

Chris Webb — Sun, 04 Mar 2012 21:37:20 +0000

Hi Jens,

It’s probably just easier to set the currency symbol you want to use in the format string you’re using for your measure, eg ‘£#,#.00′. If you rely on the ‘Currency’ format and setting the language then you end up changing the thousands and decimal separator as well, and that’s not a good thing if you have multiple currencies in the cube: http://cwebbbi.wordpress.com/2008/04/24/currency-formats-should-they-be-tied-to-language/

Chris

Comment on Installing MS SQL Denali CTP3 failed by Jens Vestergaard

Jens Vestergaard — Tue, 09 Aug 2011 22:13:41 +0000

Hi Lester
Yes, I have seen the reply @ms forum, just haven’t had the time to test it. I’m pretty sure though that it’ll work.
I will be sure to check up as soon as possible

Best regards
Jens

Comment on Installing MS SQL Denali CTP3 failed by Sam Lester (MSFT)

Sam Lester (MSFT) — Tue, 09 Aug 2011 17:32:06 +0000

Hi Jens, I replied on the forums to your question a couple days ago. If you’re still hitting the problem, take a look here and see if the skiprule command can get you going again:
http://social.msdn.microsoft.com/Forums/en-US/sqldensetup/thread/e8d9f807-af36-4a51-91be-bac2013c6cb7

Thanks,
Sam Lester (MSFT)

Comment on MDX Query using other hierarchy in same dimension as in slicer by dotdottelot

dotdottelot — Mon, 18 Apr 2011 07:17:53 +0000

Hi Hrvoje

Right now I’m “systems off” e.g on vacation, but I am almost certain I tried what you suggest. I Will although try it once I’m back. Thanks for the heads up

Comment on MDX Query using other hierarchy in same dimension as in slicer by Hrvoje Piasevoli

Hrvoje Piasevoli — Sun, 17 Apr 2011 21:26:52 +0000

Hi,
There is a simpler method: Just use [Date].[Calendar Week].CurrentMember
Example:
WITH
MEMBER [Measures].[Test] AS
( EXISTS([Date].[Calendar Week].Members, [Date].[Calendar].CurrentMember).Item(1), [Measures].[Internet Sales Amount])

MEMBER [Measures].[Test 1] AS
( [Date].[Calendar Week].CurrentMember, [Measures].[Internet Sales Amount])

SELECT
{[Test], [Test 1]} ON COLUMNS
FROM [Adventure Works]
WHERE { [Date].[Calendar].[Date].&[20070201] }

Kind regards,
Hrvoje Piasevoli

Comment on A rather unfortunate bug… But aren’t they all? by Bryan

Bryan — Sat, 05 Mar 2011 03:27:02 +0000

Hello my name is Bryan and I am the charting evangelist for DevExpress. If you have some time to chat I’ve handed this off to our dev team and they are looking into it further. Any other information you could add would be very helpful. Additionally if you have any other questions I’d be happy to help.

Thanks,

Bryan

Comment on Competing for a free seat on Internals and Performance class by SQLSkills by Tweets that mention Competing for a free seat on Internals and Performance class by SQLSkills « dotdottelot dot blog -- Topsy.com

Mon, 24 Jan 2011 15:24:03 +0000

[...] This post was mentioned on Twitter by Paul Randal, Jens Vestergaard. Jens Vestergaard said: Competing for a free seat on Internals and Performance class by SQLSkills: http://wp.me/p7GaN-3n #sqlskills [...]

Comment on Restored database konflikter med et opdaterings deploy fra VS DB Ed. by envenoneorn-web

envenoneorn-web — Tue, 08 Dec 2009 04:09:25 +0000

hvad jeg ledte efter, tak

Comment on Players Handbook 4th. ed. by dotdottelot

dotdottelot — Wed, 27 Aug 2008 10:40:27 +0000

Ja, jeg er nu ikke fra Horsens. Bor i Brønshøj.
Jeg var blot forbi Horsens, tilfældigt, da der blev afholdt middelalder-uge.

Jeg håber du finder en gruppe i Horsens, så du kan komme i gang.

Ang. 4th ed. så opgraderer vi nok ikke, da der er en generel holdning om at de nye regler lægger for mange bånd på figurerne. Der er meget mere alsidighed i 3rd ed.

Comment on Players Handbook 4th. ed. by Rasmus

Rasmus — Wed, 27 Aug 2008 10:17:46 +0000

Hey.

Du skriver om rollespil og horsens.
Jeg er tilflytter til Horsens og søger en gruppe til lidt rollespil.
Evt. skriv til mig på rasped@hotmail.com

Comment on About by bibomedia.com

bibomedia.com — Fri, 07 Mar 2008 11:45:34 +0000

Comment on Visual Studio 2008 by Jonas Cronfeld

Jonas Cronfeld — Sat, 16 Feb 2008 11:26:35 +0000

… og herfra lyder det at vi holder Danmarks første kursus om Visual Studio 2008 d. 13 marts

Comment on Ascaso Arc Fun by dotdottelot

dotdottelot — Tue, 08 Jan 2008 07:24:49 +0000

Friskere bliver det vist ikke nu!?

http://dotdottelot.wordpress.com/2007/12/30/i-roast-2/

Comment on Ascaso Arc Fun by Anonymous

Anonymous — Thu, 03 Jan 2008 19:26:53 +0000

Du burde da ofre dig selv at prøve med noget friskristet kaffe, hvis du jagter den perfekte kop. For mig betyder det alt at kaffen er frisk (mellem ca. to og otte dage)

Comment on MCTS 70-445 by Sådan kan man jo blive så kåd… « Dotdottelot-blog

Sådan kan man jo blive så kåd… « Dotdottelot-blog — Fri, 05 Oct 2007 12:13:17 +0000

[...] In Programmering | Tags: Certificering, Data Mining, DMX, MCP, SSAS, SSIS, SSRS Var til den famøse certificering i dag, men bestod ikke. Der skulle også have været en god portion hjælp fra opgavestillerne, [...]