rpbouman / pash Goto Github PK

XmlaUrl can be specified via the query in the url to pash.

This is required when pash can't figure out in what environment it runs. For MS Analysis users this will probably be the only way since it seems there is simply no standard url, admins configure the url themselves as they set up XML/A access.

Would be nice to be able to allow this to be specified with a SET command. Something like

SET URL 'http://localhost/olap/msmdpump.dll';

After setting the current catalog by using "USE FOODMART". If I run "SHOW CATALOGS" again, it seems pash forgets that I was using FOODMART. I have to run "USE FOODMART" again in order to run MDX queries against FOODMART.

Type:

USE, space; autocomplete menu pops up. Hit tab. The autocomplete overwrites the word use.

I've got a mondrian4 connection defined in olap4j.properties but pash is not able to find it. I think pash is only looking in MondrianCatalogHelper.

pash> use mongoFoodmart;
Error: The Mondrian XML: Mondrian Error:No such catalog: mongoFoodmart (00HSBB08)
Error: The Mondrian XML: Name pentaho_operations_mart is not bound in this Context (00HSBE02)

I'd like to copy and paste the results including the pipes and dashes to a markdown document. For this reason please also use standard pipe and dash characters. I guess this could be switched on as an option (as the standard formatting is quite nice as well).

Would be nice to configure pash to use the specified xmla url.

Unable to see historical commands using up and down arrow key. This is a usability enhancement.

Click inside the current line should move the cursor to that position.

Suggestion from @usbrandon -

export data by postfixing the statement with a redirect clause, like:

out.txt (render the result as text in new file out.txt)
out.html (render the result as html in new file out.html)
out.xlsx (render the result as excel file)

ED pops up a text editor with the last statement.

Like we can choose Name or Caption for members, let us also select Value of FmtValue for cells.

I've got a bad catalog defined in the BAServer. Pash should skip it instead of failing every time I run show catalogs.

pash> show catalogs;
Error: The Mondrian XML: Name pentaho_operations_mart is not bound in this Context (00HSBE02)
pash>

With the SHOW command it would be good to additionally/optionally constrain on something, e.g.:

SHOW MEMBERS [SteelWheelsSales].[Product].[Line];

This applies to PROPERTIES and several other ones as well.

Thanks!

When using parameters for a query it would be usefull if we could tell pash to set the parameters, for instance set ${type} for query below, but of course multiple parameters would be necessary.
SELECT NON EMPTY {[Measures].[Sum]} ON COLUMNS, {LastPeriods(15, CurrentDateMember([Date], '["Date.Year_month"]\.[yyyy-mm]') )} ON ROWS FROM [SomeCube] WHERE {[ype.Name].[${type}]}

Currently Pash seems to be only able to keep the history of one line MDX statements. If I write multiline ones, always only the first line is kept in the history. This is a bit inconvenient when there is an error in the original query and I want to fix this - so it would be excellent if the whole multiline query could be kept in the query history.

Consider

USE [system-local.public.rbouman.MdxForShine.models]

Go to end of line, use backspace. Notice that autocomplete starts working only after you reached the dash (-)

Might be nice to add a very small plugin that adds a command like:

SET THEME

Which would then insert .css into the of the page.

when typing a command (use steelwheels;) in firefox the input is often/sometimes catched by the search box in the find bar (find in page). So instead of typing the mdx query in patch, firefox wants to search for the query text on the page.
(using pentaho 5.4 plugin)

On click, we transfer focus to the textarea. This is to prevent losing typed text after user somehow makes the textarea lose focus (i.e by clicking).

Drawback of that approach is that any selection that the user made, is immediately lost. If you want to copy the selection, you now have to hold the mouse button down, hit Ctrl+C before releasing the mouse.

This has to be improved. Several scenarios possible.