by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jan 23 2019 11:40
    pktippa synchronize #467
  • Jan 23 2019 11:30
    pktippa edited #467
  • Jan 23 2019 11:30
    pktippa synchronize #467
  • Jan 23 2019 09:37
    pktippa opened #467
  • Jan 23 2019 09:35
  • Jan 21 2019 16:20
  • Jan 16 2019 03:18
    alexanderfefelov commented #332
  • Jan 05 2019 05:20
    jjmontesl labeled #449
  • Jan 05 2019 05:20
    jjmontesl labeled #449
  • Jan 05 2019 05:19
    jjmontesl assigned #449
  • Jan 05 2019 05:19
    jjmontesl commented #449
  • Jan 05 2019 05:17
    jjmontesl labeled #451
  • Jan 05 2019 05:16
    jjmontesl assigned #451
  • Jan 05 2019 05:16
    jjmontesl closed #451
  • Jan 05 2019 05:16
    jjmontesl commented #451
  • Jan 05 2019 05:11
    jjmontesl milestoned #445
  • Jan 05 2019 05:11
    jjmontesl labeled #445
  • Jan 05 2019 05:10
    jjmontesl unassigned #445
  • Jan 05 2019 05:10
    jjmontesl assigned #445
  • Jan 05 2019 05:10
    jjmontesl closed #445
Stefan Urbanek
@Stiivi
Hi @morrme
Stefan Urbanek
@Stiivi
Settings and type-aware extension creation #430
Stefan Urbanek
@Stiivi
@/all Final version of Cubes 2.0 goals: https://gist.github.com/Stiivi/3dd87f0ba920d2cae49e45d210bb0265
Michael Schwab
@schwab
Congratulations on the decision to begin working on Cubes 2.0. Having been a regular user in several projects for years, it's exciting to know the project will be moving forward again!
Stefan Urbanek
@Stiivi
@schwab thank you.
Michael Schwab
@schwab
Do you know BTW if slicer sql denormalize works? If so, is there an example of calling it somewhere? I always get Error: config should be a ConfigParser instance, but is <class 'str'>
Stefan Urbanek
@Stiivi
@schwab Can you please file an issue? Looks like in cubes.slicer.commands module all Workspace(config) have to be replaced with Workspace(read_config(config))
Michael Schwab
@schwab
OK, thanks for the response. I've submitted and issue and will try the fix today. If it goes well I'll submit a pull request.
Michael Schwab
@schwab
That fix gets past the config error, list now works, however denormoralize is now failing with " File "/home/mdmetrix-dev/.local/lib/python2.7/site-packages/cubes/sql/store.py", line 362, in create_denormalized_view
insp = reflection.Inspector.from_engine(engine)
NameError: global name 'engine' is not defined" cannot spend anymore time on it today, but may be able to come back to it towards the end of the week.
Stefan Urbanek
@Stiivi
@schwab replace engine with self.connectable
Jose Juan Montes
@jjmontesl
blob
Stil very early work.
But I'm working on quick integration paths between Pandas, CSV, SQL, Django and Cubes/CubesViewer, also integration with Jupyter Notebook
Jose Juan Montes
@jjmontesl
Automatically generating a model:
blob
Jose Juan Montes
@jjmontesl
Full pandas->cubesviewer pipeline:
blob
Christian Ledermann
@cleder
I'd like to view cubes through superset https://github.com/airbnb/superset has anyone tried this yet?
Jose Juan Montes
@jjmontesl
No, I didn't know it.
Christian Ledermann
@cleder
with bubbles how do I create indexes in the target

import bubbles

src_url = 'postgresql://primarysite:primarysite@localhost/primarysite'
dest_url = 'postgresql://primarysite:primarysite@localhost/slicer_db'

stores = {'source': bubbles.open_store('sql', src_url),
'target': bubbles.open_store('sql', dest_url), }
pl = bubbles.pipeline.Pipeline(stores=stores)
pl.source('source', 'core_site')

pl.create('target', 'core_site')
pl.run()

this creates a table as
CREATE TABLE core_site
(
id integer,
name character varying(255),
...)
without any indexes
Jose Juan Montes
@jjmontesl
not me
are you starting with this ETL now? is it for work or hobby?
Christian Ledermann
@cleder
yes I am starting
for now it is research into the tooling
I had a look at bubbles, metl (very short at petl and pygraml and bonobo)
I think I will use bubbles for the proof of concept and then have a second look at the above other tools#
proof of concept means: I am building a analytics db with cubes and use bubbles to get some initial data into it
Christian Ledermann
@cleder
the db will be used for work
Jose Juan Montes
@jjmontesl
I'm afraid I cannot help there. I use custom code for ETL processes.
krrishnayak
@krrishnayak
hey
when i run "slicer serve slicer.ini" i ge below error
  • Restarting with stat
    File "C:\Users\krishna\AppData\Local\Programs\Python\Python36\Scripts\slicer.exe", line 1
    SyntaxError: Non-UTF-8 code starting with '\x90' in file C:\Users\krishna\AppData\Local\Programs\Python\Python36\Scripts\slicer.exe on line 1, but no encoding declared; see http://python.org/dev/peps/pep-0263/ for details
Plz help
Борис Цейтлин
@Euphe
Hello!
Anyone still active about cubes? I need help!
Richard Banyi
@richban
@Euphe ping
Jose Juan Montes
@jjmontesl
Hi
Jonathan Drake
@drakej_twitter
is there a best practice for doing more advanced aggregations on top of the browser.aggregate() result?
e.g. i want to calculate the difference between subsequent rows via a window function:
{
                    'name': 'revenue_change',
                    'expression': "(lead(coalesce(sum(pl.revenue), 0)::integer, 1, 0) OVER (ORDER BY month_end DESC) - coalesce(sum(pl.revenue), 0)) AS delta"
                }
Jose Juan Montes
@jjmontesl
Not built-in. Personally in my client app(s) I always lay result cells on a table, and I do those calculations on top of such tables.
I don't know if there is some standard for that at any level. In the OLAP materials I've read that need is not usually even mentioned, or is left up to the reporting/visualization tool. Also afaik standards like MDX don't contemplate that explicitly, besides allowing subqueries.
Jose Juan Montes
@jjmontesl
MDX is more expressive though. You can usually do those things.
Jose Juan Montes
@jjmontesl
I prefer the simpler cubes+custom calculations approach though.
Jonathan Drake
@drakej_twitter
Ok thanks. I may fork cubes and allow the sql statement to be wrapped
Jose Juan Montes
@jjmontesl
:-)
Vigneshrajan
@ankithvicky
Is there any possibilities to create model from a stored procedure
Christian Ledermann
@cleder
Date sorting with CubesViewer 2.0.3-devel -
Server version: 1.1
Cubes version: 1.1
API version: 2