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

MicroStrategy Report grouping by two different dates

 
   Database Help (Home) -> OLAP RSS
Next:  any access database hangs??  
Author Message
Paco Castro

External


Since: Feb 20, 2005
Posts: 1



(Msg. 1) Posted: Sun Feb 20, 2005 5:04 am
Post subject: MicroStrategy Report grouping by two different dates
Archived from groups: comp>databases>olap (more info?)

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 154
..
..
..

The definition of my base Oracle table is like that:

ITEM_ID NUMBER(Cool,
DATE-1 DATE,
DATE-2 DATE

What attributes, facts, etc have I need and how to do that report?

Notice that I have to group items "from two different date fields of
the same Oracle table" in the same report!!!!...

Dou you know any examples in the Web?

Thanks.

 >> Stay informed about: MicroStrategy Report grouping by two different dates 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
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....

MDX - Returning a fixed value - 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....

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 ]