Hi,
I am facing issues withProclarity 6.3.2217 with SP2 desktop tool.
Problems:
1) I have ProClarity book developed on proclarity 6.32217 querying a 2008 cube. I noticed that on the 2008 cube the Options/Non Empty Crossjoin box is checked when the grid is filtered. But when I "uncheck" the box it does not stick. I can uncheck it and the rows are still filtering empties. I go back to the option and it is checked again.
Because of this issues query is returning a huge dataset and due to huge dataset proclarity tool throws an error as follows: Query Failed"
2) When I tried to publish the same proclarity book on web (i.e. on PAS server) it throws an error following error when I was browsing for data.
Error when accessing page "Report" ({A7F0B84F-8FC9-4134-B4A7-F3F9F4415E61})
from book "ProclarityReports" ({95357562-05E8-45F6-A765-2D203FD3B8DE})
Cache File Name: (unknown)
Call Stack:
Location: line #14874 of file QueryImpl.cpp
- Error-code: (0x1b), Error-number: 0x800f000a
- Error on executing command query
Location: line #14339 of file QueryImpl.cpp
- Error-code: (0x1b), Error-number: 0x800f000a
Query Connection XML:
<ConnectionInfo><Provider Name="{176941F9-18E8-47D6-860D-006FF2655608}" Caption="MSOLAP"/><Server Name="aaa001"/><Catalog Name="DW_Reports_OLAP"/><Cube Name="[DW_Reports]" Caption="DW_Reports"/><Schema Name=""/><LocalServer Name="aaa001"/></ConnectionInfo>
Can you help me around the above problems? Is there any hot fix around proclarity to resolved issues around "Non Empty Crossjoin" option?