Skip to Content

Missing GROUP BY on IDT

Hi guys,


I have noticed the following strange situation when using a UNX universe created on IDT.

I have 2 dimensions (A, B)and 1 fact. The fact is defined using a function (COUNT). When combining the fact with the first dimension (A) (a normal table column) the query is generated properly adding the GROUP BY clause as expected.
Code:SELECT
ChangeRequest.RequestStatus,
COUNT(ChangeRequest.Id)
FROM
F4E_BCMP.dbo.ChangeRequests ChangeRequest
WHERE
( ChangeRequest.Deleted=0 )
GROUP BY
ChangeRequest.RequestStatus


But if the query includes the dimension B and the fact the GROUP BY is not included. Code:SELECT
CONVERT(date,BaselineManagerImplementation,103),
COUNT(ChangeRequest.Id)
FROM
F4E_BCMP.dbo.ChangeRequests ChangeRequest
WHERE
( ChangeRequest.Deleted=0 )

I have tested that problems seems to come from the definition of the column B. In particular the use of the CONVERT function in the dimension definition.

My question is: Is this a limitation of the BO engine? A bug?

Has someone noticed this behaviour?
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 16, 2017 at 01:37 PM

    what is your BO version?

    is object B is parsed in IDT?

    Add comment
    10|10000 characters needed characters exceeded