Hi @David Boot-Olazabal
The configuration on PC of the ODBC fixed this as shown on attached image.
Look at the image which we find by searching ODBC on windows search.
I sorted out finally. The number of dimensions and the calculated formula should match with the columns in information link. Even the order is important in the elements.
I guess that the correspondence between the calculated formula (I have not tested with more than one) and the dummy column returned is matched according to order. In the accordion below is the sql that works:
SELECT C1."DATEID" AS "DATEID",
C1."ERBS" AS "ERBS",
C1."EUTRANCELLFDD" AS "EUTRANCELLFDD",
MAX(C1."PRBUTIL") AS "DLPRBUTILISATION"
FROM
(SELECT
D1."DATE_ID" AS "DATEID",
D1."HOUR_ID" AS "HOURID",
D1."ERBS" AS "ERBS",
D1."EUtranCellFDD" AS "EUTRANCELLFDD",
100*(SUM(D1."pmPrbUsedDlBcch") + SUM(D1."pmPrbUsedDlDtch") + SUM(D1."pmPrbUsedDlPcch") + SUM(D1."pmPrbUsedDlSrbFirstTrans"))/SUM(D1."pmPrbAvailDl") AS "PRBUTIL"
FROM
"DC_E_ERBS_EUTRANCELLFDD_RAW" D1
WHERE
<conditions>
GROUP BY
D1."DATE_ID",
D1."HOUR_ID",
D1."ERBS",
D1."EUtranCellFDD") C1
GROUP BY
C1."DATEID",
C1."ERBS",
C1."EUTRANCELLFDD"
I solved it! I took the same idea from SAP BI called taking dimensions from another query. On demand setting I defined Input from the one main information link configured with prompt. all other Information Links left without prompts but taking as input the column from the information link with prompt.
Enkeled Kanaj's post in log in in data source in my pc only was marked as the answer