If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Two problems with CubeDesigner

Basically I'm experiencing two issues with the CubeDesigner, and I'll just post them already (the first error is happenning to a friend of mine who is setting up the CubeDesigner on Windows, though):

1) On Windows XP, after setting up the first step, the tables/schemas just won't show on the drop-down menu. It somehow shows up for very little time and then the menu goes up again, thus not allowing the selection of any table. Has anyone ever experienced this and know the solution? I think I've had this once when setting it up on Windows but it got randomly fixed. The JDK version is 1.5, and we've tried with both versions of CubeDesigner.

2) How do I tell the XML file that my primaryKey is not the last level of the hierarchy? I thought that putting the correct attribute (as in the foodmart example) would solve that, but it didn't work. My hierarchy is something like:

For some reason it keeps comparing the last level of the hierarchy with the column on the fact table, so I can't put like the product description (which is the name of it and it would be the last level).

same problem

1) On Windows XP, after setting up the first step, the tables/schemas just won't show on the drop-down menu. It somehow shows up for very little time and then the menu goes up again, thus not allowing the selection of any table. Has anyone ever experienced this and know the solution? I think I've had this once when setting it up on Windows but it got randomly fixed. The JDK version is 1.5, and we've tried with both versions of CubeDesigner.

It's a really shoddy bug which should be fixed by packaging CubeDesigner, but I solved it by following the guide at the top of this page. It's basically insuring that you're running that specific version of the JRE.. Still come across lots of other bugs, mind, but at least you can see the databases :-)