Pentaho_ce_5.0_Saiku Analytics_Cube_SQLException

Question

I created my cube olap in PSW and I have published in into Pentaho ce 5.0 successfully.

Now , I creat a new Saiki Analytics in order to display the dimensions and measure ,, But I have the following error :

https://scontent-b-fra.xx.fbcdn.net/hphotos-prn2/t1.0-9/10380316_273476419498280_2061511225924222439_n.jpg

I tried the query in PostgreSQL and it work fine .. I don't know what is the problem there !!

How can I fix it !?

Answer 1

• I restarted Pentaho , and that error above is disappeared. I created new analysis using Saiku. But when I used drill through on cell, it always returned empty result without any error message !!!

https://scontent-a-mad.xx.fbcdn.net/hphotos-prn1/t1.0-9/10330452_273674162811839_9200273505653656022_n.jpg