Error Getting Drill Information Select
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM maxwellarnold I_am_the_dragon PCMag Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Dennis Stevenson Craig Borysowich DukeGanote Richard mircea_luca AbhaiTripathi Nikki Klein knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES Hewlett Packard Hitachi America, LTD Compuware Fiberlink Communications View All Topics View All Members View All Companies Toolbox for IT Topics Siebel Groups Ask a New Question Siebel Analytics For discussion on Siebel Analytics , please visit the Oracle BI group. More Siebel Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Dashboard prompt - Presentation variables DW Devl asked Jun 11, 2008 | Replies (1) Hi Gurus, I need some help understanding how the Dashboard Prompts, especially Dates with TimeStamps, Send the User Inputs to the Requests. For simplicity, I will try to explain this with a simple example Dashboard: Page1 : This is the page the user sees when he/she first logs in. ############################################## ############################################################ Select End Date: [Calendar]. The Default Date in the Calendar is the Max(Report_Date) From Fact_Table. ############################################## ############################################################ Sales By Week Current Week Gross Sales (Max[Report_Date] - 6) $100 (Max[Report_Date] - 5) $120 (Max[Report_Date] - 4) $140 (Max[Report_Date] - 3) $150 (Max[Report_Date] - 2) $160 (Max[Report_Date] - 1) $170 (Max[Report_Date]) $180 ############################################## ###################### When the user Selects a Specific Date from the Calendar and hits the [GO] Button, the above Sales By Day shoul
Tools Oracle Business Intelligence (OBIEE/Siebel Analytics) OBIEE - Aggregation rules in Logical SQL with the GROUP BY and BY clause OBIEE - Aggregation rules in Logical SQL with the GROUP BY and BY clause Table of Contents 1 - About 2 - Articles Related 3 - Aggregation with a Measure Column 3.1 - How OBIEE choose the level of aggregation for the nested aggregate ? 3.2 - Example in Answer 4 - Aggregation Level based on the Baseline Columns (GROUP BY) 4.1 - How OBIEE choose the level of aggregation ? 4.2 - Example in Answer 5 - Alternative Syntax : the BY clause 6 - Complex aggregation 7 - Grand-Totals 8 - Support http://siebel.ittoolbox.com/groups/technical-functional/siebel-analytics-l/dashboard-prompt-presentation-variables-2171095 8.1 - nQSError: 42020 - GROUP BY clause is inconsistent 8.2 - Error getting drill information 8.3 - Error in Totals 9 - Reference 1 - About This section outlines the rules that the BI Server follows with respect to whether or not a logical query contains a GROUP BY clause and, if a GROUP BY clause is specified, what results you should expect from the query. OBIEE permit to fired an aggregation on two http://gerardnico.com/wiki/dat/obiee/group_by type of measure : on baseline columns (where no aggregation rule is defined in the repository) on measure columns (where an aggregation rule is defined in the repository) In OBIEE 11g, its possible to isolate different columns from the GROUP BY/DISTINCT operations such as LOB datatype column by using the SPARSE/DENSE lookup operators. Aggregation should only be performed on measure columns, with the possible exception of the aggregation COUNT and Count Distinct. 2 - Articles Related OBIEE - Baseline columnOBIEE - Evaluate - Embedded DB FunctionsOBIEE - Logical SqlOBIEE - Nested aggregate measureOBIEE - Query CompilerOBIEE - How to produce and show a total section on **each line** (Running total)? 3 - Aggregation with a Measure Column 3.1 - How OBIEE choose the level of aggregation for the nested aggregate ? If you perform explicit aggregation (SUM, AVG, MIN, MAX, or COUNT) on a measure column through a SQL request, you are actually asking for an aggregate of an aggregate. For these nested aggregates, the BI Server calculates the aggregation based on the following rules: A request for a measure column without an aggregate function defined in a SQL statement is always grouped at the level of the non-aggregate columns (grain)in the SELECT list, regardless of whether the query specifies a GROUP BY clause. If there is no GROUP BY clause specified, the nested ag
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly https://community.oracle.com/thread/3959582 without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please https://scn.sap.com/thread/3233838 type your message and try again. More discussions in Business Intelligence Applications All PlacesBusiness IntelligenceBusiness Intelligence ApplicationsBusiness Intelligence Applications 5 Replies Latest reply error getting on Aug 10, 2016 6:42 PM by Christian Berg OBIEE 11G - Error encountered 2925291 Aug 8, 2016 11:37 PM Hi,I am trying to create an Agent for an existing report which runs fine in the Analytics, however if I schedule it as an agent I am facing error getting drill the below error and need some assistance please.Error getting drill information: SELECT "GL Account"."GL Account Number" saw_0, "GL Account"."GL Account Name" saw_1, "Time"."Fiscal Year" saw_2, "Facts - GL Balance"."Opening Amount" saw_3, "Facts - GL Balance"."Debit Amount" saw_4, "Facts - GL Balance"."Credit Amount" saw_5, "Facts - GL Balance"."Closing Amount" saw_6 FROM "Financials - GL Balance Sheet" WHERE "GL Account"."GL Account Number" = '523013'Error DetailsError Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65POdbc driver returned an error (SQLExecDirectW).State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27005] Unresolved column: "GL Account"."GL Account Number".Please have your System Administrator look at the log for more details on this error. (HY000)SQL Issued: {call NQSGetLevelDrillability('SELECT "GL Account"."GL Account Number" saw_0, "GL Account"."GL Account Name" saw_1, "Time"."Fiscal Year" saw_2, "Facts - GL Balance"."Opening Amount" saw_3, "Facts - GL Balance"."Debit Amount" sa
and SafetyAsset NetworkAsset Operations 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 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 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 M