Forum Replies Created

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

  • RE: Forum Etiquette: How to post data/code on a forum to get the best help

    Hi Jeff

    You raise a point that goes beyond just posting on forums - In the general office situation this is also common: People ask questions without being clear and actually...

  • RE: Software is Like Building a House

    Imagine doing the task with the wrong / outdated tools and base your estimate on that. e.g How long would it take to build the fort using only a hand...

  • RE: Meeting Expectations

    I think people list every single thing they have ever touched on their CVs just to get a reasonable key word hit rate. Recruiters then find a few key words and...

  • RE: How Do You Work?

    It can get a bit ridiculous - my company restricts 'Restaurants and entertainment' so I can't pick up a fast food menu when I feel like something other than canteen...

  • RE: Anyone ever gone to Hands on It training?

    If your compay is paying, then the course is the quickest and most effective way to get going. I was thinking more from the point of view that you might...

  • RE: Anyone ever gone to Hands on It training?

    Hi Bart

    If you are a beginner, then Hands on is probably the best way to get started. The down side is that you can't cover much detail in a hands...

  • RE: Search and Replace

    Got to respectfully disagree here. Imagine we didn't correct the idea that the earth was the centre of the universe, that the earth is flat, that the theory of relativity...

  • RE: Analysis Services training materials

    You can also try Applied Microsoft Analysis Service 2005 (And Microsoft Business Intelligence Platform) by Teo Lachev. Its quite good and takes you through building solutions on the AdventrueWorks sample database....

  • RE: Changing sum to average

    You could do a calculated measure that divides e.g. Sales Price by units to get an average sales price. Something like:

    [Measures].[Store Sales]/[Measures].[Sales Count]

    Not sure what you are averaging but...

  • RE: problems with Time dimension and rollups

    Hi Jeff

    Are you joining the fact table to the time dimesnion with a key or are you using dates in the fact table?

    Maybe the time dimension is reading the...

  • RE: Custom Drillthrough in MSAS 2000

    I haven't worked with accounting much but maybe something like this could work:

    Make type of time dimension with a hierarchy something like this:

    All Time

        0 - 15 Days

        15 - 30...

  • RE: Adventure Works Cube in SQL 2005

    Thanks for the help - I'll give it a try tonight.

  • RE: Multiple Hierarchy

    I haven't tried this myself but there is a .hierarchy function and I would imagine you could use it to test in which hierarchy of time the current member is...

  • RE: MDX To Calculate Actual-Budget (Variance)

    Hi there

    In the most simplistic terms, if you have a measure of actual and one for budget, you could do a calculated measure simply as ([measures].[budget] - [measures].[actual])

    In Analysis services...

  • RE: filtering measure values thro'''' MDX

    Have you tried IIf statements

    e.g. IIF([measures].[mymeasure]> 10000, IIF([measures].[mymeasure]) <50000, [measures].[mymeasure], Null), Null) - i.e. if the value is between 10 and 50 thousand return it otherwise return null

    I'm also a bit...

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