This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

MDX question

August 19 2011 at 9:10 AM
No score for this post
 
from IP address 198.240.213.22

Dear all,

I'm on an ASO-Essbase Cube version 11.1.1.3 and I issue the following MDX query:
*******
WITH MEMBER
[S0279].[Cif Total Count]
AS
'Count (
Crossjoin (
{[S0279].[S0221]} ,
{[30900_AGGR].Leaves}
)
)'
MEMBER
[S0279].[Cif Usage Count]
AS
'NonEmptyCount (
Crossjoin (
{[S0279].[S0221]} ,
{[30900_AGGR].Leaves}
)
)'
SELECT
{ [Time].[Jul] }
ON COLUMNS,
{
Crossjoin (
{[S0279].[S0221]} ,
{[30900_AGGR]}
),
([S0279].[Cif Total Count], [Organization]),
([S0279].[Cif Usage Count], [Organization])
}
ON ROWS
FROM
CCPS_REP.CCPS_REP
WHERE
([Value type].[E6010_AGGR])
*******

Below the dimension 30900_AGGR is have level 0 members that are 5 and 12 characters long. How can I limit the count member "Cif Total Count" that only level 0 members with 12 characters are counted?

Help is appreciated.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: MDX question - Maerki on Aug 22, 1:27 AM
  2.  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.