I have done many Executive queries in Vantage 8.03 and E9 with no issues.
With the new capabilities in E10 with subqueries I haven’t found a need for them.
Now I would like do some trending by collecting snapshots of data.
With a very complex BAQ, the results of the executive query - not able to build the cube.
When I put a very basic query together - PartCost table with 20 records, it still failed.
I can see that the system cubes are running fine.
Anyone having good luck with Executive Queries?
The system monitor in history states “complete” for status, but when I look at the detail tab, I get this error
"Unable to build cube: Simple: Object reference not set to an instance of an object. at Ice.Internal.Task.SysCubeTask.getBaqResultColumn(SysCubeParam sysCubeParam, String columnName) in C:_Releases\ICE\3.2.100.0\Source\Server\Internal\Task\SysCubeTask\SysCubeTask.cs:line 433
at Ice.Internal.Task.SysCubeTask.processSysCubeParamRow(IceContext context, DataRow row, SysCubeParam sysCubeParam, String currCompany, String currUser) in C:_Releases\ICE\3.2.100.0\Source\Server\Internal\Task\SysCubeTask\SysCubeTask.cs:line 381
at Ice.Internal.Task.SysCubeTask.processOneSysCubeParamRow(DataRow row, SysCubeParam sysCubeParam, String currCompany, String currUser) in C:_Releases\ICE\3.2.100.0\Source\Server\Internal\Task\SysCubeTask\SysCubeTask.cs:line 366
at Ice.Internal.Task.SysCubeTask.buildCube(String currCompany, String currUser) in C:_Releases\ICE\3.2.100.0\Source\Server\Internal\Task\SysCubeTask\SysCubeTask.cs:line 311"