Bah-Ron
01-15-2008, 01:09 PM
Hi, I'm using Cube Designer 0.7.2 and this is my problem:
in Map Tables page (step 2 of 5 in this version of Cube Designer) I select tables, views ecc; then I'd like to add where clauses to the query. I edit them, I publish the cube, but at the moment of visualization of the pivot table, I notice that clauses I edited have no effect.
Actually, I'm not even sure that query I edited is being stored somewhere. As I know, the publish function of Cube Designer generates 3 files in /samples/analysis directory. I can't see any trace of my where clauses neither in 'mondrian.xml' file (which only defines the cube structure), neither in 'xaction' file (the simple workflow).
How can I manually edit the query and add any additional clause? Do I make some mistake, or Cube Designer doesn't have this capability yet?
Stefano
-
Italy
in Map Tables page (step 2 of 5 in this version of Cube Designer) I select tables, views ecc; then I'd like to add where clauses to the query. I edit them, I publish the cube, but at the moment of visualization of the pivot table, I notice that clauses I edited have no effect.
Actually, I'm not even sure that query I edited is being stored somewhere. As I know, the publish function of Cube Designer generates 3 files in /samples/analysis directory. I can't see any trace of my where clauses neither in 'mondrian.xml' file (which only defines the cube structure), neither in 'xaction' file (the simple workflow).
How can I manually edit the query and add any additional clause? Do I make some mistake, or Cube Designer doesn't have this capability yet?
Stefano
-
Italy