精华内容
下载资源
问答
  • Saiku

    千次阅读 2020-01-29 23:13:15
    参考 http://kylin.apache.org/blog/2019/05/23/saiku-kylin-molap/ ...Saiku 是一个用于 OLAP 分析的套件。用户可在浏览器中通过拖拽的方式进行分析。降低了使用者的学习成本。它能够连接多种数据源,如 Micros...

    参考

    http://kylin.apache.org/blog/2019/05/23/saiku-kylin-molap/

    https://mondrian.pentaho.com/documentation/schema.php

     

    简介

    Saiku 是一个用于 OLAP 分析的套件。用户可在浏览器中通过拖拽的方式进行分析。降低了使用者的学习成本。它能够连接多种数据源,如 Microsoft SQL Server, Oracle Database, MySQL, MongoDB 等。
    Saiku 支持两种连接方式:一是 Mondrian,二是 XMLA。
    Mondrian 是一个开源的商务分析引擎。使用 MDX(MultiDimensionalExpressions) 完成多维查询。
    XMLA(XML for Analysis)是一种基于简单对象访问协议(SOAP)的 XML 协议。

     

    下载

    https://community.meteorite.bi/

     

    安装

    [hadoop@hadoop1 soft]$ java -jar saiku-installer-3.17.jar 
    Jan 29, 2020 5:32:52 PM INFO: Logging initialized at level 'INFO'
    Jan 29, 2020 5:32:52 PM INFO: Commandline arguments: 
    Jan 29, 2020 5:32:52 PM INFO: Detected platform: linux,version=2.6.32-754.el6.x86_64,arch=x64,symbolicName=null,javaVersion=1.8.0_181
    Welcome to the installation of Saiku Enterprise 3.17!
    This software is developed by: 
     - Meteorite BI <info@meteorite.bi>
    The homepage is at: http://www.meteorite.bi
    
    Press 1 to continue, 2 to quit, 3 to redisplay
    1
    Please read the following information: 
    Thank you for downloading Saiku Enterprise. Your support
    allows us
     to develop Saiku and make the product even better.
    If you would like to see any features added to Saiku or need help and support
     with Saiku or you wider data warehousing, data integration or reporting
     needs please get in touch.
    
    Press 1 to continue, 2 to quit, 3 to redisplay
    1
    Your use of Saiku Enterprise is governed by the terms set out in this document, together with any terms or documents referred to or incorporated into this document, including our Privacy Policy available from tBy purchasing, downloading or using any part of Saiku Enterprise, you agree to the terms of this Agreement and in doing so you, will form a legally binding contract with OBSI Limited (trading as Meteorite) of CIf you Order, download or use the software on behalf of a company, partnership or other legal entity, you represent and warrant that you are doing so in the course of business and that you have the legal right The details relating to your Account, including (without limitation) all contact details and billing information, details of your Representative and details of authorised Account users, usernames and passwords.Our website at www.meteorite.biStatus  representationsBy agreeing to the terms of this Agreement, you represent that you are authorised and/or legally entitled to enter into this Agreement and that in doing so you will not breach any law or any obligation to any third party. If you are an individual, you represent and confirm that you are at least 18 years of age and have the requisite capacity to enter into legal agreements.Your Rights  ObligationsYou agree, on your own behalf and (where applicable) on behalf of all User(s) that you shall (a) pay all Fees promptly when due, (b) comply with all applicable laws and regulations relating to your use of the Software, (c) provide us with all data and other information reasonably required and ensure that the information provided is true, accurate, complete and not misleading in any material respect, (d) appoint a Representative(s) and ensure your Account Details are accurate and kept up to date, (e) carry out your responsibilities under this Agreement in a timely and efficient manner and notify us immediately upon becoming aware of any breaches or suspected breaches of this Agreement.Software ProductsIn order to use the Software provided in connection with this agreement you must activate the software with a valid license key. A valid license key will be provided upon receipt of payment for the software.Where Named User licenses are specified in the Order, individual Users can use the solution up to the number specified in the Order. No additional users can use the software unless an existing User is deleted. Where Server Users are specified in the Order, an unlimited number of authorised Users can use the Software on a single Server. The memory allocated to the Software must not exceed the amount set out in the Order.Where an Unlimited User license is specified in the Order, an unlimited number of users can use the product for a single specific application or purpose or as defined in the Order. Trial licenses can be used by a single User for evaluation purposes only for a period of 30 days. Test and development licenses can be used by up to 5Named Users for the period that the Named User or Server license remains valid. LicenseSubject to all of the terms and conditions of this Agreement, and except as set forth in Section9, Meteorite grants you a limited, worldwide, non-transferable, non-sublicensable (except as permitted under Sections 4.7 and 4.8), non-exclusive license to use the Software for which you have been issued a Product Key, but only in accordance with: (a) the Documentation; (b) the restrictions in Section 3 of this Agreement and any restrictions on the applicable Order; and (c) the number of authorised Users and/or permitted allocated memory (if applicable), on the platforms and configurations or other restrictions set forth in the applicable Order.Subject to the terms and conditions of this Agreement, Meteorite grants you a limited, worldwide, non- transferable, non-sublicensable, non-exclusive license to modify any sample source code from the Software provided by Meteorite to you (Sample Code) solely for internal use for the purposes of designing, developing, testing and otherwise facilitating your use of the Software under this Agreement.Production and Non-Production Environments:You may use the Software in a technical environment and on the platforms and configurations specified in the Documentation, solely for internal development and testing in connection with your licensed Software, or for backup purposes (Non-Production Environment). Your installation, activation or use of a copy of the Software in a Non-Production Environment is limited to the same number of authorised Users and/or permitted memory allocation as provided under Section 3 above. Your use of the Server Software in a Non-Production Environment may be concurrent with your use of the licensed Software in a Production Environment and such use is conditioned on you having an authorised license for the Software. Your commercial use of the Software is considered use within a Production Environment and you are entitled to 1 Production Environment for each Server orUnlimited User Software license you purchase under this Agreement. Your use of the Software in a Production Environment allows for a single Production Environment regardless of the fact that single Production Environment may not consume all the allocated memory identified on your Orderor at the time of purchase.You are entitled to make a reasonable amount of copies of the Software for archival purposes.Any open source software included in the Software, along with the applicable license, is listed in the Product license file or documentation. Such open source software is licensed to Licensee under the terms of the corresponding license.All Software and Documentation shall be delivered by electronic means unless otherwise specified on the applicable Orderor at the time of purchase. Software shall be deemed delivered when it is made available for download by you.You may permit third parties (Permitted Sublicensees) to access the Software as authorized Users from your servers on your behalf, provided that: (a) you shall remain responsible for the acts and omissions of such Permitted Sublicensees as if such were your acts and omissions; (b) such use is only for your benefit; and (c) upon request you will identify each such Permitted Sublicensee. Any use of the Software by Permitted Sublicensees shall be within the usage restrictions in the applicable Orderor specified at the time of purchase.Notwithstanding the prohibition against sub-licensing in Section 4.1, you may provide access or use of the Software to any third parties for such third partys own benefit (Third-Party Sublicensees), provided that: (a) you require the Third-Party Sublicensees to agree to terms at least as restrictive as than those contained in this Agreement (Sublicensee Terms); (b) the Sublicensee Terms will provide that Meteorite is a third-party beneficiary of such Sublicensee Terms and be as protective of Meteorite as this Agreement; and (c) you shall not sell, sublicense, rent, or lease the Software to a Third-Party Sublicensee for time sharing, hosting, service provider or like purpose. Any use of the Software by Third-Party Sublicensees shall be within the usage restrictions in the applicable Orderor specified at the time of purchase. The Support and Maintenance provisions in Section 6shall not apply to any use of the Software by Third-Party Sublicensees.You shall not (and shall not allow any third party to): (a) decompile, disassemble, or otherwise reverse engineer the Software or attempt to reconstruct or discover any source code, underlying ideas, algorithms, file formats or programming interfaces of the Software by any means whatsoever (except and only to the extent that applicable law prohibits or restricts reverse engineering restrictions); (b) distribute, sell, sublicense, rent, lease or use the Software or Sample Code (or any portion thereof) for time sharing, hosting, service provider or like purposes, except as expressly permitted under this Agreement; (c) remove any product identification, proprietary, copyright or other notices contained in the SoftwareorSample Code; (d) modify any part of the Softwareor Sample Codeorcreate a derivative work of any part of the Software or Sample Code (except as permitted in Section 4.2); (e) publicly disseminate performance information or analysis (including, without limitation, benchmarks) from any source relating to the Software or Sample Code; (f) utilize any equipment, device, software, or other means designed to circumvent or remove any form of Product Key or copy protection used by Meteorite in connection with the Software, or use the Software together with any authorization code, Product Key, serial number, or other copy protection device not supplied by Meteorite; (g) use the Software to develop a product which is competitive with any Meteorite product offerings; or (h) use unauthorised Product Keys or keycode(s) or distribute or publish keycode(s) except as may be expressly permitted by Meteorite in writing.Notwithstanding anything to the contrary contained herein, except for the limited license rights expressly provided herein, Meteorite and its suppliers have and will retain all rights, title and interest (including, without limitation, all patent, copyright, trademark, trade secret and other intellectual property rights) in and to the Software, Sample Code, and all copies, modifications and derivative works thereof (including any changes which incorporate any of your ideas, feedback or suggestions). You acknowledge that you are obtaining only a limited license right to the Software and Sample Code and that irrespective of any use of the words purchase, sale or like terms hereunder no ownership rights are being conveyed to you under this Agreement or otherwise.Fees and Payment You agree to pay the Fees in advance throughout the Term in accordance with the payment cycle set out in the Order. Unless otherwise agreed, all Fees are payable annually in advance. Payment shall be made in British Pounds, Euros or US Dollars, as specified in the Order. We may increase the Fees at any time by providing you with one months written notice, which shall become effective at the end of your then current term.All payment of undisputed Fees must be made in full (and without deduction) in cleared funds by the agreed payment dates. In the event that you fail to pay any amount on the due date, we shall be entitled (without prejudice to any other rights and remedies) to (a) restrict access to the Software, (b) charge interest on the overdue amount at the rate of 8% above the base rate of HSBC Bank plc until payment is received in full, and (c) require the immediate payment of the full outstanding balance of the Fees. All payments under this Agreement shall be made in full and without any set-off, withholding or other deduction.Any dispute relating to Fees must be raised within 7 days of receipt of our Order, failing which the Ordershall be deemed accepted and any right of dispute waived. Any undisputed portion of an Ordermust be paid in accordance with the terms of this clause 5. Customers in the UK and from the EU who do not supply a VAT number will have VAT added to the Fees at a rate of 20%. Customers from outside the EU and those from the EU who supply a VAT number at the time of registration will not be charged VAT. You are responsible for the payment of all other taxes, charges and duties that apply to the use of the Software.You will maintain accurate records as to the use of the Software as authorised by this Agreement including Server specifications and user details, for a period of at least two years from the last day of the Subscription Period. Meteorite may, upon ten days prior notice and during yournormal business hours, audit such records to verify that youhaveused the Software in accordance with the terms of this Agreement, provided that Meteorite may conduct no more than one audit in any twelve month period. Meteorite will use commercially reasonable efforts to minimize the disruption of yournormal business activities in connection with any such audit. Meteorite will not disclose any information learned in the course of its audit to any third party, except to exercise its rights under this Agreement. You will promptly pay Meteorite any underpayments revealed by any such audit.Support and MaintenanceWe will provide support and maintenance of the Software.Support will cover the Saiku Server and Saiku Web interfaceonly. We will not provide support for any third party software products, Mondrian, MDX, SQL, databases, web browsers, hardware or customisation of the Software under this agreement. Where support is provided and the cause of the issue is outside the scope of this agreement, we will charge you for the support in hourly periods at a rate of US$200 per hour or at our sole discretion in another currency at the prevailing exchange rate at the time of invoice. Payment will be due within 15 days afterthe invoice being issued.For the period of this Agreement you are entitled to updates, upgrades and Bug fix releases of the Software. Support requests will be made via the Meteorite support portal. Support requests will be assigned a priority based on severity (a) Priority 1 issues refer to a Bug that has caused a production system to stop functioning (b) Priority 2 issues refer to a Bug that has caused a component of a production system to function incorrectly (c) Priority 3 issues refer to any other Bug, including cosmetic errors or where a work around exists. We will attempt to address Bugs in a timescale based on priority level. (a) Priority 1 issues will be addressed within 3 working days. (b) Priority 2 issues will be addressed within 5 working days (c) Priority 3 issues will be addressed at the next Software release.The parties agree that no guarantee can be provided of the time taken to fix any support issue. Where we are unable to address a support issue within the time periods set out in section 7.4 we will keep you informed of progress and provide revised timescales. We will have no liability for issues caused by our failure to meet the support timescales in this agreement.IndemnitySubject to the provisions of Section 7.2, we agree to defend you against any third party claim, suit or proceeding (each, a Claim) alleging that the Software infringes any copyright, trade secret or patent. In addition, we will pay all of those fees and costs, including legal fees, resulting from such Claim, as well as all damages awarded against you, or any amounts agreed to by us in a monetary settlement, in connection with such Claim. We may, at our expense, attempt to resolve the Claim by: (a) modifying the Software to avoid the alleged infringement; (b) obtaining a license to permit you to use of the Software as contemplated by this Agreement; or (c) terminating the license grant set forth in this Agreement with respect to the Software and giving you a refund. You will cooperate fully with us in the implementation of any above-described resolution. We will have no liability if the applicable Claim to the extent is based on: (i) the combination of the Software with non-Meteorite products data or business processes; (ii) use of any release of the Software when use of a newer release avoids the infringement; or (iii) use of the Software outside the scope of the terms of this AgreementAs conditions of our obligations under this Section 7, You must: (a) promptly notify us in writing of such claim and furnish a copy of each communication or notice relating to the alleged infringement; (b) give us sole control over the defense and negotiation of any settlement of such claim and (c) give us, at our expense, all reasonable assistance as requested by us.You agree to defend, indemnify and hold us harmless against all other claims, actions, proceedings, losses, damages, expenses and costs (including without limitation court costs and reasonable legal fees) arising out of or in connection with your use of the Software and/or your breach or non-compliance with the terms of this Agreement.If we become aware of any claim relating to the aforementioned indemnity, we shall give you prompt notice of any the claim and provide you (at your cost) with reasonable co-operation in the defence and settlement of the claim. You shall have the sole authority to defend or settle the claim, save that you will obtain the prior written consent of Meteorite before settling any claim where it may have any implication, financial or otherwise, for Meteorite.LimitationSubject to Clause 7 this clause sets out our entire financial liability (including any liability for the acts or omissions of our employees, officers, agents and sub-contractors) to you in respect of (a) any breach of this Agreement; (b) any use made by you of the Software; and (c) any representation, statement or tortious act or omission (including negligence) arising under or in connection with this Agreement. Except as expressly and specifically provided in this Agreement all warranties, representations, conditions and all other terms of any kind whatsoever implied by statute or common law are, to the fullest extent permitted by applicable law, excluded from this Agreement. If you are a consumer, we specifically do not exclude any implied warranties or other rights which may not be excluded under applicable law. Nothing in this Agreement excludes liability (a) for death or personal injury caused by our negligence; (b) for fraud or fraudulent misrepresentation, or (c) which we may not exclude under applicable law. Subject to clause 8.3:We shall not be liable whether in tort (including for negligence or breach of statutory duty), contract, misrepresentation, restitution or otherwise for any loss of profits, loss of business, depletion of goodwill and/or similar losses or loss or corruption of data or information, or pure economic loss, or for any special, indirect or consequential loss costs, damages, charges or expenses however arising under this Agreement; andOur total aggregate liability in contract, tort (including negligence or breach of statutory duty), misrepresentation, restitution or otherwise, arising in connection with the performance or contemplated performance of this agreement shall be limited to the greater of 5000 or the total Fees paid for the Softwareduring the 12 months immediately preceding the date on which the claim arose.Term  TerminationThis Agreement shall commence on the Commencement Date and shall continue for the Term. Where you have chosen the auto-renew option in your Order, this Agreement shall automatically renew upon expiry for a further period equivalent to the Term and will continue thereafter on a rolling basis until or unless you cancel the auto-renew option upon the provision of a minimum of 30 days notice at which point the Agreement shall expire at the end of the then current Term. Where the auto-renew option has not been taken, this Agreement will expire at the end of the Term. Without prejudice to any other rights we may have, including any rights set out in this Agreement, we may terminate this Agreement immediately and without liability if:you fail to pay any amount due within 7 days of its due date;you provide to us any false, misleading or otherwise inaccurate information; we are required to terminate this Agreement to comply with any laws;Without prejudice to any other rights or remedies, either you or we may terminate this Agreement without liability if: the other commits a material breach of any of the terms of this Agreement which is not remediable or which (if remediable) fails to be remedied within 30 days of that party being notified in writing of the breach; orthe other ceases, or threatens to cease, to trade or an order is made or a resolution is passed for the winding up of the other party, or circumstances arise which entitle a court of competent jurisdiction to make a winding up order in relation to the other party or an administrator, liquidator or equivalent is appointed over the assets or the business of the other party or anything equivalent or analogous occurs in any jurisdiction.  On expiry or termination of this Agreement for any reason: all licences and other permissions granted under this Agreement shall immediately terminate and you shall cease to be entitled to the Software; no refund will be due on any fees paid for the Software and all outstanding fees shall become due for payment immediately.the accrued rights of the parties as at termination, or the continuation after termination of any provision expressly stated to survive or implicitly surviving termination, shall not be affected or prejudiced.Data protectionEach of us agrees to comply with our obligations under the Data Protection Act 1998, as that Act applies to each of our activities under this Agreement and/or the provision and use of the Software. We will not pass on your personal information to any third party except as required by law. You acknowledge and confirm that we may use your organisation name and logo on our Website and marketing materials. We will not divulge any further information about your organisation or yourNeither party shall have any liability under or be deemed to be in breach of this Agreement for any delays or failures in performance of this Agreement which result from circumstances beyond the reasonable control of that party. The party affected by such circumstances shall promptly notify the other in writing when such circumstances cause a delay or failure in performance and when they cease to do so. If such circuWe may amend the Agreement from time to time (including any details of the Software provided by us) by posting the amended terms on the Website. Amendments shall automatically come into effect 30 days after being posted on the Website unless you notify us that you do not agree to any of the proposed amendments. This Agreement may only otherwise be amended in writing, signed by duly authorised Representatives of both Parties. AssignmentYou may not assign, delegate, subcontract, mortgage, charge or otherwise transfer any or all of your rights and obligations under this Agreement without our prior written agreement. MeteoriteThis Agreement contains the whole agreement between you and Meteorite and supersedes and replaces any prior written or oral agreements, representations or understandings between us relating to the subject matter hereof. We each confirm that we have not entered into this Agreement on the basis of any representation that is not expressly incorporated into this Agreement. Nothing in this Agreement excludes liability forNo failure or delay by either party in exercising any right, power or privilege under this Agreement shall impair the same or operate as a waiver of the same nor shall any single or partial exercise of any right, power or privilege preclude any further exercise of the same of the exercise of any other right, power or privilege. The rights and remedies provided in this Agreement are cumulative and not exclusive of anyThis Agreement shall not constitute or imply any partnership, joint venture, agency, fiduciary relationship or other relationship between Meteorite and you other than the contractual relationship expressly provWe each agree, at the request and expense of the other, that we shall execute and do any deeds and other things reasonably necessary to carry out the provisions of this Agreement or to make it easier to enforceIf any provision of this Agreement is prohibited by law or judged by a court to be unlawful, void or unenforceable, the provision shall, to the extent required, be severed from this Agreement and rendered ineffIn this Agreement unless the context otherwise requires:words importing any gender include every gender;words importing the singular number include the plural number and vice versa;words importing persons include firms, companies and corporations and visa versa;any obligation on any party not to do or omit to do anything is to include an obligation not to allow that thing to be done or omitted to be done;the headings to the clauses and paragraphs of this Agreement are not to affect the interpretation;the word including shall be understood as meaning including without limitation.NoticesAny notice to be given under this Agreement shall be in writing and shall be sent by courier or by e-mail, to the address (postal or email) of the relevant party.Any notice delivered by email will be deemed to have been delivered on receipt of an aThis Agreement (and any dispute, controversy, proceedings or claim of whatever nature arising out of or in any way relating to this Agreement or its formation) shall be governed by and construed in accordance with English law. The Parties agree that the English Courts shall have exclusive jurisdiction to hear and settle any action, suit, proceeding or dispute in connection with this Agreement and irrevocably submit tPage| e purposes of the Contracts (Rights of Third Parties) Act 1999 this Agreement is not intended to, and does not, give any person who is not a party to it any right to enforce any of its provisions.
    
    Press 1 to accept, 2 to reject, 3 to redisplay
    1
    Select the installation path:  [/home/hadoop/Saiku Enterprise] 
    /home/hadoop/saiku-3.17
    
    Press 1 to continue, 2 to quit, 3 to redisplay
    1
    1    [x] [Base] (240.27 MB)
          >> Required
    2    [x] [Docs] (1.48 MB)
    3    [x] [Sample Data] (48.95 MB)
    Total space required: 290.7 MB
    Press 0 to confirm your selections.
    Please select which packs you want to install.
    0
    Done!
    
    Press 1 to continue, 2 to quit, 3 to redisplay
    1
    Please read the following information: 
    Getting a license
    To get a Saiku Enterprise license you need to register at our licensing portal here: http://licensing.meteorite.bi. Once logged in you can download a trial license or a purchase full
    license which will be instantly available for
    download.
    
    Press 1 to continue, 2 to quit, 3 to redisplay
    1
    Jan 29, 2020 5:35:28 PM INFO: Cannot find named resource: 'userInputLang.xml' AND 'userInputLang.xml_eng'
    Enter the path to your license Key:
     [] 
    /home/hadoop/soft/license_hadoop1.lic
    
    Press 1 to continue, 2 to quit, 3 to redisplay
    1
    Jan 29, 2020 5:38:33 PM INFO: Cannot find named resource: 'userInputLang.xml' AND 'userInputLang.xml_eng'
    Jan 29, 2020 5:38:33 PM INFO: Invalid value for 'align': bottom in file:/home/hadoop/soft/saiku-installer-3.17.jar!/resources/userInputSpec.xml:39
    Jan 29, 2020 5:38:33 PM INFO: Invalid value for 'align': bottom in file:/home/hadoop/soft/saiku-installer-3.17.jar!/resources/userInputSpec.xml:63
    Saiku Settings
    
    ------------------------------------------
    HTTP Port: [8080] 
    
    
    AJP Port: [8009] 
    
    
    Webdav Password: [sa!kuanalyt!cs] 
    admin
    
      [x] Start Saiku Server
    Enter 1 to select, 0 to deselect: 
    
    
      [x] Use the default Jackrabbit Repository(unselect with caution)
    Enter 1 to select, 0 to deselect: 
    1
    
    ------------------------------------------
    
    
    Press 1 to continue, 2 to quit, 3 to redisplay
    1
    [ Starting to unpack ]
    [ Processing package: Base (1/3) ]
    [ Processing package: Docs (2/3) ]
    [ Processing package: Sample Data (3/3) ]
    [ Unpacking finished ]
    [ Starting processing ]
    Starting process do xyz (1/1)
    /home/hadoop/saiku-3.17/server
    DEBUG: Using JAVA_HOME
    DEBUG: _JAVA=/opt/java/bin/java
    Tomcat started.
    ──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
    Create shortcuts in the Start-Menu
    ──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
    Enter Y for Yes, N for No: 
    Y
    Jan 29, 2020 5:39:19 PM WARNING: Cannot write to '/usr/share/applications'
    Jan 29, 2020 5:39:19 PM WARNING: Could not copy  to /home/hadoop/.local/share/pixmaps(  (No such file or directory) )
    Jan 29, 2020 5:39:19 PM WARNING: Could not copy  to /home/hadoop/.local/share/pixmaps(  (No such file or directory) )
    Jan 29, 2020 5:39:19 PM WARNING: Could not copy  to /home/hadoop/.local/share/pixmaps(  (No such file or directory) )
    Jan 29, 2020 5:39:19 PM WARNING: Could not copy  to /home/hadoop/.local/share/pixmaps(  (No such file or directory) )
    ──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
    Generate an automatic installation script
    ──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
    Enter Y for Yes, N for No: 
    Y
    Select the installation script (path must be absolute)[/home/hadoop/saiku-3.17/auto-install.xml]
    
    Installation was successful
    application installed on /home/hadoop/saiku-3.17
    [ Writing the uninstaller data ... ]
    [ Console installation done ]

    以下是旧版本操作方式:

    1.执行 unzip saiku-latest.zip 解压下载好的 Saiku 包,切换至 saiku-server 文件夹。解压下载好的 Kylin 包,进入解压后文件夹,将 lib/kylin-jdbc-.jar 拷贝至 /home/hadoop/saiku-server/tomcat/webapps/saiku/WEB-INF/lib

    2.在 saiku-server 文件夹下执行 ./start-saiku.sh 命令启动 Saiku,启动后可在浏览器中输入 http://localhost:8080 访问 Saiku 页面。默认端口为 8080,可在 saiku-server/tomcat/conf/server.xml 中进行修改。

    [hadoop@hadoop1 saiku-server]$ ./start-saiku.sh 
    .
    /home/hadoop/saiku-server
    DEBUG: Using JAVA_HOME
    DEBUG: _JAVA=/opt/java/bin/java
    Using CATALINA_BASE:   /home/hadoop/saiku-server/tomcat
    Using CATALINA_HOME:   /home/hadoop/saiku-server/tomcat
    Using CATALINA_TMPDIR: /home/hadoop/saiku-server/tomcat/temp
    Using JRE_HOME:        /opt/java
    Using CLASSPATH:       /home/hadoop/saiku-server/tomcat/bin/bootstrap.jar:/home/hadoop/saiku-server/tomcat/bin/tomcat-juli.jar
    Tomcat started.

     

    注册

    访问 https://licensing.meteorite.bi/login 进行注册并登录

    然后邮件确认成功

    创建新的License

    下载License

    登录

    直接登录因为没有授权所以会报错:Error fetching license. Get a free license from http://licensing.meteorite.bi. You can upload it at /upload.html

    登录http://hadoop1:8080/upload.html,然后上传lincense

    再次登录

     

    配置

    <Schema name="demo">
        <Cube name="demo" cache="false" enabled="true">
            <Table name="FACT_TRAN"></Table>
            <Dimension name="时间" foreignKey="DATA_DATE">
                <Hierarchy hasAll="true" allLevelName="所有时间" allMemberName="All date" primaryKey="ID1">
                    <Table name="DIM_DATE"></Table>
                    <Level name="年" column="ID3" nameColumn="NAME3" ordinalColumn="ID3"></Level>
                    <Level name="月" column="ID2" nameColumn="NAME2" ordinalColumn="ID2"></Level>
                    <Level name="日" column="ID1" nameColumn="NAME1" ordinalColumn="ID1"></Level>
                </Hierarchy>
            </Dimension>
            <Dimension name="地区" foreignKey="LOCATION">
                <Hierarchy hasAll="true" allLevelName="所有地区" allMemberName="All location" primaryKey="ID1">
                    <Table name="DIM_LOCATION"></Table>
                    <Level name="市" column="ID2" nameColumn="NAME2" ordinalColumn="ID2"></Level>
                    <Level name="区" column="ID1" nameColumn="NAME1" ordinalColumn="ID1"></Level>
                </Hierarchy>
            </Dimension>
            <Dimension name="渠道" foreignKey="CHANNEL">
                <Hierarchy hasAll="true" allLevelName="所有渠道" allMemberName="All channel" primaryKey="ID1">
                    <Table name="DIM_CHANNEL"></Table>
                    <Level name="渠道" column="ID2" nameColumn="NAME2" ordinalColumn="ID2"></Level>
                    <Level name="方式" column="ID1" nameColumn="NAME1" ordinalColumn="ID1"></Level>
                </Hierarchy>
            </Dimension>
            <Dimension name="产品" foreignKey="PROD_TYPE">
                <Hierarchy hasAll="true" allLevelName="所有产品" allMemberName="All prod" primaryKey="ID1">
                    <Table name="DIM_PROD"></Table>
                    <Level name="产品" column="ID1" nameColumn="NAME1" ordinalColumn="ID1"></Level>
                </Hierarchy>
                </Dimension>
            <Measure name="金额(元)" column="TRAN_AMT" formatString="#,##0.00" aggregator="sum"></Measure>
        </Cube>
    </Schema>

    ADD Schema:上传预先配置好的多维XML

    Add Data Source

    type=KylinOLAP
    name=KylinDS
    driver=mondrian.olap4j.MondrianOlap4jDriver
    location=jdbc:mondrian:Jdbc=jdbc:kylin://hadoop3:7070/demoPro;Catalog=mondrian:///datasources/demo.xml;JdbcDrivers=org.apache.kylin.jdbc.Driver
    username=admin
    password=KYLIN
    security.enabled=false

    Save成功之后就是空白页面 

     报错:

    Caused by: java.sql.SQLException: No suitable driver found for jdbc:kylin://hadoop3:7070/demoPro
        at java.sql.DriverManager.getConnection(DriverManager.java:689)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)
        at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
        at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:212)
        ... 106 more

    方案:

    将kylin-jdbc-2.6.4.jar放入/home/hadoop/saiku-server/tomcat/webapps/saiku/WEB-INF/lib

     

    测试

     

     

    展开全文
  • saiku

    2016-05-28 09:17:45
    Saiku成立于2008年,由Tom Barber和Paul Stoellberger研发。最初叫做Pentaho分析工具,起初是基于OLAP4J库用GWT包装的一个前端分析工具。经过多年的演化、重写之后,于2010年,改名为Saiku。 OLAP分析 ...

    转载自:  http://blog.csdn.net/sunyingyuan/article/details/41944035

    简介

    Saiku成立于2008年,由Tom Barber和Paul Stoellberger研发。最初叫做Pentaho分析工具,起初是基于OLAP4J库用GWT包装的一个前端分析工具。经过多年的演化、重写之后,于2010年,改名为Saiku。

    OLAP分析

    OLAP(On-Line Analytical Processing,联机分析处理)是一个使分析师、管理者和执行者从原始数据中用来快速、一致、交互访问的一种软件技术,从而真实的反映企业的数据情况。OLAP功能特点是动态多维分析整合企业数据。

    通过OLAP,Saiku允许用户选择指标和维度用来分析,并且可以对数据进行“切块和切片”和钻取到细节中从而揭开其中的关系。用户可以在非常友好的界面下利用OLAP和内存引擎进行向下钻取,过滤、分类、排序和生成图表。利用Olap4J库,Saiku成为市场上第一个应用程序提供支持Mondrian的技术解决方案,让用户能够利用Mondrian分析数据。

    架构

    Saiku是一个轻量级的OLAP分析引擎,可以方便的扩展、嵌入和配置。Saiku通过REST API连接OLAP系统,利用其友好的界面为用户提供直观的分析数据的方式,它是基于jQuery做的前端界面。

    它的用户界面完全可以自定义。它的界面是用HTML、CSS和Javascript做的,从而使得它非常容易改变或完全替代。通过使用REST的标准,服务器可以很容易地集成到不同的用户界面和第三方应用程序上,唯一的要求是第三方应用程序可以发送和接受HTTP通信和接收JSON格式的数据。客户端程序不需要了解MDX和相关的查询语言。

    开源

    Saiku可以从www.analytical-labs.com免费下载。企业无需支付任何许可费用即可免费的在内部使用。

    展开全文
  • In saiku-server\pom.xml i found dependency to saiku-ui. As i understand, saiku-ui moved to another project, and saiku-webapp should be declared instead. <p>Thank you.</p><p>该提问来源于开源项目ÿ...
  • saiku-saiku-3.6.zip

    2020-01-03 17:08:17
    saiku源码,Saiku是一个模块化分析套件,提供轻量级OLAP,易于嵌入,可扩展和可配置。Saiku RESTful服务器连接到现有的OLAP系统,通过我们基于轻量级JQuery的前端为用户友好,直观的分析提供支持。
  • pentaho saiku插件

    2017-03-14 12:31:02
    pentaho saiku插件
  • Saiku 系列

    2019-03-06 22:51:00
    1.Saiku2.6 Saiku315 链接SQL的JDBC字符串 2.Saiku2.6 配置数据源 3.Saiku2.6 保存查询后,重新打开报 Error Loading Query错误。 4.CBoard 如何连接 Saiku2.6数据源 转载于:...
    展开全文
  • saiku源码,Saiku是一个模块化分析套件,提供轻量级OLAP,易于嵌入,可扩展和可配置。Saiku RESTful服务器连接到现有的OLAP系统,通过我们基于轻量级JQuery的前端为用户友好,直观的分析提供支持。
  • saiku相关jar包

    2018-08-13 16:15:32
    1、saiku相关的jar包(saiku-olap-util-2.6.1-SNAPSHOT.jar、saiku-query-0.1-SNAPSHOT.jar、saiku-service-2.6.1-SNAPSHOT.jar、saiku-web-2.6.1-SNAPSHOT.jar); 2、saiku相关jar包的maven写法 maven本地安装jar...
  • saiku-3.9.zip

    2020-02-28 11:27:27
    直接解压进入saiku-server,windows系统下点击start-saiku.bat运行,linux系统下点击start-saiku.sh运行
  • saiku 3.17jar包

    2018-11-30 16:50:30
    saiku源代码很难下载了。所以这次整理了之前官网下载的内容,可以直接通过java -jar saiku-3.1.7.jar 运行
  • [saiku]saiku3.8项目搭建步骤

    千次阅读 2017-11-14 16:03:47
    欢迎关注个人微信公众号:pengjun0308123,最实在的干货分享。saiku3.8项目搭建步骤:1....在下载的saiku项目中找到\tomcat\webapps\saiku\WEB-INF\lib文件夹,将里面的jar包全部复制到新建的saiku项...

    欢迎关注个人微信公众号:pengjun0308123,最实在的干货分享。


    saiku3.8项目搭建步骤:

    1.下载saiku源码和saiku项目(内置tomcat,可直接运行),这里我用的都是3.8版本。


    2.MyEclipse中新建web项目saiku


    3.在下载的saiku项目中找到\tomcat\webapps\saiku\WEB-INF\lib文件夹,将里面的jar包全部复制到新建的saiku项目的WEB-INF\lib中。


    4.在创建的saiku项目中,分别创建sourcefolder“saiku-web”“saiku-service”“saiku-olap-util”,并将saiku-core下的相应代码(Java目录下和resources目录下的文件)分别copy到里面,注意不要overwrite


    5.saiku源码中的saiku-webapp\src\main\webapp目录下的所有文件,覆盖到新建项目的WebRoot目录中


    6.将下载的saiku项目中的tomcat\webapps\下的ROOT目录中文件全部copy到新建项目的WebRoot目录中


    7.将下载的saiku项目中的saiku-server目录下的datarepository文件夹copy到项目的WebRoot目录中


    8.修改saiku-beans.properties文件,修改所有“../../”的地方替换为“../webapps/saiku/”,修改pluginpath“../webapps/saiku/js/saiku/plugins/”


    9.如果org.saiku.olap.query2.util下的fat.java文件报错,鼠标指在错误代码出,add argument tomatch即可(原因不详)。


    10.如果jsjsp文件报错,请修改eclipse配置忽略或者手动修改错误。


    最终的代码结构如图所示:


     

    启动tomcat,输入地址http://localhost:8080/saiku/进入登陆页面,用户名admin,密码admin即可登录。



    展开全文
  • saiku安装部署资源

    2018-03-16 16:14:42
    Saiku_学习_01_在Tomcat下部署saiku(http://www.cnblogs.com/shirui/p/8573491.html),博客中需要用的资源
  • saiku-lib.rar

    2020-08-02 16:56:41
    由于网络限制等问题,saiku源代码编译时所需要使用到的所有jar文件不太容易下载到。本压缩包中包括了所需要的jar文件,以帮助saiku使用者编译源码,重新打包。
  • saiku安装

    千次阅读 2018-06-28 15:50:29
    saiku安装使用经过一天的查询资料摸索,记录一下笔记,方便以后使用。1、http://community.meteorite.bi/ 下载;2、解压运行对应系统脚本文件。3、访问8080可以进入登录页面。4、...
  • Saiku资源帖

    2019-04-24 14:40:00
    一、精选 1.李秋 随笔分类 - pentaho 二、概述 1、Saiku + Kylin 多维分析平台探索 三、Saiku+Kylin ...1、使用Saiku+Kylin构建多维分析OLAP平台...4、[saiku] 在 Tomcat 下部署 saiku 5、【转】saiku与kylin整...
  • title: saiku+kettle整合(五)saiku使用 tags: OLAP categories: saiku date: 2016-08-25 18:18:54 saiku使用 导入schema 导入数据源 新建查询
  • 修改环境变量为安装目录下的tomcat目录:CATALINA_HOME = D:\yizit\software\saiku-server\tomcat执行start-saiku.bat启动saiku,启动后命令行窗口不能关闭。命令窗口中文乱码情况,需要修改start-sai...
  • 一、下载saiku 1.下载地址 官网:https://community.meteorite.bi/ 2.解压后文件结构 3.ROOT和saiku 在tomcat/webapp 下有两个web应用,是与saiku相关的。 将环境变量中的CATALINA_HOME设置为...
  • saiku 展示优化

    2019-09-24 08:19:58
    saiku版本:3.7.4 下面是修改步骤,如果觉得麻烦,可以直接下载源代码:https://github.com/lihehuo/saiku 1、关闭自动执行 修改文件:saiku-ui/js/saiku/Settings.js,下面是git代码对比 ERROR_TOLERANCE: 3...
  • Building saiku-webapp

    2020-11-27 19:01:42
    [ERROR] Failed to execute goal org.apache.maven.plugins:maven-dependency-plugin:2.1:copy (copy) on project saiku-server: Unable to find artifact. Failure to find org.saiku:saiku-webapp:war:2.5 in ...
  • title: saiku+kettle整合(十二)saiku执行过程 tags: olap saiku categories: saiku date: 2016-08-25 18:18:54 saiku执行过程 简单跟了一下saiku的执行过程 saiku ui发送请求至/saiku/api/query/execute ...
  • Saiku3.1构建过程(包含Saiku-UI)

    千次阅读 2015-05-22 16:05:33
    之前构建了saiku3.1,没去细看saiku-ui无法构建的问题如何解决,现在已经解决,分享给大家
  • Saiku简介

    万次阅读 2014-12-15 15:16:36
    Saiku成立于2008年,由Tom Barber和Paul Stoellberger研发。最初叫做Pentaho分析工具,起初是基于OLAP4J库用GWT包装的一个前端分析工具。经过多年的演化、重写之后,于2010年,改名为Saiku
  • saiku-documentation.pdf

    2019-08-24 18:06:53
    主要针对saiku操作以及原理说明的文档,纯英文的哦,有兴趣的小伙伴可以参考。

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 667
精华内容 266
关键字:

Saiku