精华内容
参与话题
问答
  • 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

    2015-03-17 13:28:00
    1.saiku下载...2.下载到 saiku-latest.zip 3.解压运行比较简单 解压出来的目录:   4.数据源的添加 1)在saiku-server\tomcat\webapps\saiku\WEB-INF\classes目录下可以看到如下目录:  ...
    1.saiku下载http://community.meteorite.bi/可以下载各个版本的源代码
    2.下载到   saiku-latest.zip
    3.解压运行比较简单
        解压出来的目录:
      
     4.数据源的添加
            1)在saiku-server\tomcat\webapps\saiku\WEB-INF\classes目录下可以看到如下目录:
         
           ps:这些目录是saiku更新之后的遗留发布方式,saiku主要支持在页面上的AdminConsole来添加数据源和cube文件。
         2)在legay-datasources中新建文件fact_sales,内容如下:
    type=OLAP
    name=fact_sales
    driver=mondrian.olap4j.MondrianOlap4jDriver
    location=jdbc:mondrian:Jdbc=jdbc:postgresql://localhost:5432/dw;Catalog=fact_sales.xml;JdbcDrivers=org.postgresql.Driver;
    username=postgres
    password=postgres
      3)在legacy-schema文件夹放入你定义的cube文件fact_sales.xml
      4)启动
    5.数据源删除
        如果不删除的话之前加载的数据会一直存在。删除saiku-server/data/saiku.mv.db和saiku.trace.db;saiku-server/repository/data目录下所有文件。
    6.数据源的另一种配置方式
        上面的数据源添加时以MondrianOlap4jDriver发布到saiku中,另一种方式是通过saiku访问httpServlet的方式,
    同样的在legay-datasources中新建文件fact_sales_remote,内容如下:
    type=OLAP
    name=xmla
    driver=org.olap4j.driver.xmla.XmlaOlap4jDriver
    location=jdbc:xmla:Server=http://localhost:8888/mondrian/xmla
    username=root
    password=123456
    然后重新启动
    看到这段启动信息说明发布成功。
    7.http://localhost:8080访问页面,数据中即可看到添加的cube信息。
     
    另:本人下载saiku版本为3.0.9.8,里面集成的mondrian版本是4.0.0-SNAPSHOT,但是这个版本不支持中文的cube,因此可以将mondrian版本适当降低,不影响功能使用。

    转载于:https://www.cnblogs.com/likanmama/p/4344155.html

    展开全文
  • 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 ...
  • saiku-saiku-3.6.zip

    2020-01-03 17:08:17
    saiku源码,Saiku是一个模块化分析套件,提供轻量级OLAP,易于嵌入,可扩展和可配置。Saiku RESTful服务器连接到现有的OLAP系统,通过我们基于轻量级JQuery的前端为用户友好,直观的分析提供支持。
  • <div><h3>Is this a bug report? <p>yes <h3>Environment <p>java version "10.0.1" 2018-04-17 Java(TM) SE Runtime Environment 18.3 (build 10.0.1+10) Java HotSpot(TM) 64-Bit...OSBI/saiku</p></div>
  • 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...
  • <div><p>Following build instructions, it is not possible to build saiku from sources. <pre><code> $ git log --pretty=oneline -1 709ca1267a12e2d8bb582f68668b96080e8d97d6 fix merge $ mvn clean ...
  • [INFO] Building Unnamed - org.saiku:saiku-server:pom:2.4-SNAPSHOT [INFO] task-segment: [clean, install] [INFO] ------------------------------------------------------------------------ [INFO] [clean:...
  • saiku源码,Saiku是一个模块化分析套件,提供轻量级OLAP,易于嵌入,可扩展和可配置。Saiku RESTful服务器连接到现有的OLAP系统,通过我们基于轻量级JQuery的前端为用户友好,直观的分析提供支持。
  • <div><p>Hi Paul / Saiku Team <p>Can you please explain how to handle a cube with dynamic schema processing capability through saiku. What I imply here is, let us consider a Mondrian schema which has a...
  • <p>Filter, Limit, Sort options are not working in Saiku plugin with Pentaho 5. For instance, if the user tries to do Limit by Top 10 "Sales Value" field, the result is same and the limit is ...
  • ve tried to get the same results in Saiku that I would have in Jpivot. Using Saiku Pentaho Plug-in I've generated the following MDX: <p>SELECT NON EMPTY Hierarchize(Union(CrossJoin({[Time].[All ...
  • <div><p>Chinese/Arabic character encoded strings present in a dimension table in vertica is not getting displayed in the saiku UI properly. \Before we had loaded the dimension table from the text file...
  • Saiku3.1构建过程(包含Saiku-UI)

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

    1、首先下载Saiku3.1的源码:https://github.com/OSBI/saiku/tree/release-3.1
    2、以maven项目方式导入到eclipse中(此步骤可以不做)
    3、修改下载的根目录中的pom文件,找到build节点-->pluginManagement节点-->plugins中添加如下代码
    <plugin>
         <groupId>org.apache.maven.plugins</groupId>
         <artifactId>maven-surefire-plugin</artifactId>
         <configuration>
          <skip>true</skip>
         </configuration>
    </plugin>
    这段代码主要是修改构建过程中跳过junit测试,此项可以不改,使用命令行模式:
    mvn clean install -DskipTest
    但是到这里大部分人还是会执行失败,接着修改
    4、处理失败的情况
    由于saiku-ui构建的时候会执行一个文件“minify.patch”,在saiku-ui的pom文件中找到这行代码,注释掉,然后,然后还是先别急着构建的,还是有问题的,继续修改
    之前我构建的时候,顺手把plugin给删了,所以没构建,今天构建plugin的时候,发现无论如何有几个文件报错

    于是我放弃了,毕竟我现在还用不到这个plugin
    在saiku目录下的pom文件中,将<module>saiku-bi-platform-plugin-p5</module>一行注释掉,构建就可以了

    5、项目构建
    如果你导入到eclipse中了,那么saiku项目右键-->Run As -->Maven install即可
    如果没有导入到eclipse中,那么使用脚本构建
    mvn clean install -DskipTest
    build成功后,会在saiku-server的target目录中出现如下一些文件


    重点在选中文件,打开

    文件都在,然后解压,启动即可

    转载请注明出处,也不枉我辛苦一番,谢谢


    展开全文
  • m using a WebService PDI step to refresh saiku at the end of my ETL process. I'm calling ...
  • http://99.999.99.99:8080/saiku/rest/saiku/anonymousUser/query/4FF7D01E-8A6B-5EB4-991B-C0CE680A4BCA/result/flat 这里,需要注意:4FF7D01E-8A6B-5EB4-991B-C0CE680A4BCA是交互的id, 登陆sai

    提交mdx语句,执行后, 查询结果的获得,访问这个地址:

    http://99.999.99.99:8080/saiku/rest/saiku/anonymousUser/query/4FF7D01E-8A6B-5EB4-991B-C0CE680A4BCA/result/flat

    这里,需要注意:4FF7D01E-8A6B-5EB4-991B-C0CE680A4BCA是交互的id,

    登陆saiku,必须用某个用户身份进去,默认有admin和两个开发人员的身份。每个用户对应唯一的一个身份id,登陆后,用唯一的身份id,进行验证。

    而交互id,是在选择cube后,saiku服务器随机生成的一个id字符串,用于交互时,保证唯一性。用浏览器跟踪,发现生成过程就是选中一个cube后。

    如果再选另一个cube,重新提交了一个申请,saiku会自动先删除原先的id。然后新建一个id串,作为一个新查询。

    手动建立一个页面,与saiku交互,就需要先抓包,调查清楚,几个访问地址,和这个生成的访问id,然后,并结成可访问的url,直接post请求就行了。

    一个post请求的基本配置信息为:

    window.q1 = new Query({connection:'aso_test_edition',catalog:'aso_sever_schema',schema:'aso_sever_schema',cube:'aso',formatter:'flat',type:'QM'}); 

     

    然后q1.save(),直接会去生成id,然后拼接url。

    再次提交,会自动删除原有id。建立新id。

     

     

    展开全文
  • When I run the same query on Saiku 2.5 and 2.4 with non empty function, i don't have the same result. It's seem like a part of the result are missing in the 2.5 version. <p>I don't know ...
  • saiku 网站简介

    千次阅读 2014-02-13 18:22:28
    Saiku web:...Click “saiku”,the simple illustration will help you use saiku quickly.   Others is providing services of de
  • pentaho,Kylin, Mondrian, Saiku之间到底是什么样的关系?感觉开源的东西名字好乱。 百度查到: pentaho是一个BI平台,集成了 ◆ ETL工具:Enhydra/Kettle也可以其他 ◆ OLAP Server:Mondrian也可以其他 ◆ OLAP...
  • </li><li>Browser and version (if relevant):Firefox 63.0.1 (64 bits)</li><li>Saiku plugin to Pentaho or Saiku Standalone: Saiku Standalone</li><li>Saiku CE or Saiku EE:Saiku EE</li><li>Saiku version: ...
  • .</li><li>Copy resulting saiku-server/target/saiku-server-foodmart-3.16.zip to (a) a fresh openjdk:8 docker container, or (b) my local MacOS desktop</li><li><code>start-saiku.sh</code></li><li>Point ...
  • 很多人说没有办法编译saiku3.0以上的版本,我之前编译2.6是可以的,最近接触到3.1,编译了一下,于是将编译过程写下,方便大家参考
  • <p>Am currently using Saiku on top of Pentaho. I have some saved reports through Saiku. Now if i want to schedule and distribute it to certain distribution list on some frequency basis (daily / weekly...
  • saiku的安装教程

    万次阅读 热门讨论 2013-12-16 20:02:06
    Saiku是一个模块化的开源分析套件,它提供轻量级的OLAP(联机分析处理),并且可嵌入、可扩展、可配置。 环境准备 1、JDK5及以上版本。 2、Saiku Server,当前最新版本为2.4,下载地址:...
  • I am using Saiku 2.3 and Pentaho CE BI server 4.5 on a custom deployed tomcat 6.0 servlet container on a REHL 5 64bit linux. Whenever I try to render a report with IE9 I get a "Could not render ...
  • saiku安装部署资源

    2018-03-16 16:14:42
    Saiku_学习_01_在Tomcat下部署saiku(http://www.cnblogs.com/shirui/p/8573491.html),博客中需要用的资源
  • t work in Saiku. Default measure is always the one that appears first in the schema file. <p>Setting CalculatedMember element to appear before all of the measures doesn't help: actually in this ...

空空如也

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

Saiku