Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Ax2009 Query based report

(0) ShareShare
ReportReport
Posted on by 85

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Francois M 140 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Ax2009 Query based report

    Hi,

    Have you resloved the issue. I am experiencing the same.

  • Abhijit Profile Picture
    Abhijit 85 on at
    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 Profile Picture
    Dick Wenning 8,705 on at
    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 Profile Picture
    Abhijit 85 on at
    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 Profile Picture
    Dick Wenning 8,705 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans