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
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
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!!!!
Hi,
Have you resloved the issue. I am experiencing the same.
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
Please help me to resolve this issue.
Regards,
Abhijit
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
Thanks,
Issue has been resolved by processing cubes in Analysis server.
But getting new error on every reports
Report Name: Accountant Operational Efficiency
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156