MapForums
Community of VE/MapPoint Users and Developers
How to build MDX Queries in MAP Point 2004 tool ....
This is a discussion on How to build MDX Queries in MAP Point 2004 tool .... within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi there, Please look into the following MDX Query , which is using the FoodMart 2000 database ...cube 'warehouse' Q. ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-17-2004
| |||
| |||
| How to build MDX Queries in MAP Point 2004 tool .... Please look into the following MDX Query , which is using the FoodMart 2000 database ...cube 'warehouse' Q. Store wise Units Shipped and Units Ordered and Display only those records which have values... The query will be as follows .. "select { [Measures].[Units Shipped], [Measures].[Units Ordered] } on columns, NON EMPTY [Store].[Store Name].members on rows from Warehouse" The query works fine in the MS Analysis server 2000 very well . Now, i want to build this type of different MDX Queries using MAP Ponit 2004 tools. So from the Tool menu , i seleted 'Create new OLAP Query' . The wizard guids me very well . But the problem is that it allows us to select only one 'Measures' at a time . So how is it possible to build queries like qouted above where i have used two Measures in the query . Moreover , some queries run very well in the MDX query analyser , but if i want to build that query in the MAP Point tool , it gives me the error - 'Object variable or with block variable not set , Please redefine your query' . e.g. the following simple query for the databse IXAppDB..., cube BotView works fine in the MDX query analyser... "select {[Product].[Class].members} on rows, {[Measures].[Item Qty]} on columns from BotView" Can anybody tell me why this 'Object variable or with block variable not set , Please redefine your query' error message comming ? Regards Sushanta << File: ErrMsg.bmp >>         |
 |
| Tags |
| 2004, build, map, mdx, point, queries, tool |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Speeding up Getlocation queries? Help! | Solo4357 | MapPoint Web Service and Virtual Earth | 0 | 10-13-2005 03:34 PM |
| Map Point 2004 Trial version | jimsirv | MapPoint 2006/2009 Discussion | 1 | 08-18-2004 01:31 PM |
| using access 2003 queries as a data source | roberta walker | MapPoint 2006/2009 Discussion | 2 | 04-27-2004 08:06 AM |
| Trouble installing Map Point 2004 | Anonymous | MapPoint 2006/2009 Discussion | 2 | 08-07-2003 12:15 AM |
| Shapes and Queries | Anonymous | MapPoint 2006/2009 Discussion | 1 | 06-09-2003 06:20 PM |
All times are GMT -5. The time now is 08:03 PM.
