Skip to main content

kim alexander's Library tagged sql   View Popular

25 Jun 09

SSAS: Powershell -- Multi Developer SQL Strategies

A topic that often comes up when discussing enterprise level development with SSAS is how to have multiple developers work on the same project at the same time. This issue doesn’t come up for many installations… a lot of teams get away with just having

agilebi.com/...-with-multiple-developers.aspx - Preview

SSAS: Powershell -- Multi Developer SQL Strategies

23 May 08

OLAP Monkey: Conditionally taking an action based upon member existence

  • with member [Measures].[Test] as
    '
    iif(
    IsError(StrToMember("[Gender].[All Gender].[Z]" + ""))
    ,"Not Found"
    ,"Found"
    )
    'select
    {
    [Measures].[Test]
    } on columns,
    {
    [Education Level].Members
    } on rows
    from Sales
  • with member [Measures].[Test] as
    '
    iif(
    IsError(StrToMember("[Gender].[All Gender].[Z]" + ""))
    ,"Not Found"
    ,"Found"
    )
    'select
    {
    [Measures].[Test]
    } on columns,
    {
    [Education Level].Members
    } on rows
    from Sales

Upgraded Foodmart 2000 sample database for Analysis Services 2005

  • http://cid-98546e1b65a78a74.skydrive.live.com/browse.aspx/Public/Foodmart%202000%20Upgrade%20-%20SP2
1 - 20 of 118 Next › Last »
Showing 20 items per page

Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »

Join Diigo