{"action":"closed","issue":{"url":"https://api.github.com/repos/pentaho/mondrian/issues/437","repository_url":"https://api.github.com/repos/pentaho/mondrian","labels_url":"https://api.github.com/repos/pentaho/mondrian/issues/437/labels{/name}","comments_url":"https://api.github.com/repos/pentaho/mondrian/issues/437/comments","events_url":"https://api.github.com/repos/pentaho/mondrian/issues/437/events","html_url":"https://github.com/pentaho/mondrian/issues/437","id":62045009,"number":437,"title":"Last Known Price - Mondrian Error: Query required more than 12 iterations","user":{"login":"sanjayraja","id":8045595,"avatar_url":"https://avatars.githubusercontent.com/u/8045595?v=3","gravatar_id":"","url":"https://api.github.com/users/sanjayraja","html_url":"https://github.com/sanjayraja","followers_url":"https://api.github.com/users/sanjayraja/followers","following_url":"https://api.github.com/users/sanjayraja/following{/other_user}","gists_url":"https://api.github.com/users/sanjayraja/gists{/gist_id}","starred_url":"https://api.github.com/users/sanjayraja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sanjayraja/subscriptions","organizations_url":"https://api.github.com/users/sanjayraja/orgs","repos_url":"https://api.github.com/users/sanjayraja/repos","events_url":"https://api.github.com/users/sanjayraja/events{/privacy}","received_events_url":"https://api.github.com/users/sanjayraja/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2015-03-16T11:00:42Z","updated_at":"2016-12-13T09:14:54Z","closed_at":"2016-12-13T09:14:54Z","body":"Hi,\n\nI have written an MDX Query to retrieve the last known price.\n\n```\nWith \nMEMBER [Measures].[Last Known Price]\nAS IIF(isEmpty([Measures].[Ex Showroom Price]),([Transaction Date].[Month].PrevMember,[Measures].[Last Known Price]),[Measures].[Ex Showroom Price])\nSelect { [Measures].[Last Known Price] } on Columns, {{[Transaction Date].[Month].[September 2014],[Transaction Date].[Month].[October 2014],[Transaction Date].[Month].[November 2014],[Transaction Date].[Month].[December 2014],[Transaction Date].[Month].[January 2015],[Transaction Date].[Month].[February 2015],[Transaction Date].[Month].[March 2015]}\n*\n{[Brand].[Brand].Children}} on Rows \nFrom [pricingCube] Where { {[Body Type].[Body Type].[SUV]} }\n```\n\nOn execution it given me an error \n\n```\nThe Mondrian XML: Mondrian Error:Internal error: Query required more than 12 iterations\n```\n\nI have tried increasing the mondrian.rolap.evaluate.MaxEvalDepth to no avail.\n\nIt works fine and fast when the number of Dimensional Items in the Dimension is less than say 15/20.\nIn the above Query if I replace Brand with Manufacturer - it work just fine\n\n```\nWith \nMEMBER [Measures].[Last Known Price]\nAS IIF(isEmpty([Measures].[Ex Showroom Price]),([Transaction Date].[Month].PrevMember,[Measures].[Last Known Price]),[Measures].[Ex Showroom Price])\nSelect { [Measures].[Last Known Price] } on Columns, {{[Transaction Date].[Month].[September 2014],[Transaction Date].[Month].[October 2014],[Transaction Date].[Month].[November 2014],[Transaction Date].[Month].[December 2014],[Transaction Date].[Month].[January 2015],[Transaction Date].[Month].[February 2015],[Transaction Date].[Month].[March 2015]}\n*\n{[Manufacturer].[Manufacturer].Children}} on Rows \nFrom [pricingCube] Where { {[Body Type].[Body Type].[SUV]} }\n```\n\nI am using Mondrian 3.7.\n\nCan someone please help/guide me ?\n\nRegards,\nSanjay\n"}}
{"actor":{"display_login":"sanjayraja"}}