Cannot drill-down Olap hierarchy in BI module

Fixed in trunk-extra-addons (rev no. 3663)

Thanks for reporting.

I've just updated my local sources from launchpad and recreated a new database.

Unfortunately the defect is still reproducible. The same effects.

In the left panel of BI browser after selecting Olap schema and cube I can open Olap dimension and see Olap hierarchy, but I cannot expand any Olap hierarchy - at this moment the application server shows the mentioned error.

My environment configuration:
Windows XP SP 3
PostgreSQL 8.3.4
python 2.5
SQLAlchemy-0.5.3
pyparsing-1.5.2
(I've installed the latest versions of all required python packages)

All other modules work well.

Hello,

Instead of communicating on forum and here too , I propose we talk at one place only :).
I did some minor changes to solve the problem.

Pls. Take the update on
olap module (trunk-extra-addons)
bi specific web client ( client-new-trunk)

Let us know if it helped or you can again change the status of this bugs.

Thanks for your bringing this bug.

Hello asb,

You should not suggest people to communicate over channel. It's always better to cross reference discussions taken place on forum while you discuss related bugs. Because you might get lot more opinions/suggesting from forum then launchpad...

Hello guys,

I also think that issues should be discussed widely.
Of course, there could be other opinions/helps. Also our discussion could help somebody to resolve similar (or same) issue(s).

I've downloaded all recent source code changes and created a new database.
Now I see another error message:
Parsing MDX...
        select {[Users].children} on rows from Sales
[2009-07-19 23:10:11,842] ERROR:web-services:[01]: Traceback (most recent call last):
[2009-07-19 23:10:11,842] ERROR:web-services:[02]: File "D:\Projects\Workspace\OpenERP-Server\bin\osv\osv.py", line 59, in wrapper
[2009-07-19 23:10:11,842] ERROR:web-services:[03]: return f(self, dbname, *args, **kwargs)
[2009-07-19 23:10:11,842] ERROR:web-services:[04]: File "D:\Projects\Workspace\OpenERP-Server\bin\osv\osv.py", line 119, in execute
[2009-07-19 23:10:11,842] ERROR:web-services:[05]: res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
[2009-07-19 23:10:11,842] ERROR:web-services:[06]: File "D:\Projects\Workspace\OpenERP-Server\bin\osv\osv.py", line 111, in execute_cr
[2009-07-19 23:10:11,842] ERROR:web-services:[07]: return getattr(object, method)(cr, uid, *args, **kw)
[2009-07-19 23:10:11,842] ERROR:web-services:[08]: File "D:\Projects\Workspace\OpenERP-Server\bin\addons\olap\olap.py", line 282, in request
[2009-07-19 23:10:11,842] ERROR:web-services:[09]: mdx = mdx_parser.parse(request)
[2009-07-19 23:10:11,842] ERROR:web-services:[10]: File "D:\Projects\Workspace\OpenERP-Server\bin\addons\olap\cube\mdx_parser.py", line 163, in parse
[2009-07-19 23:10:11,842] ERROR:web-services:[11]: return self.mdx_query().parseString(query)[0]
[2009-07-19 23:10:11,842] ERROR:web-services:[12]: File "D:\Projects\Workspace\OpenERP-Server\bin\addons\olap\cube\mdx_parser.py", line 157, in mdx_query
[2009-07-19 23:10:11,842] ERROR:web-services:[13]: mdx = selectToken + self.mdx_axis_list() + fromToken + self.mdx_cube() + Optional(whereToken + self.mdx_s
[2009-07-19 23:10:11,842] ERROR:web-services:[14]: File "D:\Projects\Workspace\OpenERP-Server\bin\addons\olap\cube\mdx_parser.py", line 116, in mdx_axis_list
[2009-07-19 23:10:11,842] ERROR:web-services:[15]: axis_parser = self.mdx_cross_axis() + Optional(onToken + page_name)
[2009-07-19 23:10:11,842] ERROR:web-services:[16]: File "D:\Projects\Workspace\OpenERP-Server\bin\addons\olap\cube\mdx_parser.py", line 101, in mdx_cross_axis
[2009-07-19 23:10:11,842] ERROR:web-services:[17]: cross_mdx = crossx | self.mdx_axis()
[2009-07-19 23:10:11,842] ERROR:web-services:[18]: File "D:\Projects\Workspace\OpenERP-Server\bin\addons\olap\cube\mdx_parser.py", line 76, in mdx_axis
[2009-07-19 23:10:11,842] ERROR:web-services:[19]: level_parse = self.mdx_level()
[2009-07-19 23:10:11,842] ERROR:web-services:[20]: File "D:\Projects\Workspace\OpenERP-Server\bin\addons\olap\cube\mdx_parser.py", line 46, in mdx_level
[2009-07-19 23:10:11,842] ERROR:web-services:[21]: scalar = Word(alphanums+ alphas8bit +"_"+" "+"-" )
[2009-07-19 23:10:11,842] ERROR:web-services:[22]: UnicodeDecodeError: 'ascii' codec can't decode byte 0x83 in position 26: ordinal not in range(128)

Thanks,
Michael

:)

Hello Michael,

Its strange that still error continues. Can you tell which encoding (utf-8, latin1 ... ) for the database to connect. I thnk its utf-8 only.

The issue is reproducible if localization settings of Windows account under which OpenERP App server is launched are non-latin.

For example, set "Ukrainian" to the field "Standards and formats" of the window "Regional and Language Options" invoked from Windows Contrrol Panel.

On the other hand the application works properly in the following configuration:
    Standards and formats (1st page of the mentioned window) - English (United States)
    Location (1st page) - Ukraine
    Language for non-Unicode programs (3rd page) - Ukrainian

So, other localization settings ("Location" and "Language for non-Unicode programs") don't influence application behaviour.

Hello asb,

All OpenERP databases are created from the application and have UTF8 encoding.
Details you can find in enclosed screenshot of my database options shown by pgAdmin.

Fill free to ask me more details if you think I can help you.

With kind regards,
Michael

Hello Michael,
 I have tried same way using same configuration as u said:

 For example, set "Ukrainian" to the field "Standards and formats" of the window "Regional and Language Options" invoked from Windows Contrrol Panel.

On the other hand the application works properly in the following configuration:
    Standards and formats (1st page of the mentioned window) - English (United States)
    Location (1st page) - Ukraine
    Language for non-Unicode programs (3rd page) - Ukrainian

and i have checked using encoding utf-8. its work good.
so may i know that u r using postgresql of openerpallinone? which locale u have for postgresql?
database encoding is utf-8 or koi-8 u?

Hello Michael,

 Thanks for reporting this bug.
 fixed in :
   trunk-extra-addons(olap): rev-no: 3825
  client-new-trunk(bi web client): rev-no: 2046

Thanks.