Re: MDX query weird error

#1

Re your post, are there any updates?

-- A --

Anne Zorner [MSFT] wrote:

Quote:

Hi

Could this describe your problem:

SYMPTOMS
========

When running a query against a virtual dimension with dimension
security
defined, a member which should be seen in the results is missing.

When a different MDX query is run specifically requesting the missing

member the following error is returned:
Unable to open cellset Formula error - cannot find dimension member
("<MemberName>") - in a name-binding function"

There is an unpublished article: 320720 that describes the above
problem.
If this also describes your problem then a fix may be in the
pipeline. I
suggest you raise a support case and request the fix if one is
available.

regards

Anne

This posting is provided "AS IS" with no warranties, and
confers no rights.

--------------------
| From: "B P" <bptree_tech (AT) yahoo (DOT) com
| Subject: MDX query weird error
| Date: Mon, 23 Jun 2003 17:07:53 -0700
| Lines: 43
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <uZJusQeODHA.3016 (AT) TK2MSFTNGP10 (DOT) phx.gbl
| Newsgroups: microsoft.public.sqlserver.olap
| NNTP-Posting-Host: firewall.businessengine.com 63.72.47.132
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.olap:39928
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| Hi All,
|
| I execute this query against a virtual cube, and get errors. Using
MDX
| Sample, if I execute a query successfully against the same cube,
then I
can
| execute the erred query fine. Please help if you have seen this.
|
| Thanks.
|
| select
| { Filter( Descendants( [Resources].[All Resources], 2, self ),
| [Resources].CurrentMember.DataMember.Name <> Ancestor(
| [Resources].CurrentMember, 2 ).name ) } on columns,
| {[Time].[Calendar].[2002].[Quarter
| 1].[Jan],[Time].[Calendar].[2002].[Quarter
| 1].[Feb],[Time].[Calendar].[2002].[Quarter 1].[Mar],
| [Time].[Calendar].[2002].[Quarter
2].[Apr],[Time].[Calendar].[2002].[Quarter
| 2].[May],[Time].[Calendar].[2002].[Quarter 2].[Jun],
| [Time].[Calendar].[2002].[Quarter
3].[Jul],[Time].[Calendar].[2002].[Quarter
| 3].[Aug],[Time].[Calendar].[2002].[Quarter 3].[Sep],
| [Time].[Calendar].[2002].[Quarter
4].[Oct],[Time].[Calendar].[2002].[Quarter
| 4].[Nov],[Time].[Calendar].[2002].[Quarter 4].[Dec],
| [Time].[Calendar].[2003].[Quarter
1].[Jan],[Time].[Calendar].[2003].[Quarter
| 1].[Feb],[Time].[Calendar].[2003].[Quarter 1].[Mar],
| [Time].[Calendar].[2003].[Quarter
2].[Apr],[Time].[Calendar].[2003].[Quarter
| 2].[May],[Time].[Calendar].[2003].[Quarter 2].[Jun],
| [Time].[Calendar].[2003].[Quarter
3].[Jul],[Time].[Calendar].[2003].[Quarter
| 3].[Aug],[Time].[Calendar].[2003].[Quarter 3].[Sep],
| [Time].[Calendar].[2003].[Quarter
4].[Oct],[Time].[Calendar].[2003].[Quarter
| 4].[Nov],[Time].[Calendar].[2003].[Quarter 4].[Dec]
| } on rows
| from "Planned vs Actuals Cube"
| where ([Measures].[Planned Hrs], [Demand Scenarios].[Demand
| Scenario].[Current],[Projects].[Project Name].[10010001
Administrative
| Services])
|
|
| Error Message:
|
| Unable to open cellset
| Formula error - cannot find dimension member ("[Projects].[Project
| Name].[10010001 Administrative Services]") - in a name-binding
function
|
|
|

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: MDX query weird error

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: MDX query weird error - 03-02-2005 , 04:35 PM