KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Data Cube #2027

Open mustafa bulu opened this topic on on Apr 13, 2021 - 4 comments

mustafa bulu commented on Apr 13, 2021

I have created a data cube for AdventureWorks in the microsoft analysis server. But I cannot connect to the cube I created. I could not find an example where this connection was made before .How should I set the settings and setup function?

My settings function


public function settings()
    {
        
        return array(
            "dataSources"=>array(
                "sqlserver"=>array(
                    "connectionString" => "sqlsrv:Server=tcp:127.0.0.1;Database=AdventureWorks",
                    "username" => "sa",
                    "password" => "---"
                    
                   
                ),
            )
        );




My setup function



 public function setup()
    {
        $this->src('sqlserver')
    }


Sebastian Morales commented on Apr 14, 2021

Can you access the cube data using sql query?

mustafa bulu commented on Apr 14, 2021

I cannot access cube with sql query. I tried a few times but couldn't connect.

mustafa bulu commented on Apr 14, 2021

I have set the settings function to connect with windows authentication, but I still do not know what kind of query I need to write to access it.

Sebastian Morales commented on Apr 15, 2021

I suggest you get familiar with SQL Server's Cube using select query like this:

https://www.sqlservergeeks.com/sql-server-select-star-from-cube/

Once you can make a select query work with cube just use that query in your report's setup to retrieve and process data in koolreport. Tks,

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

None