Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

MDX - Returning a fixed value

 
   Database Help (Home) -> OLAP RSS
Next:  Class 'PEAR_Error' not found in DB.php - please h..  
Author Message
lxkash

External


Since: Feb 15, 2005
Posts: 1



(Msg. 1) Posted: Tue Feb 15, 2005 7:41 am
Post subject: MDX - Returning a fixed value
Archived from groups: comp>databases>olap (more info?)

Hi ,

I need to create an MDX query that will return the value 0, is it
possible to do this without the use of measures/dimensions etc?

As an example what I want to recreate is the SQL below using MDX:

select sum(sales), 0, 0 ,0 ,0 from SalesTable

My problem is that I cannot get the MDX to bring in the fixed values
(zeros).

Thanks

Lxkash

 >> Stay informed about: MDX - Returning a fixed value 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
MicroStrategy Report grouping by two different dates - Hello: I need to do a MicroStrategy report like that: Year Items by DATE-1 Items by DATE-2 --- --------------- --------------- 2005 43 30 2004 124 96 2003 112 ...

Reducing Processing time of large catalog/cubes over the n.. - I have a catalog that we are do a full process on which consists of 7 cubes with about 75 millions rows of data(total). This catalog takes about 6 hours when processed locally. Recently we moved our datamart to another site(than the analysis server),..

Documeting Cognos Reportnet solution - Have been trying to find some best practices for documenting a reportnet based solution. We have recently upgraded to Cognos Reportnet and intend to rationalise and move over several reports which are running on impromptu to Reportnet. The problem I am....

Average function and MSSQL Analysis services - Hi All This should be pretty simple I think, but I can't make it work: Using MSSql 2000 with Analysis Services I have created a cube. In this cube I want to have a measure or calculated member that gives me the average instead of the sum. My data..

Business Objects, an APPARENTLY simple COUNTER .... - Dear all, we have problems with a formula for an apparently simple counter. This is the formula =TotalCount(If (<valore test(Query)>) = 0 Then 0 Else 1) It seems that the "= 0" is worthless because it gives the same results as the &q...
   Database Help (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]