Problem with a MDX

Problem with a MDX

Post by Marco Grand » Wed, 15 Nov 2000 04:00:00



Hi, i have a problem with a MDX stament, my MDX return this :
Sales            Computers
Quarter 1                   10
Feb                              3
Mar                              2
Quarter 4                    11

my problem is. Feb, what is his Quarter ?
In my VB program i need to show

Sales            Computers
Quarter 1                   10
Quarter 2 - Feb            3
Quarter 3 - Mar            2
Quarter 4                    11

Thanks for all and sorry for my bad english

 
 
 

Problem with a MDX

Post by pc.. » Fri, 17 Nov 2000 04:00:00


Post your MDX statement so that we may evaluate it and give feedback or
suggestions.  Also are Quarters and Months on different levels?  Show
your time dimension levels also.  There is no need to apologize for
your english, as most english speaking people cannot write correctly
anyway.
Peter Cwik



Quote:> Hi, i have a problem with a MDX stament, my MDX return this :
> Sales            Computers
> Quarter 1                   10
> Feb                              3
> Mar                              2
> Quarter 4                    11

> my problem is. Feb, what is his Quarter ?
> In my VB program i need to show

> Sales            Computers
> Quarter 1                   10
> Quarter 2 - Feb            3
> Quarter 3 - Mar            2
> Quarter 4                    11

> Thanks for all and sorry for my bad english

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 

1. Syntax problem with an MDX query

Hi, i have this query, and the columns of Somme returns me #Err

WITH SET [Range] AS  '{ [Date Commande].[All Date Commande].[2001-04-24
00:00:00]:[Date Commande].[All Date Commande].[2002-03-01 00:00:00]}'
MEMBER [Measures].[Somme] AS 'Sum([RANGE])'

select [Location].members on rows,
crossjoin([Pays].members,{[Measures].[NomVol],[Measures].[Extension],
[Measures].[Somme] } )  on columns from openorder

The Sum([Range]) returns a #Err, can you tell me why please ? Thanks :)

2. Install Oracle 8.0

3. Problem creating a MDX with multiple drilldowns...

4. IN statement

5. Problem opening an .MDX index with Delphi 2.01

6. ?SQL Pronounciation

7. Delphi - Clipper problems with DBF + MDX indexes

8. An excellent OLEDB library with 15 examples

9. Major MDX problems with Calculated member (this is a good test for MDX)

10. Excel MDX problems, Quality of Data Analyzer MDX

11. mdx trace or MDX Profiler

12. Creating MDX queries with MDX Builder

13. MDX Builder. A new tool for MDX