OLAP: DRotate

Remember that the DRotate replaces one displayed dimension D with another dimension Di for the queried fact

Given the query below,

SELECT Year, CCity, COUNT$($

CROM LOAN L$,$ CUSTOMER C$,$ TIME T

NHERE LIDC $=$ CIDC

IND LIDT $=$ TIDT

hich from the four following queries $($A B; C$,$ D$)$ performs a DRotate by CCity $($of customer$)$ and account?

LECT IBAN, CCity, COUNT$($

DUP LIDT $=$ AIBAN

:

Lely