FreeAnalysis Schema Designer for UnitedOlap (part 2)

Dear Readers,

Some more features with Fasd/UOlap, that are usefull when you have stock control or cumulative data instead of daily data, and you want to manage only the “first” or the “last” value, for a date dimension/period.

We added a new Wizard interface where you can select the behaviour of your measure

New Wizard for measure definition

From this interface, you can easilly select your measure (either calculated or from fact table) and choose between last and first behaviour. You have to indicate which date-aware dimension will support the last/first, and it’s done. No more complex Mdx to type, we hide all the complexity for you !

Last/First Definition

Another crazy wizard and feature is the dynamic behaviour for a measure, where you can display, for example, the “sum” of the measure at the root level of a dimension, the “min” for its child level and the “average” for its grand-child level. There are thousand of business case where you need this dynamic aggregate calculation feature, with Fasd/UOlap, we make it easy to implement

Dynamic Aggregate interface

Those pictures worth a thousand words, just look around and evaluate how to provide those features with stone-age first generation Open Source Bi Platform …

Have Fun !


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: