This is the statement that one can used to generate the row number as an attribute to be placed as the leftmost column on the grid.
ApplySimple(“row_number() OVER (ORDER BY #0 ASC)”, [ID COLUMN of Fact Table with maximum number of Rows])
Above statement would work for a DB2 warehouse. One need to change the statement for respective warehouse.