Forum Replies Created

Viewing 15 posts - 1 through 15 (of 23 total)

  • RE: MDX for Cube Measure Based on Dimension Value

    happycat59 (1/15/2014)

    How about

    SUM ( { [Billing Type].[Type].&[Bill] } , [Measures].[Hours] )

    That did it.

    I have really got to get through some MDX courses. Self-taught or otherwise.

    Thank you....

    January 15, 2014 at 7:53 pm

    #1680491

  • RE: SQLServerCentral apologizes and you can win a book

    Kudos to SSC for being on top of this and going above and beyond.

    Here is some SQL I use to calculate a rolling P95 average.

    Rob

    SELECT DISTINCT

    DATEADD(M,T.N - 1, TD.First_Worked) as...

    December 5, 2013 at 8:16 am

    #1671128

  • RE: Fact Table Not Processing

    hrvoje.piasevoli (11/8/2012)

    Hi Rob,

    That number converted to something understandable is roughly 270 years!? For a service request? 🙂

    The easiest way to see if your processing is failing because of this number...

    November 9, 2012 at 7:26 am

    #1557600

  • RE: Unsure about relationship with Slowly Changing dimensions.

    Martin Schoombee (10/22/2010)

    No, you shouldn't have an extra entry in the fact table...because there isn't another transaction for that amount and your numbers will double when aggregated.

    Martin - thank you...

    October 22, 2010 at 12:54 pm

    #1241132

  • RE: Unsure about relationship with Slowly Changing dimensions.

    PugMaster (7/7/2010)

    Hi

    Sorry datawarehouse newbie question! I am not sure how to maintain the relationship between Fact and Type 2 Dimension.

    i.e if a new row is inserted into a dimension table...

    October 21, 2010 at 9:10 pm

    #1240690

  • RE: Large Update Not Working

    Jeffrey Williams-493691 (10/3/2010)

    Try removing the begin tran and commit tran - every time you run your update, the same rows are selected because the update hasn't actually committed the changes...

    October 4, 2010 at 6:14 am

    #1230937

  • RE: Large Update Not Working

    Thank you for your offer of assistance. Below is the code for the two tables. Attached is a sample of the data from the tables.

    In the interest of...

    October 3, 2010 at 4:45 pm

    #1230804

  • RE: DB Uses HUGE Amounts of Unallocated Space

    Markus (8/30/2010)

    Do you have an auto rebuild indexes task running? That would explain it.

    Yes. On Sundays, an SSIS package runs that checks DB integrity, rebuilds the indexes and...

    August 30, 2010 at 9:46 am

    #1213806

  • RE: Convert seconds to a timestring

    Keep in mind that this only works up to 23:59:59. Anything greater than or equal to 24 hours (86,400 seconds) will not work. I have reports were we...

    May 5, 2010 at 1:04 pm

    #1162712

  • RE: Reference Cell Value Without Explicit Reference

    nigel.c.west (2/17/2009)

    As far as I know there is no method available to create a "standard" conditional format based on a Cell value, because the concept of cell value just doesn't...

    February 17, 2009 at 8:18 am

    #945229

  • RE: Call Value from Another Cell

    Jack Corbett (9/8/2008)

    I think you can use the ReportItems Collection. So the expression, using your example below, would be:

    ReportItems!TextBox1.Value/ReportItems!TextBox2.Value

    I could remember reading about the ReportItems collection but could not...

    September 8, 2008 at 8:32 am

    #868483

  • RE: Reporting Services problem with extract Excel

    David Klug (9/4/2008)

    Have you considered moving to SQL Server 20008 for the Report Server? It is no longer restricted by memory and on initial tests I've run, I've been...

    September 4, 2008 at 8:37 am

    #867182

  • RE: Reporting Services problem with extract Excel

    Robert Hake (9/4/2008)

    I am having similar problems where both running reports and exporting reports will cause a prompt to login. Using Task Manager, I checked my servers memory and...

    September 4, 2008 at 6:54 am

    #867094

  • RE: Reporting Services problem with extract Excel

    David Klug (6/26/2008)

    This is a known issue with SSRS 2005 and earlier; Reporting Services is memory dependent. On very large reports, you are consuming all available RAM and the...

    September 4, 2008 at 5:45 am

    #867043

  • RE: SSIS Where Clause w/ Date Functions

    Mazharuddin Ehsan (8/27/2008)

    Yes you are right. But it is surprising that LAST_UPDATED_DATE is not a Date field.

    I feed data from Oracle into SQL Server. When I started with SQL...

    August 27, 2008 at 7:01 am

    #863689

Viewing 15 posts - 1 through 15 (of 23 total)