Cannot Perform Cube View Operation. Essbase Error
affiliates. Other names may be trademarks of their respective owners.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:U.S. GOVERNMENT RIGHTS:Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.This software or hardware and docu
General Discussions View all Getting Started with the Community Community News Get Connected Business Strategy & Best Practices Suggestions for this Community Technical Discussions View https://community.microstrategy.com/t5/Administration-Tools/Error-when-browsing-execute-a-report-from-MDX-Essbase-Hyperion/td-p/148624 all Announcements Visualization Gallery Tech Corner Idea Exchange Platform (Installation & Deployment) https://social.msdn.microsoft.com/Forums/en-US/ee267fce-2feb-48d6-b335-de5cb3aa5e90/datasource-hyperion-essbase-cube-error-occurred-retrieving-child-nodes-null?forum=sqlreportingservices Object Development Reporting, Dashboards, and Document Development MicroStrategy Desktop Clients (Interfaces & Visualizations) Administration Tools Intelligence Server Mobile Enterprise Assets (Data Sources & Gateways) MicroStrategy Software Development Kit (SDK) Security (Usher) Performance Events View all Events Blog Symposia 2016 Symposia 2015 Education World 2016 Discussions World cannot perform 2015 Discussions World 2015 Track Sessions & Customer Presentations Community Menu Register · Sign In · Help Enterprise Assets (Data Sources & Gateways) MicroStrategy > Technical Discussions > Enterprise Assets (Data Sources & Gateways) > Error when browsing /execute a report from MDX Essbase Hyperion Cube in MSTR CommunityCategoryBoardKnowledge BaseUsers cannot perform cube turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Error when browsing /execute a report from MDX Essbase Hyperion Cube in MSTR Reply Topic Options Float Topic for All Users Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page « Message Listing « Previous Topic Next Topic » Tarek1738144 Newcomer Posts: 6 Registered: 12-30-2013 Error when browsing /execute a report from MDX Essbase Hyperion Cube in MSTR Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Content 02-25-2014 05:38 AM Error: SQL Generation Complete QueryEngine encountered error: XMLA Execute failed. SOAP Error. Error type: XMLA error. XMLAError: SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Retired content Samples We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: DataSource: Hyperion Essbase Cube, "error occurred retrieving child nodes: null" SQL Server > SQL Server Reporting Services, Power View Question 0 Sign in to vote I have a custom essbase application/db source that I wish to connect to from SSRS 2005. I have all the required software installed (APS / SP2 .3050) etc. I can connect to the datasource in SSRS 2005, but when I'm trying to build the query on the cube, I see under the member properties of all dimensions, the following piece of line "error occurred retrieving child nodes: null" Also, when I try to drag my Measures into the query section (or any other dimension for that matter of fact, though that defies logic) I get the following error Cannot perform cube view operation. OLAP error (1260046): Unknown Member PARENT_UNIQUE_NAME used in query I am new to using ESSBASE with SSRS 2005, and hence cannot make much sense of the above two errors. Any insight or a re-direction to similar posts with solutions will be greatly appreciated. thanks for your time, !! Friday, October 19, 2007 3:47 PM Reply | Quote Answers 0 Sign in to vote Hi, I am guessing your using Essbase version 9.3.1 specifically. We investigated this issue and determined that with version 9.3.1 the provider name changed which is causing problems in down stream applications such as SQL Server Reporting Services. Version 9.3.0 should work fine, if you have it. We will make a change to adjust for