Join Error Freehand Sql
Contents |
Analytics By Role By Industry By Function By Data source Embedded BI Analytical Apps App Integration Cloud Deployable Partner custom sql in business objects Overview Partner Directory Overview Awards and Recognition Contact Us Careers
Webi Custom Sql
Try It Free Demo Site Take a tour Login Try It Free
Free Hand Sql In Webi
This forum is now out of date, for our new forum Click Here PostgreSQL data source - Freehand SQL query view error Question Asked Hi all,I've
Business Objects Sql Query
succesfully succesfully set up a data source (PostgreSQL 9.4.5 on CentOS 7) for our Yellowfin 7 install (Windows 2012R2). When I try to create a view in the drag 'n drop editor, everything works. But, when I use the freehand SQL editor to create a view, which is what we intend to use, business objects sql commands I get the following error:SQL statement is invalid.The error message returned from the database was:Cannot change transaction read-only property in the middle of a transaction.This happens even when I copy the code generated by the drag 'n drop editor. This particular code runs fine in a separate SQL-client, so I guess both code and privileges are OK.When I examine the PostgreSQL logs on the data source, I saw that Yellowfin generates some additional statements besides the query:< 2015-12-01 11:22:04.917 CET >LOG: execute
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join business objects view sql Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo webi 4.1 free hand sql Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, how to use free hand sql in business objects It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, https://www.yellowfinbi.com/YFForum-PostgreSQL-data-source-Freehand-SQL-query-view-error-?thread=210727 coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects solutions Forum http://www.tek-tips.com/viewthread.cfm?qid=561871 at Tek-Tips HomeForumsProject and Data ManagementData Management Programming ToolsBusiness Objects solutions Forum BO @prompt problem - Free hand SQL thread393-561871 Forum Search FAQs Links MVPs BO @prompt problem - Free hand SQL BO @prompt problem - Free hand SQL hoolio (IS/IT--Management) (OP) 29 May 03 07:28 I have written a small SQL script that I want some users to use who have access to Business Objects 4.1.4.I am trying to run the script using the Business Objects Free Hand SQL function.The problem is when I insert my @prompts into the script I get an Oracle Error "ORA-00907: missing right parenthesis 07".I know the script is correct as when I take the prompts out the script works fine.I need for the users to be able to enter their own dates there the prompts are essential.The bits that go wrong are:to_date('@prompt('start date?',,,,)'||'@prompt('start time?',,,,)','DD-MON-YYYYHH24:MI')andto_date('@prompt('end date?',,,,)'||'@prompt('end time?',,,,)','DD-MON-YYYYHH24:MI')and TO_DATE(to_char(a.system_date_1,'DD-MON-YYYY')||a.system_time_1,'DD-MON-YYYYHH24:MI')Here is the full script:select a.call__t, a.action_no, a.employees__key, e.em
and SafetyAsset NetworkAsset Operations https://scn.sap.com/community/businessobjects-web-intelligence/blog/2014/09/29/freehand-sql-fhsql-is-coming-to-web-intelligence and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent business objects ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer free hand sql ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle Management