Get Value from dimension.

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm trying to get the last input data in a dimension to use it in a
calculated member, but i don't know how can i get the data it's just a
single value to multiply with some measusres of the fact table, please
help!!!
I don't want to do a sum of values i really need only the las member of
a dimension.

.

Relevant Pages

  • MDX Ratio Question
    ... I want to create a calculated member in my cube that users can see a ... The first expression produced 30% and 70%, respectively, but the Grand ... The user will substitute any dimension on the row axis, ... users with any OLAP client can use it. ...
    (microsoft.public.sqlserver.olap)
  • Re: Problem with calculated member in virtual cube
    ... I have a problem creating a calculated member in a virtual cube. ... cube includes 2 cubes: Activity and Costs. ... that, independently of what dimension is selected, shows the number of beds. ...
    (microsoft.public.sqlserver.olap)
  • Re: Parallel Period Question
    ... By design MDX doesn't allow for multiple selections on the slicer axis (e.g. ... is the ability to define calculated member on ... dimension because Time.CurrentMember either returns an error, ...
    (microsoft.public.sqlserver.olap)
  • Re: how to compute distance metrics with multi dimensional data
    ... Lou Pecora wrote: ... > It generalizes to any dimension. ... formula for multi dimentional time series, ... ie 2d input data or i should've called it multivariate input data ...
    (sci.nonlinear)
  • Create Calculated Member In A Dimension SQL Server 2005
    ... dimension while using SSAS 2005. ... type of sale ... Right now the sale type can only be known by looking at multiple flags ... calculated member is to reduce this to just one flag that denotes the ...
    (microsoft.public.sqlserver.olap)