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....
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..
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
FAQ
Search
Profile
Private Messages
Log in
