Re: Percentage analysis

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

I am using this Syntax on one of my Cube. But it says Syntax error. any idea
what i wrote wrong.





WITH

MEMBER Measures.Pcnt as

'[Measures].[Total On Time]/(measures.[Totals],[TradeLane].[All TradeLane])
* 100'

SELECT

{measures.[Total On Time], Measures.Pcnt} ON COLUMNS,

{[TradeLane].[All TradeLane],[TradeLane].[Port].Members} ON ROWS

FROM OnTimePerformance





"Darren Gosbell" <jam@xxxxxxxxxxxxxxxxx> wrote in message
news:MPG.1de2b39574d5e28f9897b5@xxxxxxxxxxxxxxxxxxxxx
> You would create a calculated measure with a formula something like the
> one in the formula below. The sample below works with the Foodmart 2000
> database and takes the currently selected customer and returns the
> percentage against the "All Customers" member.
>
>>>>>
> WITH
> MEMBER Measures.Pcnt as '[Measures].[Sales Count]/(measures.[Sales
> Count],[Customers].[All Customers]) * 100'
> SELECT
> {Measures.[Sales Count], Measures.Pcnt} ON COLUMNS,
> {[Customers].[All Customers],[Customers].[City].Members} ON ROWS
> FROM Sales
>>>>>
>
> In your case you should be able to create a calculated measure in your
> cube that looks something like this "[Measures].[Passenger Count]/
> (measures.[Passenger Count],[Locations].[All Locations]) * 100" assuming
> that your measure is called "Passenger Count" and your cities are stored
> in a dimension called "Locations".
>
> HTH
>
> --
> Regards
> Darren Gosbell [MCSD]
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <eLIDz5L6FHA.1000@xxxxxxxxxxxxxxxxxxxx>,
> moonis.tahir@xxxxxxxxx says...
>> Hi,
>>
>> I want to show Percentage analysis on basis of # of passengers per City.
>> I have the Detail data with pessenger information travelling in Tri rail
>> per
>> City.
>>
>> Now if i create a measure then i have only option to Sum or Count the
>> records while i want to have a percentage.
>>
>> I dont know how i can do it in Cube.....any idea
>>
>> Regards,
>>
>> BizWorld
>>
>>
>>
>


.

Relevant Pages

  • Re: Blue File Names
    ... I have passed your information on to our Member and I'm sure his question is ... > Regards. ... > compact old files. ... >> Hello Joe ...
    (microsoft.public.windowsxp.general)
  • Re: Windows XP is my OS
    ... Is it a member of a domain or standalone? ... Regards ... >> Mark Dormer ... >>> When I logon to the computer I keep getting a windows error message. ...
    (microsoft.public.windowsxp.general)
  • Re: Using todays date
    ... Regards ... > Strange strange strange! ... > Jamie Thomson ... >> this member does exist. ...
    (microsoft.public.sqlserver.olap)
  • Re: Avian Flu, BSE and FMD
    ... You will probably be the only member of the ... >> politburo that will be able to pass though some border controls without a ... Regards ...
    (uk.business.agriculture)
  • Re: Percentage analysis
    ... But it says Syntax error. ... >> MEMBER Measures.Pcnt as ... >> TradeLane]) ... >> FROM OnTimePerformance ...
    (microsoft.public.sqlserver.olap)