Query execution failed for data set...

Hi,
Query execution failed for data set<dataset name>
Does anyone know why this error could be coming up? If I log in as a member
of the Administrators group the report runs fine.If I run it as a user that
I have given every permission to (Browser, Content Manager, etc.) I get the
error.
TIA,
Jarryd.On Jul 20, 7:14 am, "Jarryd" <jar...@.community.nospam> wrote:
> Hi,
> Query execution failed for data set<dataset name>
> Does anyone know why this error could be coming up? If I log in as a member
> of the Administrators group the report runs fine.If I run it as a user that
> I have given every permission to (Browser, Content Manager, etc.) I get the
> error.
> TIA,
> Jarryd.
You will want to make sure that the default DB user account that the
report is running under has execute permissions on the stored
procedure in the dataset, if you're using one. If you're not using
one, make sure that the default DB user account has select permissions
on any tables used in the query. Note that DB user account/permissions
are not the same as Report Manager/Windows user account/permissions.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||You nailed it dude. Thanks for that.
Jarryd
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1184936231.667037.306150@.22g2000hsm.googlegroups.com...
> On Jul 20, 7:14 am, "Jarryd" <jar...@.community.nospam> wrote:
>> Hi,
>> Query execution failed for data set<dataset name>
>> Does anyone know why this error could be coming up? If I log in as a
>> member
>> of the Administrators group the report runs fine.If I run it as a user
>> that
>> I have given every permission to (Browser, Content Manager, etc.) I get
>> the
>> error.
>> TIA,
>> Jarryd.
>
> You will want to make sure that the default DB user account that the
> report is running under has execute permissions on the stored
> procedure in the dataset, if you're using one. If you're not using
> one, make sure that the default DB user account has select permissions
> on any tables used in the query. Note that DB user account/permissions
> are not the same as Report Manager/Windows user account/permissions.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Query Calculated Member - Member Properties

I have an urgent problem with some queries including calculated members where I want to filter by properties..

I have rewriten my query to show my issue on the Adventure Works Database.

Code Snippet

with

member [Account].[Accounts].[TEST] as 0

/* create a new query calculated member in the hierarchy */

select

{} on columns,

{

filter(

{

descendants([Account].[Accounts].&[1], 2)

,[Account].[Accounts].[TEST]

/* use the new calculated member */

/* comment out the calc member to see successfull execution */

},

[Account].[Accounts].CurrentMember.Properties("Account Type")="Assets"

/* filter by a member property which does not exists on the query calculated member - error */

)

}

dimension properties

[Account].[Accounts].[Account Type],

[Account].[Accounts].[Account Number],

[Account].[Accounts].[Accounts]

on rows

from

[Adventure Works]

I create a calcuated meber - and then I want to use this in a filter by member property. The Server always raises the error that the property does not exists.

How to solve this error?

The Documentation http://technet.microsoft.com/en-us/library/ms146017.aspx specify a possiblity to specify the property for the member - but I was not able to this - like documented It has no effect.

I need some urgent Help, HANNES

If you want filter to remove the calculated member then use stripcalculatedmembers function to remove all calculated members from the 1st argument. If you want filter to retain the calculated member then use the iserror function like below:

with

member [Account].[Accounts].[TEST] as 0

/* create a new query calculated member in the hierarchy */

select

{} on columns,

{

filter(

{

descendants([Account].[Accounts].&[1], 2)

,[Account].[Accounts].[TEST]

},

iserror([Account].[Accounts].CurrentMember.Properties("Account Type")) or [Account].[Accounts].CurrentMember.Properties("Account Type")="Assets"

/* filter by a member property which does not exists on the query calculated member - error */

)

}

dimension properties

[Account].[Accounts].[Account Type],

[Account].[Accounts].[Account Number],

[Account].[Accounts].[Accounts]

on rows

from

[Adventure Works]

|||

Hi,

my question - how do I proper specify a mdx property in the query calculated member.

I do not want to catch errors - nor produce errors - howto specifiy the property value in the query.

The documentation at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2126305&SiteID=1 mentions a syntax, but I can not get it work.

If I properly read the doc I would write it like

Code Snippet

with

member [Account].[Accounts].[TEST] as 0 ([Account].[Accounts].[Account Type]="Assets")

/* create a new query calculated member in the hierarchy */

select

But it dos not work.

Any ideas howto write?

HANNES

|||Calculated members don't support custom member properties. The document you mentioned shows you how to use pre-defined member properties, such as FORMAT_STRING, for calculated members.

Query Calculated Member - Member Properties

I have an urgent problem with some queries including calculated members where I want to filter by properties..

I have rewriten my query to show my issue on the Adventure Works Database.

Code Snippet

with

member [Account].[Accounts].[TEST] as 0

/* create a new query calculated member in the hierarchy */

select

{} on columns,

{

filter(

{

descendants([Account].[Accounts].&[1], 2)

,[Account].[Accounts].[TEST]

/* use the new calculated member */

/* comment out the calc member to see successfull execution */

},

[Account].[Accounts].CurrentMember.Properties("Account Type")="Assets"

/* filter by a member property which does not exists on the query calculated member - error */

)

}

dimension properties

[Account].[Accounts].[Account Type],

[Account].[Accounts].[Account Number],

[Account].[Accounts].[Accounts]

on rows

from

[Adventure Works]

I create a calcuated meber - and then I want to use this in a filter by member property. The Server always raises the error that the property does not exists.

How to solve this error?

The Documentation http://technet.microsoft.com/en-us/library/ms146017.aspx specify a possiblity to specify the property for the member - but I was not able to this - like documented It has no effect.

I need some urgent Help, HANNES

If you want filter to remove the calculated member then use stripcalculatedmembers function to remove all calculated members from the 1st argument. If you want filter to retain the calculated member then use the iserror function like below:

with

member [Account].[Accounts].[TEST] as 0

/* create a new query calculated member in the hierarchy */

select

{} on columns,

{

filter(

{

descendants([Account].[Accounts].&[1], 2)

,[Account].[Accounts].[TEST]

},

iserror([Account].[Accounts].CurrentMember.Properties("Account Type")) or [Account].[Accounts].CurrentMember.Properties("Account Type")="Assets"

/* filter by a member property which does not exists on the query calculated member - error */

)

}

dimension properties

[Account].[Accounts].[Account Type],

[Account].[Accounts].[Account Number],

[Account].[Accounts].[Accounts]

on rows

from

[Adventure Works]

|||

Hi,

my question - how do I proper specify a mdx property in the query calculated member.

I do not want to catch errors - nor produce errors - howto specifiy the property value in the query.

The documentation at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2126305&SiteID=1 mentions a syntax, but I can not get it work.

If I properly read the doc I would write it like

Code Snippet

with

member [Account].[Accounts].[TEST] as 0 ([Account].[Accounts].[Account Type]="Assets")

/* create a new query calculated member in the hierarchy */

select

But it dos not work.

Any ideas howto write?

HANNES

|||Calculated members don't support custom member properties. The document you mentioned shows you how to use pre-defined member properties, such as FORMAT_STRING, for calculated members.