biztech-it / btable Goto Github PK

When I want to update a filter in btable 2.1 on pentaho 5.4 (firefox/chrome) I can't reach the update filter button. According to the tutorial video at https://youtu.be/IYAlYdtZHwk?t=114 I should close the Filter section and the update filter appears. But nothing happens when I click the x at the filter bar.

Hello team, I can't export my btables to Excel in Internet Explorer, the problem is that my client only uses IE in their company and they can't change to another browser, can you help me, please?

When I click in "Export to Excel" a new blank tab opens but din't show me any message.

I'll appreciate your support. Thank you

The tab shows this:

with win 7, internet explorer 11 btable are not shown.
probably because of 'object doesn't support property or method 'includes'
Includes seems to get used in:
2 resources/components/BTable/BTableComponent.js
1 resources/components/BTable/lib/bt.utils.js
Solution seem to be to rewrite to use indexOf-statement

When I have some numeric numbers in the column, I don't want the default rounding convention.
Is there a way the set column width and data format?

We have a btable dashboard with cde selectboxes to filter on levels in a hierarchy.
We push this filter as dimension to the btable. (Most of the times we want to show the results on the lowest level). However when a filter is active on a level, it is not possible to remove this level from the btable (for instance by using the btable context menu), in our case all levels of the hierarchy are removed.
See attached adjustment of btable from scratch example. I only added two dimensions. If I remove EMEA from the btable, country level is also removed.
hierarchy_removal_bug.zip
Better use case example would be filter on Austria, UK and Australia and report at Territory level (removing country level)

The contextual menu (when right clicking in a cell) could be customized : depending on the role of the user (or any other parameter), one colud restrict the available commands.

Benoit

Hi,

Glad to see that the projetct is still alive and has evolved!
I'll try to help if I can.

I'm using biserver 5.4 and can't make the sample 'BTables with templates' : where should the templates files be located? On the filesystem? In the repository. I also get an error with this request :

http://localhost:8080/pentaho/plugin/BTable/api/file/read?path=/public/BTableCustom/Default.bttemplate

but I can't find the file Default.bttemplate anywhere

Thank you

Benoit

Edit : Sorry, I just discover this post http://bonomma.blogspot.fr/2017/01/announcing-btable-3x.html with the explanations

Using steelweels and having a pivotting dimension. I'm not able to remove a measure with the context menu of btable. In screenshot below I can not remove 'Fact Count'.

Hello,

Following MDX is generated by BTable Analyser (we are using Pivot and Subtotals feature of the BTable) which returns wrong result, i.e, product repeat for each category instead of returning only the products in a category.

with
set [Category_Category_Set] as '{[Category].[Category].Members}'
set [Product_Product_Set] as '{[Product].[Product].Members}'
set [Measures_Set] as '{[Measures].[Amount], [Measures].[DifferenceLastYear]}'
set [Time_Year_Set] as 'Filter({[Time].[Year].Members}, ([Time].[Year].CurrentMember.Name = "2013" OR [Time].[Year].CurrentMember.Name = "2014"))'
set [Time_Month_Set] as 'Filter(Filter({[Time].[Month].Members}, ([Time].[Month].CurrentMember.Name = "6")), ((Exists(Ancestor([Time].CurrentMember, [Time].[Year]), [Time_Year_Set]).Count > 0))))'
member [Category].[BT_TOTAL] as 'Aggregate([Category_Category_Set])'
member [Product].[BT_TOTAL] as 'Aggregate([Product_Product_Set])'

select NON EMPTY Crossjoin(Descendants([Time_Month_Set], [Time].[Month], SELF), [Measures_Set]) on COLUMNS,
NON EMPTY
Union(
Crossjoin([Category_Category_Set], Union([Product_Product_Set], [Product].[BT_TOTAL])),
Crossjoin([Category].[BT_TOTAL], [Product].[BT_TOTAL])) on ROWS
from [Sales]

Formula for calculated measure 'DifferenceLastYear' is:

([Measures].[Amount]/(ParallelPeriod([Time].[Year],1,[Time].CurrentMember),[Measures].[Amount])) -1

If we remove the DifferenceLastYear measure from the MDX then result is fine (no product repetition) and if we use some other formula for the calculated measure (for e.g. just - [Measures].[Amount] * 10 )then the result is also fine with the above MDX. If we do not use Subtotal feature then the result is fine and the MDX generated is:

select NON EMPTY Crossjoin(Descendants([Time_Month_Set], [Time].[Month], SELF), [Measures_Set]) on COLUMNS,
NON EMPTY
Union(
CrossJoin([Category_Category_Set], [Product_Product_Set]),
Crossjoin([Category].[BT_TOTAL], [Product].[BT_TOTAL])
) on ROWS
from [VentasAmcoSienaRtl]

We could not pinpoint where the problem is.

Can you please shed some light on the issue.

Thanks

Hi,

There is possibility to modify the source code to display in Btable a MDX Query from Datasources in CDE? If this is true, what file should be modify?

thanks

In table settings you have the options to hide spans, if checked it shows duplicate string in consecutive rows, very useful if you export the table to excel, but the strings in the header rows is also repeated. This doesn't looks nice. In the first attached file I would only want one string 'Line' in a spanned top left cell

So like this:

I have no preference for repeating the year (maybe a slight preference for not repeating)
So the green part of the second table should also be the green part of the first table.

How to set the excel export to generate .xlsx file?

Hi,

I am creating a Btable dashboard(pentaho 6) with mutiple hierarchy filters with ability to choose multiple options at each level. However it throws the below Exception when i try to apply more than 2 filters. I verified the data that is being passed to the btable component but it looks fine. Looks like the Btable component is not generating the query properly

Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature ' AND '
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:984)
at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:209)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2057)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)
at mondrian.olap.Formula.accept(Formula.java:107)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:159)
at mondrian.olap.Query.resolve(Query.java:581)
at mondrian.olap.Query.resolve(Query.java:476)
at mondrian.olap.Query.(Query.java:200)
at mondrian.olap.Query.(Query.java:161)
at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927)
at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1241)

Regards
Kishore

When clicking to get the context menu (version 3.0, pentaho 5.4 on ubuntu firefox) the context menu is not always placed correctly, so the top part of the menu is not shown. See screenshot:

Ps: great Work!!!!

Hi,

I've got a named set defined in my mondrian schema, and would like to know if there's a way to use it from within a BTable.

Cheers,

Mark

The drill could be activated with a "left click" in a cell.
As for displaying the facts corresponding to a measure, one should be able to provide a customized query.

Benoit

Tools like JPivot or Saiku can handle the coloring of celles as specified in the schema of the cube, e.g. :

It would be nice that Btable supports it.

Benoit

Hi guys,

I'm not sure if it's me doing something wrong or something broken in the code.

I'm trying to use a date range selector with two variables (START_DATE, END_DATE) and pass it along to a BTable in a 'between' filter.

My Dimenions has:

arg: "[Date.DAY].[Day]"
value: "between:START_DATE,END_DATE"

Which does not return the expected results. Looks like it's not using both parameters for the between clause, just the second one. Returns a string like this in the table filter line:

between 2014-05-11 and {1}

If I hardcode the dates ("between:[2014-01-01],[2014-02-01]") the query works fine.

Please let me know. Also, is there any documentation for how the filters work?

Two or more BTable on CDE dashbord with different jndi give me an error.
After all tables are rendered when i make some operations in first (or second) BTable the datasource conection will be a combination between this datasource and the last one accessed and result an error, because this plugin makes the datasource file in this form: catalog_jndi.cda
In this case i need to force BTable to use the proper CDA file, using pre execution field.

As workaround i add in Pre execution field of each BTable component on that page:

if(this.name == "render_BTableName"){
render_BTableName.cda.path = bt.helpers.cda.getFilePath("mondrian:/YourCatalog","YourJNDI");
}

where render_BTableName is the name of the component.