Sponsored Links


  • 1. MDX equivalent to SQL's IN operator
    Does MDX have an equivalent to sql's IN operator? Here's my code: MEMBER [d_MarketProvider].[M Total] AS 'Sum( Filter( [D_MarketProvider].[Market Name].Members, [D_MarketProvider].CurrentMember.Properties("Market ID") = "1" or [D_MarketProvider].CurrentMember.Properties("Market ID") = "6" or [D_MarketProvider].CurrentMember.Properties("Market ID") = "8" ) )' This code works fine, but I was wondering if you could do something like: [D_MarketProvider].[Market Name].Members where [D_MarketProvider].CurrentMember.Properties("Market ID") in ("1","6","8") Any ideas?? Is this even posible? Thanks in advance. Francisco Alvarado
  • 2. Semi Additive Measure Problem
    Hi, I have current balance that get updated once every month and we show the latest balance as of a given month to the users. I have a simple formula: If I am at all time level, I need to use the time default member, which is set to be the latest month in the cube dynamically. iif(([Time].CurrentMember.Level is [Time].[All Time].Level), ([Measures].[Balance Am], [Time].DefaultMember), ([Measures].[Balance Am],ClosingPeriod([Time].[Month],[Time].CurrentMember))) This calculated measure works fine unless I call it in the context of aggregation of time periods. Some of the users have access through Office Web Components Pivot tables. The problem is that Users select other regular additive measures such as revenue and this semi-additive Balance and when they select multiple time months, the balance comes out wrong. I think this is because the OWC seem to perform an MDX 'Aggregate' of selected time periods and the formula I have is returning the balance for the DefaultMember of the time. This is wrong when the users would have chosen some earlier time periods not including the current one. Hope I was clear. Thanks Murthy.
  • 3. how to model this ?
    Hello, Slowly Changing Dimension of Type 2 (Kimball-speak) question. Given: a dimension Customer(ID, CCode, Name, MyFlag, ChangeDate) where ID is a surrogate key and CCode is the natural key. If a customer's MyFlag changes, the historical facts related to that customer should still reference to the previous state of MyFlag. If this is implemented as a Type 2 Slowly Changing Dimension, this is what happens: Customer(1,a,abc,0,1-1-1980) has facts linked via ID 1 Customer(2,a,abc,1,today) will get facts linked via ID 2 With SQL I can clearly see how to draw reports from such a model: if you need totals per Customer, add a "group by CCode". Then, in the example above we make correct totals for customer "abc". But how do you create Cubes and Dimensions from such a model ? AS will think that there exist 2 customers named "abc". Most reports should just ignore the MyFlag and make totals per customer. A few reports however will make totals per MyFlag. This must be a very common problem... How do you track changes in attributes of dimension members ? There is probably a straightforward answer but I don't see it. Thanks, Tom
  • 4. Caculated Cell in Sample App is different from AS Browse Data
    Hi, I'm doing a query that returns one calculated cell value. But when I query AS through Sample Application I get a different value from the one I get when I browse data in Analysis Manager. Considering the following points, what can be happing? 1) I'm sure I'm in the same database, cube and cell; 2) The cell is in the leaf member of all dimensions; 3) I cleaned all kind of cache, like restarting AS, SQL Server and IIS (my app creates an AS Cache in IIS); 5) I have no data for this cell either in fact table and writeback table; 6) There's just one formula, a calculated cell, working in this cell; 8) This strange behaviour seems to be started recently and it's happening with other calculated cells as well; 8) I'm using the native features directly, I mean, AS Browse Data and Sample App.; 9) I haven't had any environment trouble on my machine; 10) This is the query I've used in sample app: select {[Perdo].&[25]} on columns, {[Vers].&[-18]} on rows from RC WHERE ([Indicador].&[1],[Canal].&[-10],[Centro de Custo].&[-4],[Empresa].&[-4],[Projeto].&[-4],[Produto].&[64],[Measures].[Amount]) 10) How is it possible?? What else could I try? Thanks in advance, Vinicius Bellino


Postby ad » Tue, 27 Jul 2004 19:42:34 GMT

Are there any books or web page about the details of how to use OWC to
present the olap of Sql 2000?

Similar Threads:

1.OWC with OLAP MDX Help Request



Who is online

Users browsing this forum: No registered users and 14 guest