Sunday, February 28, 2016

cubeSavvy – data update view for admins

This point version update includes bug fixes for displaying MDX grids. Previously there was an issue with MDX statements that didn’t contain a WITH statement. 
For example, here's some MDX that contains a WITH statement:
WITH
set [secScenario] as '{[Actual],[Budget]}'
set [secMeasures] as '{Descendants([Margin]),Descendants([Total Expenses])}'
set [secMarket] as '{Descendants([Central]),[Texas],[California],Descendants([East])}'
set [secProduct] as '{Descendants([100])}'set [secYear] as '{Descendants([Qtr1]),Descendants([Qtr2])}'

SELECT crossjoin([secProduct],[secYear]) PROPERTIES MEMBER_ALIAS ON COLUMNS,
crossjoin([secMeasures],[secMarket]) PROPERTIES [RussianNames] ON ROWS,
[secScenario] ON PAGES
FROM Sample_U.Basic
What can I say? I always use them, so it didn’t even occur to me that people would just want to create all their sets in the ROW or COLUMN axis. But now you can also write your MDX queries like so:
select crossjoin(Descendants([100]),{Descendants([Qtr1]),Descendants([Qtr2])}) PROPERTIES MEMBER_ALIAS ON COLUMNS,
crossjoin({Descendants([Margin]),Descendants([Total Expenses])},{Descendants([Central]),[Texas],[California],Descendants([East])}) PROPERTIES [RussianNames] ON ROWS,
{[Actual],[Budget]} ON PAGES
FROM Sample_U.Basic

I'd like to say, however, that typing out the query above was even more painful than trying to read it later. Ok, I'll get off my MDX soapbox.
The one new, but very useful, feature is a User Data Updates view available to admin users:Data Updates screen
cubeSavvy has long had the ability to pass ROW, COLUMN, and/or PAGE member selections from grids to a calc script using RUNTIMESUBVARS. Now admins can even see the exact member intersection that was updated, along with the old value and the new one. The user who performed the update and the date/timestamp are also provided. All fields are searchable and sortable. You can also select multiple rows and ctrl-c copy them to other programs, such as Excel.
Download, enjoy, and let me know what you think.
-Harry

Sunday, February 14, 2016

cubeSavvy - stateless and localized

There are a couple of major components to this release. One of them is architecture-related, while the other is immediately visible in the user interface. Both of them will provide a solid base upon which to continue enhancing cubeSavvy. There are also a myriad of bug-fixes, as with any new version.
Prior to this release, I maintained a user’s Essbase connection the whole time they were logged in to cubeSavvy. This created issues when the Essbase session would time out. I’d always intended to modify cubeSavvy to be stateless, due to the scalability and portability benefits. Working out the best way took a little time, but I’m extremely happy with the results. Timeouts are a thing of the past! Sessions on the Essbase server are also minimized.
The other enhancement is visible right on the login page:
language selection






Russian is my second language. I’ve been speaking it for over 20 years now and actually have a BS degree in Russian Language and Literature (during which I studied in Russia for a year). Therefore, I’ve been pleasantly surprised by the interest in cubeSavvy from Russia. To make it easier for these users, I’ve chosen Russian as the first language for which to add localization.
Русский – мой второй язык. Уже 20 лет как его учу. Поэтому я приятно удивлен интересом со стороны пользователей в России. Чтобы русскоговорящим было легче с ним обращаться, я решил перевести cubeSavvy на русский язык.
Как видно внизу, не все элементы переведены. Если будет спрос, тогда я все остальное переведу
Home page in RussianIn addition to the Russian localization, the picture above demonstrates a new option on the Home screen that shows All Grids. In one table you can quickly see (and search/sort) the grid type (report script or mdx), application, database, calc script, assigned Shared Services groups, decimal places, and even the script behind the grid itself. Clicking on the grid on the left will populate the form on the right, where all the fields can be edited:
All Grids


As always, you can download cubeSavvy here.