Questions on "what-if analysis"/cell-writeback

[peter467]

Hello,
I'm a Computer Science student. I'm studying Datawarehouse in general and as a related pratical application, Mondrian.

I have followed all the steps to build a datawarehouse and I built also some queries to have OLAP cubes (using an Oracle DB). Now I would like to make a what-if analysis on the cubes I have. I read very carefully Julian Hyde's blog where he speaks about cell-writeback (http://julianhyde.blogspot.it/2009/0...-mondrian.html) but I didn't understand very well how to realize the steps you write in the blog (expecially where write Java code and which libraries I need to use).

So, excusing for my bad understanding (and also for my terrible English!!), could you tell me if what you is written in the blog is suitable for my case? And then, if someone of you have a complete source code where I can see working cell writeback and then try to make working the code and the example I prepared myself?

Thank you very much for the help you can give me!


EXAMPLE OF QUERY in file mondrian.jsp

<jp:mondrianQuery id="query01" jdbcDriver="oracle.jdbc.OracleDriver" jdbcUrl="jdbc:oracle:thin:@localhost:1521:" catalogUri="/WEB-INF/queries/UninaDw.xml"
   jdbcUser="bruceckel" jdbcPassword="root" connectionPooling="false">
    select
    {COSTO_MANTENIMENTO, N_ISCRITTI} on columns,
    {(CORSO, SEMESTRE, DOCENTE, OBBLIGATORIETA,PIANO_DI_STUDI)} on rows
    from DESCRIZIONE_CORSO_PER_PS
</jp:mondrianQuery>

If it's needed I can post all that can be useful to solve my problem! thanks again again!

[mgie]

hi!
if it is an option for you to talk to mondrian via olap4j you could have a look at saiku
(http://analytical-labs.com/) which uses the (experimental) scenario support in mondrian.

[peter467]

hi!
if it is an option for you to talk to mondrian via olap4j you could have a look at saiku
(http://analytical-labs.com/) which uses the (experimental) scenario support in mondrian.

Hi!! Thanks for the reply first of all!

I didn't answer until this moment because I tried to connect my OLAP cube with Saiku.. After some difficulties I was winner eheheh

Now as a song says "the best is just coming...". How can I use the Scenario mode? Where can I find a guide on this topic? On saiku I didn't find so much...

Thanks again!! Your was a big help for me!!