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
Jose Juan Montes
@jjmontesl
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
and a cube defined as
Vigneshrajan
@ankithvicky
In my case i have to create a model with data from stored procedure. is it is possible to create model from sp?
Christian Ledermann
@cleder
    "cubes": [
        {
            "name": "posts_to_social",
            "label": "Posts to Social Media",
            "dimensions": ["site", "social_provider", "posted_at"],
            "aggregates": [
                    {
                        "name": "record_count",
                        "function": "count"
                    }
                ],
            "mappings": {
              "posted_at.year": {"column":"posted_at", "extract":"year"},
              "posted_at.quarter": {"column":"posted_at", "extract":"quarter"},
              "posted_at.month": {"column":"posted_at", "extract":"month"},
              "posted_at.week": {"column":"posted_at", "extract":"week"},
              "posted_at.day": {"column":"posted_at", "extract":"day"}
            },
            "joins": [
                {"master":"site_id", "detail":"site.site_id"}
            ]
        }
    ],
    "dimensions": [
        { "name": "site", "attributes": ["site_id", "name"] },
        { "name": "social_provider" },
        { "name": "posted_at",
          "label": "Posted",
          "template": "date",
          "order": "desc"
        },
        {
            "comment": "This is used as a template for other date dimensions.",
            "name": "date",
            "label": "Date",

            "role": "time",

            "levels": [
                {
                    "name": "year",
                    "order": "desc",
                    "order_attribute": "year",
                    "label": "Year"
                },
                {
                    "name": "quarter",
                    "label": "Quarter",
                    "order_attribute": "quarter",
                    "order": "desc"
                },
                {
                    "name": "month",
                    "label": "Month",
                    "order_attribute": "month",
                    "order": "desc"
                },
                {
                    "name": "week",
                    "label": "Week",
                    "order_attribute": "week",
                    "order": "desc"
                },
                {
                    "name": "day",
                    "label": "Day",
                    "order_attribute": "day",
                    "order": "desc"
                }
            ],
            "hierarchies": [
                {
                    "name": "weekly",
                    "label": "Weekly",
                    "levels": ["year", "week"]
                },
                {
                    "name": "monthly",
                    "label": "Monthly",
                    "levels": ["year", "quarter", "month"]
                },
                {
                    "name": "daily",
                    "label": "Daily",
                    "levels": ["year", "month", "day"]
                }
            ]
        }
    ]
}
Vigneshrajan
@ankithvicky
@cleder the mention above model data is from sp?
Christian Ledermann
@cleder
image.png
however the sorting is rather 'abritrary'
sp? @Vkynluv
Vigneshrajan
@ankithvicky
stored procedure. instead or retrieving data from tables and view. shall we fetch data from MSSql stored procedure?
Christian Ledermann
@cleder
well it should be possible how does sqlalchemy retrieve data from a stored procedure?
I think as an alternative approach you could define a view that calls the stored procedure
Vigneshrajan
@ankithvicky
Am not using sqlalchemy. am directly using
[Store]
url : mssql+pyodbc://Username:Password@Host:Port/DbName?driver=SQL+Server+Native+Client+11.0
Christian Ledermann
@cleder
this will use sqlalchemy with the mssql driver afaik
Vigneshrajan
@ankithvicky
Now i am not using prepare data file which contains query. I am directly using model.json file contains joins.
Christian Ledermann
@cleder
I lost you here
Vigneshrajan
@ankithvicky
Where?