Drill-Across two cubes sharing one common dimension

2023-06-09 Thread marc nicole
Hello guys, I want to ask if it is possible to do a drill-across operation on two cubes based in Kylin that share one dimension in common and have two different fact tables? How to do that in Python? Thanks.

Re: Drill-Across two cubes sharing one common dimension

2023-06-09 Thread marc nicole
Just to add: I want to accomplish that, in the Development env (no Hadoop) under Windows. Is it possible? Le ven. 9 juin 2023 à 22:23, marc nicole a écrit : > Hello guys, > > I want to ask if it is possible to do a drill-across operation on two > cubes based in Kylin that share one

Dev evironment setup yields to blocking issue

2023-06-10 Thread marc nicole
I am setting the development environment for Kylin in Windows, and I am following their docs to do so :( https://kylin.apache.org/development40/dev_env.html) The docs state that If using IntellJ Idea>17 then there's a need to modify “server/kylin-server.iml” file, replace all “PROVIDED” to “COMPIL

measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

2023-08-01 Thread marc nicole
The measure is of type column (not constant) and is bigint. I selected the measure from the dropdown corretly as well. measure column returns 1 for all column values instead of actual values when querying the cube. What could be the underlying problem? cube or model defining? or maybe data source a

Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

2023-08-02 Thread marc nicole
have checked, I think you can give us you cube defination(CubeDesc > in Json) and the SQL statement you queried, so we can discuss in detail? > > > > -- > *Best wishes to you ! * > *From :**Xiaoxiang Yu* > > > At 2023-08-02 04:35:04, "marc nicole" wrote: > &g

Re: measure column showing 1 as values instead of the actual values in Kylin SQL Query answer table

2023-08-02 Thread marc nicole
the dataset (csv) is in this form att1 att2 count_measure str1 str2 int1 ... How to extract from it fact table (the count_measure column) and the dimensions ? in the datasource / model definition in Kylin? Le mer. 2 août 2023 à 13:32, marc nicole a écrit : > in the model the meas

Kylin defaut storage system is HDFS?

2023-08-26 Thread marc nicole
Hello, I have few questions regarding storage mean for Kylin: I was wondering if Kylin would work normally if I don't configure it to work with any storage tool (as MySQL with Sqoop Or with Hive)? It would then automatically use HDFS ? Also is configuring HBASE necessary? Could I use Kylin with

Re: Kylin defaut storage system is HDFS?

2023-09-02 Thread marc nicole
tps://kylin.apache.org/5.0/docs/deployment/on-premises/installation/platform/install_on_apache_hadoop > > > > With warm regard > Xiaoxiang Yu > > > > On Sat, Aug 26, 2023 at 8:03 PM marc nicole wrote: > >> Hello, >> >> I have few questi