web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / OLAP The multi-part id...
Microsoft Dynamics AX (Archived)

OLAP The multi-part identifier could not be bound error.

(0) ShareShare
ReportReport
Posted on by Rudi Hansen 4,067

I am having some problems with the CUSTTABLE named query in my Cube on Dynamics AX 2009

When i edit the named Query for CUATTABLE, i get some errors saying: 
The multi-part identifier "dbo.CUSTTABLE.CUSTGROUP.RECID" could not be bound.

When i coped the entire SQL statement to my SQL Query Manager, i found that if i changed those places where i get the error to "CUSTGROUP.RECID" then the statement runs with no problems.

But when i then copy the new statement back to the Edit Named Query, it just ignores my change and reverts to the old code with the problem.

Does anyone have an idea how to solve this?

Link to entire SQL Statement

*This post is locked for comments

I have the same question (0)
  • Hariharans87 Profile Picture
    Hariharans87 3 on at
    RE: OLAP The multi-part identifier could not be bound error.

    Hi Rudi,

    Analysis server OLAP cubes won't support SQL query. Please use MDX query.

    Connect the Analysis server on SQL Management Studio, right click and select MDX query.

    Thanks,

    Hari

  • Rudi Hansen Profile Picture
    Rudi Hansen 4,067 on at
    RE: OLAP The multi-part identifier could not be bound error.

    When i connect to the Analysis server, i can see an option on the server that says new query and then MDX query.

    But the query i am working on already exists in my Dynamics AX database, so can i change that one?

  • Mark Prouty Profile Picture
    Mark Prouty 1,312 on at
    RE: OLAP The multi-part identifier could not be bound error.

    It sounds like the problem is the coordination of the VS project and SSAS. You can overwrite changes you've made to the cube if you generate your BI project instead of Update BI project (I never select the Create Cube option). I always work within the same VS cube project.

    It's a good idea to backup your cubes before working on them (you can automate this and schedule in SQL Server agent).

    In VS BI project, you can replace a table with a named query, which is documented on Customer Source called "Configuring the Default OLAP Cubes".

    You may need to alter MDX if you're dealing with KPIs, but if you're querying the AX data source, you will use T-SQL.

  • Verified answer
    Hariharans87 Profile Picture
    Hariharans87 3 on at
    RE: OLAP The multi-part identifier could not be bound error.

    You are changing the existing table or named query in the SSAS project on data source view. Am i right?

    So, you right clicked on the table / named query and tried to change.

    One more information, i confused on your SQL. What will happen if we use dbo.CUSTTABLE.CUSTGROUP? or you missed to use dbo.CUSTGROUP.

    LEFT OUTER JOIN dbo.CUSTGROUP ON dbo.CUSTTABLE.CUSTGROUP.DATAAREAID = CUSTTABLE.DATAAREAID

    You can run the SQL query on the Edit named query window by clicking the run toolbar button.

    If, you feel that i am not understanding your requirement, please explain me clearly.

  • Rudi Hansen Profile Picture
    Rudi Hansen 4,067 on at
    RE: OLAP The multi-part identifier could not be bound error.

    I changed my code to dbo.CUSTGROUP, and then it worked, thanks for the tip, Hariharan S

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans