1 person found this helpful
This is more of a report and not on-screen analysis ... quite frankly a bi dashboard tool is the wrong tool for this job.
If you must do it in this tool ... then structure your data physically so you can use the tool. So think about how you could get the data into an HTML output first (leverage the DB to do your work) - then display it in a narrative view.
Thanks for the feedback Thomas!
Realized that I`m going to have a hard time getting this layout in BICS - Answers.
If I had the choice, I would use BI Publisher.
Agreed ... so if the requirements stands then apply the rule: Use of information drive physical model design -- and restructure the data so it's accessible in an easier way to BICS.