We have just bought the Transformer 8 have to start right from the scratch.I need to gather the requirements from end users and build the cubes.I would appreciate if gurus could let me know what are key questions and issues i need to be ask and which key areas i would need to focus.Appreciate your help.Thanks
Start withthe basics - what sort of dimensions are they expect5ing to see, what drill down functionality, what measures, do they want to see blank children in dimensions (aka null categories in Transformer), what sort of time dimensions (calenday rea, fiscal year etc.) and what sort of relative time categories within this (prior quarter, prior qtd , prior year etc. etc.)
Also you can ask for any security requriments for the Cubes