SQL Power Software Forum

Hi Pradeep,

you can find our latest documentation here: http://wabit.googlecode.com/files/WabitUserGuide-0.9.7.pdf

Hope that helps,

Benjamin

From working with it today, I have 2 more enhancement requests for Power*Architect:

- Add search function in the created SQL statement
In some scenarios you just want to use a small piece of the created SQL statement and it takes forever to find it if I have to scroll trough the whole SQL statement
- Add syntax highlighting to the created SQL statement
This will help to read it

When I tried to create a table that had a column starting with an "_" I got an error during forward engineering. The message box was too small to actually read the full content.

In same ways it makes sense not to overwrite a column name that a user might have changed already. In future I'll try to do all changes to column names in the query before I create a report.

To have numeric columns right aligned was the most important issue for me. The formatting of numbers might be just my personal preference.

Hi,

I created a report based on my query. I I change the order of amount of columns in the query I can see the changes in the report too. But if I change the name of a column using an alias, I can't see the change in the report. In my case I have a constant just doing one calculation (actual_amt / 12), by default Wabit gives the column name ?column?. After changing that name to something more readable the report kept the old column name.

This report made me think of another enhancement:
- The default alignment of numeric columns should be "Right". You could also give them the default format '#,##0.00' or '#,##0.000', I think that is what most people want to see.

Cheers,
Benjamin

Here are 2 more things I want to mention:

When I cancel the DB comparison the DB compare window just closes the window but doesn't stop the comparison.

For forward engineering, the field "create in" is too small, it could have at least the same length as the other fields in this dialog.

I'm sure I can find more once I get to work more with the Architect again.

Hi,

I think Power Architect should also copy the relationship between 2 tables if I copy and paste them both into a new schema at the same time.

Cheers,
Benjamin

Hi,

Steve and I were working on setting up workspace where these needs came up. Now I just found out about a bug (or is it a feature?) That if close and open a file in Wabit, Wabit automatically orders the queries in alphabetical order. I wasn't really expecting that and I think it would be better to leave the order up to the user (and give him the option to order by name).

Benjamin

Hi,

Is it possible that you currently can't show the cubes of more than 1 Catalog whenever you are connected to an xml/a source?
I set my Mondrian server up to have to catalogs, When I connect to it in Wabit it shows me one of them with the cubes + the name of the second one, but without any cubes, just the name of it.

Benjamin

Hi,

during DB compare (using descriptions) it could be helpful if a user could just double click on the column or table that needs to be modified so the changes can be done right away.

Benjamin

Thanks for the quick reply. Putting each member decreases performance A LOT, it also increases the memory usage for the client.

Benjamin

Hi Thomas,

it should be fine as long as it is getting fixed in the next versions.

Is there a possibility to see the MDX statement that Wabit creates? I have the feeling that it might not be very efficent. In one query I want to see all values for all children and it seems that Wabit acutally puts every single element into the query instead of using Dimension.Children. Is that possible?

Thanks,
Benjamin

Hi,

I'm running a OLAP report against a Postgres database. Within a few minutes I have over 10.000 rows in the Wabit logfile (lines get added even without any query running) saying:

2750850 [AWT-EventQueue-0] INFO ca.sqlpower.sql.JDBCDataSource - Driver Class org.postgresql.Driver loaded without exception
2751440 [AWT-EventQueue-0] INFO ca.sqlpower.sql.JDBCDataSource - Driver Class org.postgresql.Driver loaded without exception
2751985 [AWT-EventQueue-0] INFO ca.sqlpower.sql.JDBCDataSource - Driver Class org.postgresql.Driver loaded without exception
2752503 [AWT-EventQueue-0] INFO ca.sqlpower.sql.JDBCDataSource - Driver Class org.postgresql.Driver loaded without exception
2752970 [AWT-EventQueue-0] INFO ca.sqlpower.sql.JDBCDataSource - Driver Class org.postgresql.Driver loaded without exception
2753554 [AWT-EventQueue-0] INFO ca.sqlpower.sql.JDBCDataSource - Driver Class org.postgresql.Driver loaded without exception

I might run out of disk space having Wabit running for an hour. Is that normal?

Cheers,
Benjamin

Hi,

after seeing different reporting solutions I think the report editor needs to show a ruler to help setting up the vertical/horizontal guides. This will help users to design accurate reports.

The ruler should have the following features:
- Offer different units (inch, centimeter,...)
- Appear horizontal and vertical
- Adjust the scale when zooming

With having a ruler it would also make a lot of sense to have the used measuring unit (inch, centimeter,...) as a report property. This way you can also change the column width settings for relational reports to the unit used in the report properties. Right now the column width seems to be pixel which is very unusual for reporting.

Another important feature is:
- Add calculated measure (and offer a screen that helps you creating it, for example year to date, multiplying to existing measures,....)
- Whenever I add measures to a query it only shows "Measures" instead of the name of the measures (so I don't know which ones I added and which ones I didn't). So it would be better to show all the measure names.

Benjamin

Hi,

I thought Wabit now uses the Google Issue Tracker instead of Bugzilla.

I meant that you should be able to execute a MDX query and save it so you can use the result in a report.

Benjamin