Ax2009 Query based report

(0) Share

Report

Posted on by Abhijit

Hello,

I have installed Ax2009 and getting below error message for quary based report in role center.

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'Company'. (rsErrorExecutingCommand) Get Online Help The General Ledger Cube cube either does not exist or has not been processed.

Kindly help me to resolve this issue.

Specification: 1. Single tier architecture

2. Shareportal and reporting server on same port 80

Regards,

Abhijit

*This post is locked for comments

All responses (8)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Ax2009 Query based report

please Pin

tell me how can i change "Available values" [for the parameter] from "From query" to "Non-queried"

please give me the full procedure
Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Ax2009 Query based report

change "Available values" [for the parameter] from "From query" to "Non-queried"
Francois M 140 on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Ax2009 Query based report

I would recommend that you first review the AX install and config documentation for SSRS/SSAS installation...... I ran into lots of these problems during my first few installs but after I read the document, I realized that I had missed little steps along the way!!!!
Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: Re: Re: Ax2009 Query based report

Hi,

Have you resloved the issue. I am experiencing the same.
Abhijit 85 on at

Like (0)

Report
Re: Re: Re: Re: Ax2009 Query based report

Thanks Dick,

Issue has been resolved by deploying ODC files by Administration > Setup > Business analysis > OLAP > OLAP Administration and "Synchonize OLAP database with OLTP schema"

Most of the reports has been resolved, But some reports are getting following errors

Sales vs. Target

This report requires a default or user-defined value for the report parameter 'FilterBySalesPerson'. To run or subscribe to this report, you must provide a parameter value. (rsReportParameterValueNotSet) Get Online Help

Lead Summary by Source Type

This report requires a default or user-defined value for the report parameter 'FilterBySourceType'. To run or subscribe to this report, you must provide a parameter value. (rsReportParameterValueNotSet) Get Online Help

Please help me to resolve this issue.

Regards,

Abhijit
Dick Wenning 8,705 on at

Like (0)

Report

Re: Re: Re: Ax2009 Query based report

it could be that the customor has no license on that field, the generated BI report must be corrected manualy, remove field that is not part of the AX license/configuration
Abhijit 85 on at

Like (0)

Report
Re: Re: Ax2009 Query based report

Thanks,

Issue has been resolved by processing cubes in Analysis server.

But getting new error on every reports

Report Name: Accountant Operational Efficiency

Default value or value provided for the report parameter 'Year_Company' is not a valid value. (rsInvalidReportParameter) Get Online Help

Report Name: Cash Inflow vs. Cash Outflow Chart

Default value or value provided for the report parameter 'CashInflowvsCashOutflow_Company' is not a valid value. (rsInvalidReportParameter) Get Online Help

Please help us to resolve this issue, Only OLAP and Query based reports are faing this error.

Regards,

Abhijit
Dick Wenning 8,705 on at

Like (0)

Report

Re: Ax2009 Query based report

it looks like you have an OLAB cube? the reports that can be deployed to reporting service have 2 kind of datasources. The .net connector (real time data) and olap datasources.

what was the name of the report that you where deploying