Solved

How to put measures in olap4j api ?

Posted on 2015-02-18
1
112 Views
Last Modified: 2015-02-19
I am using mondrian server and olap4j api.
How to I put measures in olap4j api ?
In olap4j Measures are treated as Dimensions, but how do I include them in query ?

QueryDimension dimn1=query.getDimension(getDim1());
	QueryDimension dimn2=query.getDimension(getDim2());
	QueryDimension dimn3=query.getDimension(getDim3());
	       //QueryDimension measure1=query.getDimension(getMeasure());
	

	query.getAxis(Axis.COLUMNS).addDimension(dimn1);
	query.getAxis(Axis.ROWS).addDimension(dimn2);    
	query.getAxis(Axis.COLUMNS).addDimension(dimn3); 

Open in new window

0
Comment
Question by:Pradip Shenolkar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
Pradip Shenolkar earned 0 total points
ID: 40618621
I found the solution :
Its working

Query query=new Query("query1",cube1);
QueryDimension measure1=query.getDimension("Measures");
	measure1.include(IdentifierNode.ofNames("Measures",measureName).getSegmentList());
query.getAxis(Axis.FILTER).addDimension(measure1);										
	

Open in new window

0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question