Top Posts & Pages
- MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
- Dynamic Column Mapping in SSIS : Part 1
- SSIS Error: [OLE DB Destination ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01031: insufficient privileges".
- Logical OR Condition in EvalExpression of a For Loop Container
- Dynamic Column Mapping in SSIS : Part 2 (using dts variable)
Tag Archives: OLAP cube
Recently I came across a situation where data was being delivered at different times for different countries and client wanted to see data for latest common month in Region/Continent level reports. Data arrive on monthly basis, but it arrives at different … Continue reading