EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

How to use Logical Views to specify an outer join between two attribute lookup tables when only attributes are on a report?


Tristan Geyster

Principal Product Specialist • Strategy


This tutorial shows the steps to create a logical view to perform an outer join between two lookup tables for use on attribute only reports

This document describes how to use the Logical View feature introduced in Strategy to specify an outer join between two attribute lookup tables when only attributes are on a report. Brief instructions are provided using the example below.
Two attributes: Parent01 and Child01 have a parent-child relationship. Their Lookup tables are defined, as follows


ProductStrategy Support CaseStrategy Internal CaseDescriptionMSTR-Architect640718780904Desktop 9.3.1 hangs when attempting to add child relationship or when attempting to delete attribute objectMSTR-COM631966770926Delete Table using the Command Manager delete the table, but returns with an errorMSTR-COM637955775868In 9.3.1 view filter report is not hitting cache of base reportMSTR-COM640639781228Importing an OM package into a project yields a non-responsive/hung Object Manager 9.3.1MSTR-Desktop642553783783Unable to see header when adding attributes to an RS documentMSTR-Desktop642962783783Unable to see header when adding attributes to an RS documentMSTR-Engine621695777257Document order altered after migration from 9.0.1 to 9.3.1MSTR-Enterprise Manager (Admin)613863775011The project configuration parameters are getting updated even when there is no changeMSTR-Flash Dashboards640367776339Change of Microchart-Widget in 9.3.1: zero, line and red bar appears in bullet-graph for max value/column in totals for derived metric when the third and fouth columns are both 0.MSTR-Flash DashboardsNo Support Case772103Filter panel in Flash mode - Apply button and buttons in drop down menu do not working in a certain conditionMSTR-Flash DashboardsNo Support Case772112Metric Selector (checkbox) - Moving a metric to the left or right via the context menu doesn't work when having a metric checkbox selector targeting a grid in Flash mode in Web.MSTR-Flash DashboardsNo Support Case776337Unexpected zero label and vertical line in bullet graph when the value of the third metric is zero.MSTR-Flash DashboardsNo Support Case777175Total Selector for Microchart Widgets only returning last element in rows.MSTR-Flash DashboardsNo Support Case777178With auto-apply changes disabled for a filter panel, the last selector on filter panel cannot be accessed in Flash View ModeMSTR-Flash DashboardsNo Support Case777179Links disappear on a dashboard in Flash modeMSTR-Flash DashboardsNo Support Case777180Search box will always resize to 48pixel if it is executed in flash mode collapsed.MSTR-InstallationNo Support Case782656Error occurs while creating report in web.MSTR-InstallationNo Support Case782662An error occurs while opening any folder from Shared Reports.MSTR-InstallationNo Support Case782675Unable to Install 931 Hotfix 3 build on UnixMSTR-InstallationNo Support Case782951Incorrect Build version displayed during installation as well as in License Manager.MSTR-InstallationNo Support Case784086M8Forma3.dll file couldn't be updated on 9.3.1HF3 installation.MSTR-Intelligence Server591005670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server627781670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server629041670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server636094773281Export to excel with formatting for a large report from web with preference set to "Excel 2007 and newer" fails with errorMSTR-Intelligence Server637020780121Report is re-prompt and re-run when save / save as it.MSTR-Intelligence Server638244670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server638670670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server639607670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server640007777265Yen Mark(\) is displayed as # in 9.3.1MSTR-Intelligence ServerNo Support Case773044Unknown Mobile action terminates the intelligence-serverMSTR-Intelligence ServerNo Support Case773286No data returned for a metric from a cubeMSTR-Intelligence ServerNo Support Case773287Some negative values are displayed in red but without the minus signMSTR-Intelligence ServerNo Support Case773288In 9.3, the font size for totals changes for certain values is too smallMSTR-Intelligence ServerNo Support Case773294Core file from DEVMSTR-Intelligence ServerNo Support Case773296Faulting application name: MSTRSvr2_64.exeMSTR-Intelligence ServerNo Support Case778738Exponential Regression in trendline shows wrong coefficient valueMSTR-Intelligence ServerNo Support Case781685Deleting current selected element of panel selectors lead to blank display in Flash modeMSTR-Intelligence ServerNo Support Case784396Sort is missing and failed to reset on metric after some manipulationsMSTR-Intelligence ServerNo Support Case782119upgraded to 9.3.1, now i-server is crashing in PRODMSTR-Intelligence ServerNo Support Case784015Win64 9.3.2 | Win64 -Release -9.4.0000.0053 -- I-server hit breakpoint at shsmp64.DLL!_shi_allocBlock() Line2484MSTR-Intelligence ServerNo Support Case784024Win64 9.3.1 | Win64 -Release- 9.3.153.056 I-server hit breakpoint in MJSvr_64.DLL!MsiWorkingSet::GetInBoxMsgResult, Line 3696 + 0x4a bytes C++MSTR-Narrowcast Server642477734252NCS flash PPE will deliver all pages instead of only the one user selectMSTR-Server Administration630049761988Users are granted the hidden "Use Object Manager Import - Only" privileges as part of 'Power User' security role.MSTR-Server Administration636715761988Users are granted the hidden "Use Object Manager Import - Only" privileges as part of 'Power User' security role.MSTR-Server Administration637872761988Users are granted the hidden "Use Object Manager Import - Only" privileges as part of 'Power User' security role.MSTR-Server AdministrationNo Support Case784918JavaScript error occurs on a page while creating a new group and editing existing group in user manager.MSTR-Web633093776999Internet Explorer 9 Compatibility mode cuts the top of the page off.MSTR-Web636800777523Object Reprompt loses page-by for a report saved as prompted in WebMSTR-Web638156773303Lipstick graph not showing data value label for negative valuesMSTR-Web639779774891ER: Ability to display the horizontal scroll bar in the prompt's 'Browse values' in 9.3.1MSTR-WebNo Support Case772833XML strings should never be passed under the querystring as the SiteMinder Web agent will reject any URL containing %3C and %3EMSTR-WebNo Support Case772834Strategy Portal generated POST value in "rwb" that contains possible XSS bootstrap signatureMSTR-WebNo Support Case773275'Unable to set value of the property 'checked': object is null or undefined' JavaScript error is thrown when doing a search and having default home page set to 'Summary' in Web.MSTR-WebNo Support Case773300Microcharts column widths are changing when switching between panelsMSTR-WebNo Support Case777366Unable to do multiple selections in report filter definition using Chrome or Safari in Web 9.3.1.MSTR-WebNo Support Case780164Refit the Content option in google map widget does not workMSTR-WebNo Support Case780165Map opening in grid mode and not widgetMSTR-WebNo Support Case780400Cross-site scripting (XSS) vulnerability: script at end of document ID in URL API executionMSTR-WebNo Support Case780805When the user is saved through the web server admin, the setting for "User cannot use standard authentication" is cleared.ProductStrategy Support CaseStrategy Internal CaseDescriptionMSTR-COM621501761598Update schema error after importing a multisource report with Objecty ManagerMSTR-COM623502755170Unable to edit reports or documents with embedded metrics in MircroStrategy 9.3.1MSTR-COM624056755167(Republic National Distributing Company) - I server crashing when reports or documents with embedded metrics in Strategy 9.3.1MSTR-COM627305751259I-Server related project configurations (Governing Rules > Default > Result sets) are not carried over after duplicating project within a 3-tier project source in 9.3.1. (the settings can be remained in 9.3.0 and 9.2.x)MSTR-COM631475762362Metadata Inconsistency after upgrading from 9.0.2 to 9.3.1MSTR-Command Manager (Admin)626745750780Command Manager script issue for granting privileges to a Security Role outlines WEBEXECUTEANALYSIS and MOBILESAVEANALYSISMSTR-Command Manager (Admin)629179750780Command Manager script issue for granting privileges to a Security Role outlines WEBEXECUTEANALYSIS and MOBILESAVEANALYSISMSTR-Desktop530210764594Unable to edit drillmap receives the error "Element not found'MSTR-Desktop536402764594Unable to edit drillmap receives the error "Element not found'MSTR-Desktop628307764594Unable to edit drillmap receives the error "Element not found'MSTR-Desktop632843769750Adding new translation to Metric Alias fields results in empty field when re-opening translation in DesktopMSTR-Engine620536768505Metric Value different when generated from cube versus grid reportMSTR-Engine621373761876MSTR902  I-server crashes - a single report executionMSTR-Engine632260766494Object with ID '000007FFEC34A43C000007FF00B5FB80' and type 15 (Table) is not found in metadata error occurs on viewing report SQLMSTR-Engine633146766494Object with ID '000007FFEC34A43C000007FF00B5FB80' and type 15 (Table) is not found in metadata error occurs on viewing report SQLMSTR-Engine636258768459I-Server crash caused by iPad documentMSTR-EngineNo Support Case763965We are experiencing the known issue for blank results on reports returning less than 0.01% of cube volume .MSTR-Flash Dashboards614201764285Graph issue - missing maximum grid lineMSTR-Flash Dashboards620997765677Graph font size changes even with Absolute Font and line resizing in a dashboard in Strategy 9.2.1 Hotfix 11MSTR-Flash Dashboards628178762744Incorrect deletion of visualizations in VI 9.3.1MSTR-Flash Dashboards628657762746Flash error when trying to delete source or target of visualization selectorMSTR-Flash Dashboards628659751776Duplicate function causes Task errorsMSTR-Flash DashboardsNo Support Case768226A blank page is displayed on creating an analysis with any visualization.MSTR-Flash DashboardsNo Support Case769095Line chart showing wrong data because deleting source visualization is not deleting the selector in the backendMSTR-InstallationNo Support Case749052If the parent folder of installer contain parenthesis intCheck.jar cannot launch.MSTR-InstallationNo Support Case767358Prompting for upgrade the Strategy Office From 9.3.1 GA (9.3.158.056) to 9.3.1 HF2 (9.3.320.009) even there is no Office Folder available at Source locationMSTR-InstallationNo Support Case767392Welcome page doesn't show the right version. It shows 9.3.1 Hotfix1MSTR-Intelligence Server598918764587UserGroup Mapping and Integrated Authentication (Integrated Authentication in Desktop is working but without importing LDAP Groups.)MSTR-Intelligence Server624953761373Unexpected shutdown of (Intranet Production IServer cluster 9.3.0 HF2) on 2013-05-02MSTR-Intelligence Server631084763986Whenever a Web Reporter user tries to run a document defaulted to be exported to PDF user receives ACL prilvige error related to create dashboard. User can run document and export to PDF. Why does this privilege control direct export on documents?MSTR-Intelligence Server631556765596Unable to invoke a PS set up as info window from a x-tab set up as UC on Dataset selectorMSTR-Intelligence Server634435757035Trigger Event is broken since we installed 9.3 HF2.MSTR-Intelligence Server638687763986Whenever a Web Reporter user tries to run a document defaulted to be exported to PDF user receives ACL prilvige error related to create dashboard. User can run document and export to PDF. Why does this privilege control direct export on documents?MSTR-Intelligence ServerNo Support Case748742LNX OLAP Server crashed while cancelling an IR report.MSTR-Intelligence ServerNo Support Case765150MSTR902 - Iserver crash for UATMSTR-Intelligence ServerNo Support Case765591Get Service Status Remote Machine does not workMSTR-Intelligence ServerNo Support Case767239I-server is not getting started after installing HF2 on 9.3.1 GA buildMSTR-Intelligence ServerNo Support Case767390Error occurred while configure I-Server to any MD.MSTR-ToolsNo Support Case767415Not able to launch License manager from Start menu.MSTR-ToolsNo Support Case770635Inconsistent behavior observed with Status of build in license manager in Solaris as compared to windows 2008.MSTR-Web623778755259Exported file cannot open when exporting to Excel with Plain text using Excel 2007 or newer version in IIS.MSTR-Web625659745640User cannot use standard authentication check box is disable when writing LDAP Login string from the webMSTR-Web630754755341Would like to get Strategy certification for Chrome version 27.MSTR-Web631541768091Express Mode: Hyperlink not updating in information window / selector status not forwarded with prevMsgIDMSTR-Web633561761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web633968761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web634936761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web636317766302Defect: Left-most axis label disappears on Budgeting - Vertical Lipstick graph when graph height is reduced in a documentMSTR-Web636600767024921mGA - ASPx Specific - Browser window becomes blank or empty when clicking the star burst button in History List after the user session has expired on the I-Server.MSTR-Web636686761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web636728761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web636893755259Exported file cannot open when exporting to Excel with Plain text using Excel 2007 or newer version in IIS.MSTR-Web636950761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-WebNo Support Case746925Invalid argument error message thrown and the whole webpage goes blank on performing 2nd time slicing of a dataset which is removed and then brought backMSTR-WebNo Support Case761390MSTR Office - File - New - Create Report "DANCING" Screen is seen in WebMSTR-Web APINo Support Case753267Command Manager can't import package in read-only mode.ProductStrategy Support CaseStrategy Internal CaseDescription    MSTR-Architect582972651745WH Catalog issues after renaming a WH Table via Architect as per TN39859: How to update warehouse table name in Strategy Architect 9.2.1MSTR-ArchitectNo Support Case747751Getting "Automation error" while updating schema and opening Architect wizard.MSTR-COM610163743373Transaction Services not working after the transport with Object ManagerMSTR-COMNo Support Case730318Error occurs in object prompt window after trying to select a different incremental fetch page when running a report in Web 9.3.0MSTR-COMNo Support Case732979Receiving error "Report 'XXX' can not be executed with its current structure. A report should not be defined in terms of itself" when creating a view filter after upgrading to 9.3.0 HF 2MSTR-COMNo Support Case742933Win64 9.3.1 | Win64 -Release- 9.3.155.056 I-server hit breakpoint in MHOBJSRV_64.DLL!CDSSSQLJoinTreeNode::hGetTables() Line 67 + 0x16 bytes C++MSTR-COMNo Support Case746331IServer hit an assertion in MHOBJSRV_64.dll!CDSSTemplateSubtotal::GetUnitsItemKeyMSTR-Desktop585079743256Metric definition: smart-function is always automatically activated if the metric-formula is changedMSTR-DesktopNo Support Case745342Error occurs while login to MSTR Desktop.MSTR-DesktopNo Support Case747759Derived metrics created in a report in Desktop are set as non-smart.MSTR-Engine615893744557Why is an Invalid Column Mapping Info SOAP" error thrown when running an MDX report in MSTR 9.3.0 while the MDX runs successfully directly in the cube?"MSTR-Engine625540754151Unable to execute a Multisource report if the report has on its template more than 2 MDX metrics from the same SAP Query/DSSTable with SAP VariablesMSTR-EngineNo Support Case731213performance on Analytical Engine when calculating non-aggregate metrics over i-cubesMSTR-EngineNo Support Case740294Not re-execute SQL when delete one DE element and check another DE element.MSTR-EngineNo Support Case750276Metric Format changes automatically in 921m 3-tier.MSTR-Flash Dashboards619803742088create derived metrics using IF and Case functions from Derived Metric Freeform DialogMSTR-Flash DashboardsNo Support Case743626The row height is smaller than others if its bullet value is negative.MSTR-Flash DashboardsNo Support Case746338Change visualization between normal graph types (not graph matrix) does not workMSTR-InstallationNo Support Case745290Error Could not load file or assembly 'MLJAPPCT' or one of its dependencies when open webserverMSTR-InstallationNo Support Case748687After uninstalling the Hotfix from 9.3.1 GA build Desktop and Web do not work.MSTR-InstallationNo Support Case752339Incorrect Web/Mobile server version displayed after applying 931 HF1MSTR-Intelligence Server626449746902Enhancement Request: Certify MSTR Platform on OS Red Hat 6.4MSTR-Intelligence ServerNo Support Case718382MemTest 9.3.1 | Win32 -Debug -9.3.134.056 - Object LeakMSTR-Intelligence ServerNo Support Case734588WIN64 9.3.1 | WIN64 - DEBUG - 9.3.151.056 - Memory LeakMSTR-Intelligence ServerNo Support Case740919If the parent folder of installer contain parenthesis the installer cannot launch.MSTR-Intelligence ServerNo Support Case742455IServer crashes when ?delete HL message? schedule admin task is running while a mobile user logs out of its sessionMSTR-Intelligence ServerNo Support Case745693931 (Mobile Prod WER dump) (iPad-3120)MSTR-Intelligence ServerNo Support Case746348Solaris server crash while opening mobile App with pre caching enabledMSTR-MobileNo Support Case740530change the logic of or remove entirely the mobile version check on the server sideMSTR-Object Manager (Admin)619616744531Multisource reports that contain MDX objects are not migrated correctly through Object ManagerMSTR-SDK620771750709Extended Property Editor doesn't work with version 9.3.0 an error occurs: Unexpected error. Error is: 0x80042457. Description: The definition of object with type "Property Set" (ID : 64C03A70419A216CBMSTR-Server Administration615779746125Use command line to launch repositoru translation wizard (using xml)MSTR-System ManagerNo Support Case740496System Manager can't send email without specifying an outgoing SMTP server.MSTR-ToolsNo Support Case731126MSTR 9.3.0 Unable to configure iserver Configuration Wizard keeps crashing.MSTR-Web595187679392MSTR 9.3 Web - Distribution Service Send Now From Folder Browsing Only Shows the 'expand page by' check box.MSTR-Web614760679392MSTR 9.3 Web - Distribution Service Send Now From Folder Browsing Only Shows the 'expand page by' check box.MSTR-Web617821738907The processing animation or aka wait (or busy) icon is not displayed when running a Document or Report in IE9 with HTTPS in an iFrame in version 9.3 it just appears and then disappears before the applicable page loads.MSTR-Web620417744482bootstrap sequence failedMSTR-Web623532679392MSTR 9.3 Web - Distribution Service Send Now From Folder Browsing Only Shows the 'expand page by' check box.MSTR-Web630557755340Would like to get Strategy certification for Firefox version 21.MSTR-WebNo Support Case730761Marketing Programs - Intro Workshop Exercise. ?The Length of the unitkeyContext is different from that of the elemList?MSTR-WebNo Support Case733611Unable to click export icons in flash mode due to positioning of the icons on the grid.MSTR-WebNo Support Case735529In 9.3.1 we bring back by default all DB instances instead of only the ones marked as ?available data mart QB FF and non-primary WH DB instances? for that projectMSTR-WebNo Support Case737888: No indication that another page is loading when using Edit Links between dashboardsMSTR-WebNo Support Case745388Processing icon is not visible clearly.MSTR-WebNo Support Case745666Can not reuse the catalog cache in web when click the same DB instance multiple timesMSTR-WebNo Support Case748815Reprompt button does not function after maximum row limit error or cross join error.MSTR-Web Services617059731587'com/MicroStrategy/web/tasks/TaskInternalException' error connecting with trusted authentication from Office with J2EE MWSMSTR-Web ServicesNo Support Case747818dashboardviewer.swf deployed with Web Services needs network privileges removedMicrosStrategy 9.4.1Strategy 10.xStatistics logging optionStatistics loggedTables v9.x*Tables v10.xAll basic statisticsUser session and project session analysis. This option must be selected for any statistics to be logged.• IS_SESSION_STATS (server session statistics)
• IS_PROJ_SESS_STATS (project session statistics)
• IS_REPORT_STATS (report execution statistics)
• IS_DOCUMENT_STATS (document execution statistics)
• IS_CACHE_HIT_STATS (report cache hit statistics)
• IS_REP_SEC_STATS (statistics on report jobs executed with security filter)
• IS_REP_MANIP_STATS (manipulation statistics related to user actions after a report has been executed)
• IS_PERF_MON_STATS (statistics related to notification, diagnostics, and performance counters logged by Intelligence Server)
• IS_SCHEDULE_STATS (statistics on jobs executed from the scheduler)
• IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in Strategy 9.2.1 and later)
• MSI_STATS_LOG (not used in Strategy version 9.x)
• MSI_STATS_PROP (properties table that Strategy Intelligence Server uses to initialize statistics logging)• IS_SESSION_STATS (server session statistics)
• IS_PROJ_SESS_STATS (project session statistics)
• IS_REPORT_STATS (report execution statistics)
• IS_DOCUMENT_STATS (document execution statistics)
• IS_CACHE_HIT_STATS (report cache hit statistics)
• IS_REP_SEC_STATS (statistics on report jobs executed with security filter)
• IS_REP_MANIP_STATS (manipulation statistics related to user actions after a report has been executed)
• IS_PERF_MON_STATS (statistics related to notification, diagnostics, and performance counters logged by Intelligence Server)
• IS_SCHEDULE_STATS (statistics on jobs executed from the scheduler)
• IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes)
• IS_INBOX_ACT_STATS
• IS_MESSAGE_STATS
• IS_PR_ANS_STATS
• MSI_STATS_LOG
• MSI_STATS_PROP
• IS_ALERT_STATS (statistics related to Health Center alerts)Report job stepsDetailed statistics on the processing of each report.IS_REP_STEP_STATSIS_REP_STEP_STATSDocument job stepsDetailed statistics on the processing of each document.IS_DOC_STEP_STATS IS_DOC_STEP_STATS Report job SQLThe generated SQL for all report jobs.IS_REP_SQL_STATSIS_REP_SQL_STATS *This option can create a very large statistics table. Select this option when you need the job SQL data.Report job tables/columns accessedData warehouse tables and columns accessed by each report.IS_REP_COL_STATSIS_REP_COL_STATSPrompt AnswersCollects information about prompts and prompt answers used during report execution.IS_PR_ANS_STATS (New table introduced in Strategy 9.0)Merged into Basic StatisticsSubscriptions deliveriesCollects information about deliveries scheduled through Distribution Services.IS_MESSAGE_STATS (New table introduced in Strategy 9.0) This table is to be used in conjunction with IS_SCHEDULE_STATS.Merged into Basic StatisticsInbox messagesLog data about Inbox messages.IS_INBOX_ACT_STATS (New table introduced in Strategy 9.0.1)Merged into Basic StatisticsMobile ClientsDetailed statistics on reports and documents that are executed on a mobile device.• CT_EXEC_STATS
• CT_DEVICE_STATS
(New tables introduced in Strategy 9.3.0)• CT_EXEC_STATS
• CT_DEVICE_STATSMobile Client LocationWhen the option 'Mobile Clients Location' is checked, and users allow the Strategy app to use the current location, logs location.CTLatitude' and 'CTLongitude' columns are populated in the CT_EXEC_STATS statistics table.CTLatitude' and 'CTLongitude' columns are populated in the CT_EXEC_STATS statistics table.Mobile Clients ManipulationsDetailed statistics on actions performed by end users on a mobile client.CT_MANIP_STATS (statistics related to manipulation of reports/documents in a mobile app. New table introduced in Strategy 9.3.1)Manipulations' column is populated in the CT_EXEC_STATS statistics table.  Parent01Child01


ProductStrategy Support CaseStrategy Internal CaseDescriptionMSTR-Architect640718780904Desktop 9.3.1 hangs when attempting to add child relationship or when attempting to delete attribute objectMSTR-COM631966770926Delete Table using the Command Manager delete the table, but returns with an errorMSTR-COM637955775868In 9.3.1 view filter report is not hitting cache of base reportMSTR-COM640639781228Importing an OM package into a project yields a non-responsive/hung Object Manager 9.3.1MSTR-Desktop642553783783Unable to see header when adding attributes to an RS documentMSTR-Desktop642962783783Unable to see header when adding attributes to an RS documentMSTR-Engine621695777257Document order altered after migration from 9.0.1 to 9.3.1MSTR-Enterprise Manager (Admin)613863775011The project configuration parameters are getting updated even when there is no changeMSTR-Flash Dashboards640367776339Change of Microchart-Widget in 9.3.1: zero, line and red bar appears in bullet-graph for max value/column in totals for derived metric when the third and fouth columns are both 0.MSTR-Flash DashboardsNo Support Case772103Filter panel in Flash mode - Apply button and buttons in drop down menu do not working in a certain conditionMSTR-Flash DashboardsNo Support Case772112Metric Selector (checkbox) - Moving a metric to the left or right via the context menu doesn't work when having a metric checkbox selector targeting a grid in Flash mode in Web.MSTR-Flash DashboardsNo Support Case776337Unexpected zero label and vertical line in bullet graph when the value of the third metric is zero.MSTR-Flash DashboardsNo Support Case777175Total Selector for Microchart Widgets only returning last element in rows.MSTR-Flash DashboardsNo Support Case777178With auto-apply changes disabled for a filter panel, the last selector on filter panel cannot be accessed in Flash View ModeMSTR-Flash DashboardsNo Support Case777179Links disappear on a dashboard in Flash modeMSTR-Flash DashboardsNo Support Case777180Search box will always resize to 48pixel if it is executed in flash mode collapsed.MSTR-InstallationNo Support Case782656Error occurs while creating report in web.MSTR-InstallationNo Support Case782662An error occurs while opening any folder from Shared Reports.MSTR-InstallationNo Support Case782675Unable to Install 931 Hotfix 3 build on UnixMSTR-InstallationNo Support Case782951Incorrect Build version displayed during installation as well as in License Manager.MSTR-InstallationNo Support Case784086M8Forma3.dll file couldn't be updated on 9.3.1HF3 installation.MSTR-Intelligence Server591005670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server627781670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server629041670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server636094773281Export to excel with formatting for a large report from web with preference set to "Excel 2007 and newer" fails with errorMSTR-Intelligence Server637020780121Report is re-prompt and re-run when save / save as it.MSTR-Intelligence Server638244670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server638670670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server639607670684Subfolder creation in 9.3 does not allow user to select project nameMSTR-Intelligence Server640007777265Yen Mark(\) is displayed as # in 9.3.1MSTR-Intelligence ServerNo Support Case773044Unknown Mobile action terminates the intelligence-serverMSTR-Intelligence ServerNo Support Case773286No data returned for a metric from a cubeMSTR-Intelligence ServerNo Support Case773287Some negative values are displayed in red but without the minus signMSTR-Intelligence ServerNo Support Case773288In 9.3, the font size for totals changes for certain values is too smallMSTR-Intelligence ServerNo Support Case773294Core file from DEVMSTR-Intelligence ServerNo Support Case773296Faulting application name: MSTRSvr2_64.exeMSTR-Intelligence ServerNo Support Case778738Exponential Regression in trendline shows wrong coefficient valueMSTR-Intelligence ServerNo Support Case781685Deleting current selected element of panel selectors lead to blank display in Flash modeMSTR-Intelligence ServerNo Support Case784396Sort is missing and failed to reset on metric after some manipulationsMSTR-Intelligence ServerNo Support Case782119upgraded to 9.3.1, now i-server is crashing in PRODMSTR-Intelligence ServerNo Support Case784015Win64 9.3.2 | Win64 -Release -9.4.0000.0053 -- I-server hit breakpoint at shsmp64.DLL!_shi_allocBlock() Line2484MSTR-Intelligence ServerNo Support Case784024Win64 9.3.1 | Win64 -Release- 9.3.153.056 I-server hit breakpoint in MJSvr_64.DLL!MsiWorkingSet::GetInBoxMsgResult, Line 3696 + 0x4a bytes C++MSTR-Narrowcast Server642477734252NCS flash PPE will deliver all pages instead of only the one user selectMSTR-Server Administration630049761988Users are granted the hidden "Use Object Manager Import - Only" privileges as part of 'Power User' security role.MSTR-Server Administration636715761988Users are granted the hidden "Use Object Manager Import - Only" privileges as part of 'Power User' security role.MSTR-Server Administration637872761988Users are granted the hidden "Use Object Manager Import - Only" privileges as part of 'Power User' security role.MSTR-Server AdministrationNo Support Case784918JavaScript error occurs on a page while creating a new group and editing existing group in user manager.MSTR-Web633093776999Internet Explorer 9 Compatibility mode cuts the top of the page off.MSTR-Web636800777523Object Reprompt loses page-by for a report saved as prompted in WebMSTR-Web638156773303Lipstick graph not showing data value label for negative valuesMSTR-Web639779774891ER: Ability to display the horizontal scroll bar in the prompt's 'Browse values' in 9.3.1MSTR-WebNo Support Case772833XML strings should never be passed under the querystring as the SiteMinder Web agent will reject any URL containing %3C and %3EMSTR-WebNo Support Case772834Strategy Portal generated POST value in "rwb" that contains possible XSS bootstrap signatureMSTR-WebNo Support Case773275'Unable to set value of the property 'checked': object is null or undefined' JavaScript error is thrown when doing a search and having default home page set to 'Summary' in Web.MSTR-WebNo Support Case773300Microcharts column widths are changing when switching between panelsMSTR-WebNo Support Case777366Unable to do multiple selections in report filter definition using Chrome or Safari in Web 9.3.1.MSTR-WebNo Support Case780164Refit the Content option in google map widget does not workMSTR-WebNo Support Case780165Map opening in grid mode and not widgetMSTR-WebNo Support Case780400Cross-site scripting (XSS) vulnerability: script at end of document ID in URL API executionMSTR-WebNo Support Case780805When the user is saved through the web server admin, the setting for "User cannot use standard authentication" is cleared.ProductStrategy Support CaseStrategy Internal CaseDescriptionMSTR-COM621501761598Update schema error after importing a multisource report with Objecty ManagerMSTR-COM623502755170Unable to edit reports or documents with embedded metrics in MircroStrategy 9.3.1MSTR-COM624056755167(Republic National Distributing Company) - I server crashing when reports or documents with embedded metrics in Strategy 9.3.1MSTR-COM627305751259I-Server related project configurations (Governing Rules > Default > Result sets) are not carried over after duplicating project within a 3-tier project source in 9.3.1. (the settings can be remained in 9.3.0 and 9.2.x)MSTR-COM631475762362Metadata Inconsistency after upgrading from 9.0.2 to 9.3.1MSTR-Command Manager (Admin)626745750780Command Manager script issue for granting privileges to a Security Role outlines WEBEXECUTEANALYSIS and MOBILESAVEANALYSISMSTR-Command Manager (Admin)629179750780Command Manager script issue for granting privileges to a Security Role outlines WEBEXECUTEANALYSIS and MOBILESAVEANALYSISMSTR-Desktop530210764594Unable to edit drillmap receives the error "Element not found'MSTR-Desktop536402764594Unable to edit drillmap receives the error "Element not found'MSTR-Desktop628307764594Unable to edit drillmap receives the error "Element not found'MSTR-Desktop632843769750Adding new translation to Metric Alias fields results in empty field when re-opening translation in DesktopMSTR-Engine620536768505Metric Value different when generated from cube versus grid reportMSTR-Engine621373761876MSTR902  I-server crashes - a single report executionMSTR-Engine632260766494Object with ID '000007FFEC34A43C000007FF00B5FB80' and type 15 (Table) is not found in metadata error occurs on viewing report SQLMSTR-Engine633146766494Object with ID '000007FFEC34A43C000007FF00B5FB80' and type 15 (Table) is not found in metadata error occurs on viewing report SQLMSTR-Engine636258768459I-Server crash caused by iPad documentMSTR-EngineNo Support Case763965We are experiencing the known issue for blank results on reports returning less than 0.01% of cube volume .MSTR-Flash Dashboards614201764285Graph issue - missing maximum grid lineMSTR-Flash Dashboards620997765677Graph font size changes even with Absolute Font and line resizing in a dashboard in Strategy 9.2.1 Hotfix 11MSTR-Flash Dashboards628178762744Incorrect deletion of visualizations in VI 9.3.1MSTR-Flash Dashboards628657762746Flash error when trying to delete source or target of visualization selectorMSTR-Flash Dashboards628659751776Duplicate function causes Task errorsMSTR-Flash DashboardsNo Support Case768226A blank page is displayed on creating an analysis with any visualization.MSTR-Flash DashboardsNo Support Case769095Line chart showing wrong data because deleting source visualization is not deleting the selector in the backendMSTR-InstallationNo Support Case749052If the parent folder of installer contain parenthesis intCheck.jar cannot launch.MSTR-InstallationNo Support Case767358Prompting for upgrade the Strategy Office From 9.3.1 GA (9.3.158.056) to 9.3.1 HF2 (9.3.320.009) even there is no Office Folder available at Source locationMSTR-InstallationNo Support Case767392Welcome page doesn't show the right version. It shows 9.3.1 Hotfix1MSTR-Intelligence Server598918764587UserGroup Mapping and Integrated Authentication (Integrated Authentication in Desktop is working but without importing LDAP Groups.)MSTR-Intelligence Server624953761373Unexpected shutdown of (Intranet Production IServer cluster 9.3.0 HF2) on 2013-05-02MSTR-Intelligence Server631084763986Whenever a Web Reporter user tries to run a document defaulted to be exported to PDF user receives ACL prilvige error related to create dashboard. User can run document and export to PDF. Why does this privilege control direct export on documents?MSTR-Intelligence Server631556765596Unable to invoke a PS set up as info window from a x-tab set up as UC on Dataset selectorMSTR-Intelligence Server634435757035Trigger Event is broken since we installed 9.3 HF2.MSTR-Intelligence Server638687763986Whenever a Web Reporter user tries to run a document defaulted to be exported to PDF user receives ACL prilvige error related to create dashboard. User can run document and export to PDF. Why does this privilege control direct export on documents?MSTR-Intelligence ServerNo Support Case748742LNX OLAP Server crashed while cancelling an IR report.MSTR-Intelligence ServerNo Support Case765150MSTR902 - Iserver crash for UATMSTR-Intelligence ServerNo Support Case765591Get Service Status Remote Machine does not workMSTR-Intelligence ServerNo Support Case767239I-server is not getting started after installing HF2 on 9.3.1 GA buildMSTR-Intelligence ServerNo Support Case767390Error occurred while configure I-Server to any MD.MSTR-ToolsNo Support Case767415Not able to launch License manager from Start menu.MSTR-ToolsNo Support Case770635Inconsistent behavior observed with Status of build in license manager in Solaris as compared to windows 2008.MSTR-Web623778755259Exported file cannot open when exporting to Excel with Plain text using Excel 2007 or newer version in IIS.MSTR-Web625659745640User cannot use standard authentication check box is disable when writing LDAP Login string from the webMSTR-Web630754755341Would like to get Strategy certification for Chrome version 27.MSTR-Web631541768091Express Mode: Hyperlink not updating in information window / selector status not forwarded with prevMsgIDMSTR-Web633561761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web633968761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web634936761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web636317766302Defect: Left-most axis label disappears on Budgeting - Vertical Lipstick graph when graph height is reduced in a documentMSTR-Web636600767024921mGA - ASPx Specific - Browser window becomes blank or empty when clicking the star burst button in History List after the user session has expired on the I-Server.MSTR-Web636686761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web636728761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-Web636893755259Exported file cannot open when exporting to Excel with Plain text using Excel 2007 or newer version in IIS.MSTR-Web636950761514Null error when attempting to import data from File in 931 HF1 Web UniversalMSTR-WebNo Support Case746925Invalid argument error message thrown and the whole webpage goes blank on performing 2nd time slicing of a dataset which is removed and then brought backMSTR-WebNo Support Case761390MSTR Office - File - New - Create Report "DANCING" Screen is seen in WebMSTR-Web APINo Support Case753267Command Manager can't import package in read-only mode.ProductStrategy Support CaseStrategy Internal CaseDescription    MSTR-Architect582972651745WH Catalog issues after renaming a WH Table via Architect as per TN39859: How to update warehouse table name in Strategy Architect 9.2.1MSTR-ArchitectNo Support Case747751Getting "Automation error" while updating schema and opening Architect wizard.MSTR-COM610163743373Transaction Services not working after the transport with Object ManagerMSTR-COMNo Support Case730318Error occurs in object prompt window after trying to select a different incremental fetch page when running a report in Web 9.3.0MSTR-COMNo Support Case732979Receiving error "Report 'XXX' can not be executed with its current structure. A report should not be defined in terms of itself" when creating a view filter after upgrading to 9.3.0 HF 2MSTR-COMNo Support Case742933Win64 9.3.1 | Win64 -Release- 9.3.155.056 I-server hit breakpoint in MHOBJSRV_64.DLL!CDSSSQLJoinTreeNode::hGetTables() Line 67 + 0x16 bytes C++MSTR-COMNo Support Case746331IServer hit an assertion in MHOBJSRV_64.dll!CDSSTemplateSubtotal::GetUnitsItemKeyMSTR-Desktop585079743256Metric definition: smart-function is always automatically activated if the metric-formula is changedMSTR-DesktopNo Support Case745342Error occurs while login to MSTR Desktop.MSTR-DesktopNo Support Case747759Derived metrics created in a report in Desktop are set as non-smart.MSTR-Engine615893744557Why is an Invalid Column Mapping Info SOAP" error thrown when running an MDX report in MSTR 9.3.0 while the MDX runs successfully directly in the cube?"MSTR-Engine625540754151Unable to execute a Multisource report if the report has on its template more than 2 MDX metrics from the same SAP Query/DSSTable with SAP VariablesMSTR-EngineNo Support Case731213performance on Analytical Engine when calculating non-aggregate metrics over i-cubesMSTR-EngineNo Support Case740294Not re-execute SQL when delete one DE element and check another DE element.MSTR-EngineNo Support Case750276Metric Format changes automatically in 921m 3-tier.MSTR-Flash Dashboards619803742088create derived metrics using IF and Case functions from Derived Metric Freeform DialogMSTR-Flash DashboardsNo Support Case743626The row height is smaller than others if its bullet value is negative.MSTR-Flash DashboardsNo Support Case746338Change visualization between normal graph types (not graph matrix) does not workMSTR-InstallationNo Support Case745290Error Could not load file or assembly 'MLJAPPCT' or one of its dependencies when open webserverMSTR-InstallationNo Support Case748687After uninstalling the Hotfix from 9.3.1 GA build Desktop and Web do not work.MSTR-InstallationNo Support Case752339Incorrect Web/Mobile server version displayed after applying 931 HF1MSTR-Intelligence Server626449746902Enhancement Request: Certify MSTR Platform on OS Red Hat 6.4MSTR-Intelligence ServerNo Support Case718382MemTest 9.3.1 | Win32 -Debug -9.3.134.056 - Object LeakMSTR-Intelligence ServerNo Support Case734588WIN64 9.3.1 | WIN64 - DEBUG - 9.3.151.056 - Memory LeakMSTR-Intelligence ServerNo Support Case740919If the parent folder of installer contain parenthesis the installer cannot launch.MSTR-Intelligence ServerNo Support Case742455IServer crashes when ?delete HL message? schedule admin task is running while a mobile user logs out of its sessionMSTR-Intelligence ServerNo Support Case745693931 (Mobile Prod WER dump) (iPad-3120)MSTR-Intelligence ServerNo Support Case746348Solaris server crash while opening mobile App with pre caching enabledMSTR-MobileNo Support Case740530change the logic of or remove entirely the mobile version check on the server sideMSTR-Object Manager (Admin)619616744531Multisource reports that contain MDX objects are not migrated correctly through Object ManagerMSTR-SDK620771750709Extended Property Editor doesn't work with version 9.3.0 an error occurs: Unexpected error. Error is: 0x80042457. Description: The definition of object with type "Property Set" (ID : 64C03A70419A216CBMSTR-Server Administration615779746125Use command line to launch repositoru translation wizard (using xml)MSTR-System ManagerNo Support Case740496System Manager can't send email without specifying an outgoing SMTP server.MSTR-ToolsNo Support Case731126MSTR 9.3.0 Unable to configure iserver Configuration Wizard keeps crashing.MSTR-Web595187679392MSTR 9.3 Web - Distribution Service Send Now From Folder Browsing Only Shows the 'expand page by' check box.MSTR-Web614760679392MSTR 9.3 Web - Distribution Service Send Now From Folder Browsing Only Shows the 'expand page by' check box.MSTR-Web617821738907The processing animation or aka wait (or busy) icon is not displayed when running a Document or Report in IE9 with HTTPS in an iFrame in version 9.3 it just appears and then disappears before the applicable page loads.MSTR-Web620417744482bootstrap sequence failedMSTR-Web623532679392MSTR 9.3 Web - Distribution Service Send Now From Folder Browsing Only Shows the 'expand page by' check box.MSTR-Web630557755340Would like to get Strategy certification for Firefox version 21.MSTR-WebNo Support Case730761Marketing Programs - Intro Workshop Exercise. ?The Length of the unitkeyContext is different from that of the elemList?MSTR-WebNo Support Case733611Unable to click export icons in flash mode due to positioning of the icons on the grid.MSTR-WebNo Support Case735529In 9.3.1 we bring back by default all DB instances instead of only the ones marked as ?available data mart QB FF and non-primary WH DB instances? for that projectMSTR-WebNo Support Case737888: No indication that another page is loading when using Edit Links between dashboardsMSTR-WebNo Support Case745388Processing icon is not visible clearly.MSTR-WebNo Support Case745666Can not reuse the catalog cache in web when click the same DB instance multiple timesMSTR-WebNo Support Case748815Reprompt button does not function after maximum row limit error or cross join error.MSTR-Web Services617059731587'com/MicroStrategy/web/tasks/TaskInternalException' error connecting with trusted authentication from Office with J2EE MWSMSTR-Web ServicesNo Support Case747818dashboardviewer.swf deployed with Web Services needs network privileges removedMicrosStrategy 9.4.1Strategy 10.xStatistics logging optionStatistics loggedTables v9.x*Tables v10.xAll basic statisticsUser session and project session analysis. This option must be selected for any statistics to be logged.• IS_SESSION_STATS (server session statistics)
• IS_PROJ_SESS_STATS (project session statistics)
• IS_REPORT_STATS (report execution statistics)
• IS_DOCUMENT_STATS (document execution statistics)
• IS_CACHE_HIT_STATS (report cache hit statistics)
• IS_REP_SEC_STATS (statistics on report jobs executed with security filter)
• IS_REP_MANIP_STATS (manipulation statistics related to user actions after a report has been executed)
• IS_PERF_MON_STATS (statistics related to notification, diagnostics, and performance counters logged by Intelligence Server)
• IS_SCHEDULE_STATS (statistics on jobs executed from the scheduler)
• IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in Strategy 9.2.1 and later)
• MSI_STATS_LOG (not used in Strategy version 9.x)
• MSI_STATS_PROP (properties table that Strategy Intelligence Server uses to initialize statistics logging)• IS_SESSION_STATS (server session statistics)
• IS_PROJ_SESS_STATS (project session statistics)
• IS_REPORT_STATS (report execution statistics)
• IS_DOCUMENT_STATS (document execution statistics)
• IS_CACHE_HIT_STATS (report cache hit statistics)
• IS_REP_SEC_STATS (statistics on report jobs executed with security filter)
• IS_REP_MANIP_STATS (manipulation statistics related to user actions after a report has been executed)
• IS_PERF_MON_STATS (statistics related to notification, diagnostics, and performance counters logged by Intelligence Server)
• IS_SCHEDULE_STATS (statistics on jobs executed from the scheduler)
• IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes)
• IS_INBOX_ACT_STATS
• IS_MESSAGE_STATS
• IS_PR_ANS_STATS
• MSI_STATS_LOG
• MSI_STATS_PROP
• IS_ALERT_STATS (statistics related to Health Center alerts)Report job stepsDetailed statistics on the processing of each report.IS_REP_STEP_STATSIS_REP_STEP_STATSDocument job stepsDetailed statistics on the processing of each document.IS_DOC_STEP_STATS IS_DOC_STEP_STATS Report job SQLThe generated SQL for all report jobs.IS_REP_SQL_STATSIS_REP_SQL_STATS *This option can create a very large statistics table. Select this option when you need the job SQL data.Report job tables/columns accessedData warehouse tables and columns accessed by each report.IS_REP_COL_STATSIS_REP_COL_STATSPrompt AnswersCollects information about prompts and prompt answers used during report execution.IS_PR_ANS_STATS (New table introduced in Strategy 9.0)Merged into Basic StatisticsSubscriptions deliveriesCollects information about deliveries scheduled through Distribution Services.IS_MESSAGE_STATS (New table introduced in Strategy 9.0) This table is to be used in conjunction with IS_SCHEDULE_STATS.Merged into Basic StatisticsInbox messagesLog data about Inbox messages.IS_INBOX_ACT_STATS (New table introduced in Strategy 9.0.1)Merged into Basic StatisticsMobile ClientsDetailed statistics on reports and documents that are executed on a mobile device.• CT_EXEC_STATS
• CT_DEVICE_STATS
(New tables introduced in Strategy 9.3.0)• CT_EXEC_STATS
• CT_DEVICE_STATSMobile Client LocationWhen the option 'Mobile Clients Location' is checked, and users allow the Strategy app to use the current location, logs location.CTLatitude' and 'CTLongitude' columns are populated in the CT_EXEC_STATS statistics table.CTLatitude' and 'CTLongitude' columns are populated in the CT_EXEC_STATS statistics table.Mobile Clients ManipulationsDetailed statistics on actions performed by end users on a mobile client.CT_MANIP_STATS (statistics related to manipulation of reports/documents in a mobile app. New table introduced in Strategy 9.3.1)Manipulations' column is populated in the CT_EXEC_STATS statistics table.  Parent01Child01

 

 
SQLData Returnedselect a12.parent01_ID parent01_ID,
a13.parent01_DESC parent01_DESC,
a12.child01_ID child01_ID,
a12.child01_ID child01_ID0
from child01 a12
join parent01 a13
on (a12.parent01_ID = a13.parent01_ID)

 
Note that although there are 4 ID values for the attribute Parent01, there is no defined relationship for the Parent01 element p4 (ID=4) in the Lookup table for attribute Child01. Placing both attributes on a report will result in the following SQL and data returned. Parent01's element p4 will not be returned. This is known as a ragged hierarchy and is not supported in Strategy.
 

 
SQLData Returnedselect a12.parent01_ID parent01_ID,
a13.parent01_DESC parent01_DESC,
a12.child01_ID child01_ID,
a12.child01_ID child01_ID0
from child01 a12
join parent01 a13
on (a12.parent01_ID = a13.parent01_ID)

 
SQLData Returnedselect a12.parent01_ID parent01_ID,
a13.parent01_DESC parent01_DESC,
a12.child01_ID child01_ID,
a12.child01_ID child01_ID0
from child01 a12
join parent01 a13
on (a12.parent01_ID = a13.parent01_ID)

 
SQLData Returnedselect a12.parent01_ID parent01_ID,
a13.parent01_DESC parent01_DESC,
a12.child01_ID child01_ID,
a12.child01_ID child01_ID0
from child01 a12
join parent01 a13
on (a12.parent01_ID = a13.parent01_ID)

 
SQLLogical View Definition

 
Using Strategy, create a Logical View with the following SQL. Note the Left Outer Join.
 

 
SQLLogical View Definition

 
SQLLogical View Definition

select a12.parent01_ID parent01_ID,
a12.parent01_DESC parent01_DESC,
a11.child01_ID child01_ID,
a11.child01_DESC child01_DESC
from parent01 a12
left outer join child01 a11
on (a11.parent01_ID = a12.parent01_ID)

 
Add Source TableAdd Relationship

 
Modify the attribute Child01 to include the new Logical View as a source table and redefine a relationship to attribute Parent01 using the new Logical View.
 

 
Add Source TableAdd Relationship

 
Add Source TableAdd Relationship

 

 
SQLData Returned


Executing the same report will now return all elements for Attribute Parent01.
 

 
SQLData Returned

 
SQLData Returned

select /* RRR01 */ a12.parent01_ID parent01_ID,
a12.child01_ID child01_ID
from (select a12.parent01_ID parent01_ID,
a12.parent01_DESC parent01_DESC,
a11.child01_ID child01_ID,
a11.child01_DESC child01_DESC
from parent01 a12
left outer join child01 a11
on (a11.parent01_ID = a12.parent01_ID)) a12

 

 


Comment

0 comments

Details

Knowledge Article

Published:

August 2, 2017

Last Updated:

August 2, 2017