Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Hi, I have a question about csv datasource.

  1. #1
    Join Date
    Jan 2018
    Posts
    1

    Question Hi, I have a question about csv datasource.

    Hello


    I have now attached a CSV file to the local PENTAHO Server Manage Data Source.
    I want to create a dashboard from CDE with this data.
    But I do not know how to import a CSV file from cde's datasorce.


    If you know how to get a CSV file from a CDE datasource, I would really appreciate it. I would appreciate it if you could include a URL with a description of it.


    summary.


    I attached the CSV format data to the Manage Data Source.
    But I want to import this data from CDE's datasource, but I do not know how.


    I would really appreciate it if you could attach a description or related URL.


    Thank you.

  2. #2
    Join Date
    Jan 2014
    Posts
    189

    Default

    Effectively you created a model, so the most direct way to consume that data is via a "mdx over mondrianJdbc" datasource, which implies you need to write your query using MDX.

    If you really must use SQL for the queries, I have a vague impression that the CSV gets staged as a table in the "hibernate" database (I'm not sure and did not bother to check)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.