Material Big Data

Lanzados ppts informativos de tecnologías BigData: Hadoop, Hbase, Hive, Zookeeper...

Pentaho Analytics. Un gran salto

Ya se ha lanzado Pentaho 7 y con grandes sorpresas. Descubre con nosotros las mejoras de la mejor suite Open BI

La mejor oferta de Cusos Open Source

Después de la gran acogida de nuestros Cursos Open Source, eminentemente prácticos, lanzamos las convocatorias de 2017

15 nov. 2012

Formula Editor in Jpivot, new feature in STPivot

One of the features, we´ve added to old jpivot is Formula Editor you can find in new STPivot, the new free and open source olap viewer you can download:
 


This feature allow users to add/edit calculated members or named sets, that are added to the query in the form of “withmember ...”. This entities list, also known as formulas, appears below the cube navigator in left panel. In the picture you can see the Formula Editor dialog, along with red marks indicating where are the buttons to open it.
If the formula is a calculated member, users can indicate its dimension to have a consistent name proposal (that he can also change). But if it is a named set, no dimension will be necessary.

The expression editor is similar to the MDX Query editor, only a bit simpler, including the cube navigator and formula selector features.

Calculated members may have multiple properties, such as FORMAT_STRING and SOLVE_ORDER for instance; so users can add them directly in the expression editor, or optionally use the dynamic list of property+value at the bottom.
Hope this helps to everyone using old jpivot. Remember that in new versions of Pentaho you receive this kind of message when accesing Mondrian OLAP cubes.



You can follow our Video Tutorial for creating formulas in STPivot. Hope you enjoy it!!

6 comentarios:

Anónimo dijo...

I've been loooking for the repository (github, etc.) or a link to download the source code of STPivot but couldn't find it. Where's the code? Thanks!

Todo BI dijo...

Hi,

You only need to fill in the form in http://www.stratebi.com/en/stpivot and you´ll access the code,

More than 180 developers are now using it,

Thanks in advance,

Marcus dijo...

Is it possible to create a member based on another member instead of basing it on a measure?

btw great job!

Anónimo dijo...

With the help of computers and other advance technology, whole
process of recording can be done in home studios but with real
orchestral people recording studio is necessary.
Monitors by this company are probably what I would look
into getting. How do they keep each show fresh and interesting when performing so many consecutive times.


Here is my homepage: MOTU Digital Performer V8.02 Free Download

Anónimo dijo...

Anyhow, the Somanabolic Muscle Maximizer is unique from the feeling that it's not a normal exercise application but a specific one particular which helps various folk attain their diverse health and fitness targets. If you would definitely be a true beginner to figuring out to gain muscular, you will need to begin your workouts inside the gym or health and fitness center to use trainers and other staff to support and teach anyone setup your schooling routine. In general, there is no doubt that the program Kyle Leon is a popular muscle building system for a good reason and this is definitely one of the most individual nutrients and online training programs today.

Review my web site :: muscle maximizer review

Anónimo dijo...

As mentioned, thousands of people have already seen life changing results after using Kyle Leon's Muscle Maximizer for just a few weeks, and there is nothing that says that you can't experience the same changes
as well. If you would definitely be a true beginner
to figuring out to gain muscular, you will need to begin your workouts inside the gym or health and fitness center to use trainers and other staff to support and teach anyone setup your schooling routine.

Who is this Somanabolic Muscle Maximizer Training Software
Designed For.

Also visit my weblog Muscle Maximizer Review