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
Christian Ledermann
@cleder
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
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?
Christian Ledermann
@cleder
Now i am not using prepare data file which contains query. I am directly using model.json file contains joins.
Vigneshrajan
@ankithvicky
Okay. any other solutions to create model from store procedure.
You cannot call a stored proc from inside a view. It is not supported. However you can make views call other views, or table-valued user-defined functions.
Christian Ledermann
@cleder
cubes (sqlalchemy) needs a table or view to operate on, so you have to materialize the results of the sp
Vigneshrajan
@ankithvicky
have to materialize the results of the sp ? means
Christian Ledermann
@cleder
create a table with the result set
how good are your AngularJS skills?
Christian Ledermann
@cleder
also I cannot see the order by in the SQL:
DEBUG SQL(aggregation drilldown):
SELECT EXTRACT(year FROM posts_to_social.posted_at) AS "posted_at.year", EXTRACT(quarter FROM posts_to_social.posted_at) AS "posted_at.quarter", EXTRACT(month FROM posts_to_social.posted_at) AS "posted_at.month", count(posts_to_social.id) AS record_count 
FROM posts_to_social GROUP BY EXTRACT(year FROM posts_to_social.posted_at), EXTRACT(quarter FROM posts_to_social.posted_at), EXTRACT(month FROM posts_to_social.posted_at)
or the get request:
"GET /cube/posts_to_social/aggregate?drilldown=posted_at%40monthly%3Amonth HTTP/1.1"
Christian Ledermann
@cleder
cubes viewer is written with angularjs and d3js charts so to integrate amcharts you will have to rewrite it
Christian Ledermann
@cleder
OT: have you seen https://github.com/kayak/fireant looks like something to have an eye on
leowmjw
@leowmjw
My
Christian Ledermann
@cleder
I try to denormalize my cubes but the denormalize fails