æµ
è°ä¸ä¸Cognoså¤ç大æ°æ®çæè·¯ï¼ä»
é对10.2.1以ä¸ççæ¬ï¼å¯¹äº10.2.1å½ä¸å¼å
¥çhadloopçåå¸å¼æ°æ®ä»åºçä¸åä»ç»ãæ们主è¦ä»ä¸ä¸ªä¸è¬ä¸ç项ç®å½ä¸ï¼ç¨ææ ·çæè·¯æ¥ä¼åæ们çæ¥è¯¢ã
æ们主è¦ä»3个æè·¯æ¥æè大æ°æ®çå¤ç
ä¸ãæ°æ®åºå±æ¬¡
ç°å¨ä¸»æµçCognos项ç®ï¼ä¸»è¦çå¼å模å¼è¿æ¯åºäºrolapçdmræ¥è¡¨å»ºæ¨¡ãå æ¤ï¼æ°æ®åºçä¼åå°±æ¾å¾ç±ä¸ºéè¦ã主è¦éè¿ä»¥ä¸å 个æ¹é¢ä¼åæ们çæ°æ®åºï¼
(1)维度idï¼ç»´åº¦å±æ¬¡idçå
³é®å缩å段建ç«ç´¢å¼å»ºç«ãç»´æ¤ã
(2)æ ¹æ®æ°æ®éç大å°ï¼ææ¶é´çè¿è¡ååºä¼åã
(3)é«éç¼å²è¡¨MQTç使ç¨
(4)表空é´ãç¼å²æ± 设置ç
(5)æ°æ®åºæ§è½ä¼å
äºãCognos Serverä¼å
Cognosä¼åå
æ¬å¯¹é
ç½®æ件çä¼åï¼é群çæ建ï¼æå¡åæ¥å¿çå¼å¯çåºäºcognos 软件å®è£
ï¼é
ç½®çä¼åï¼ä¸»è¦å
æ¬ä»¥ä¸å 个æ¹é¢ï¼
2.1 apache é
ç½®ä¼å
Timeoutï¼è¶
æ¶ï¼/MaxKeepAliveRequestsï¼æ大ç请æ±æ°ï¼/KeepAliveTimeoutï¼è¯·æ±è¶
æ¶ï¼çä¼åé
ç½®
2.2Cognosèªå¸¦tomcaté
ç½®è°ä¼
(1)å¯ä¿®æ¹TOMCATé
ç½®æ件CRN_ROOT\tomcat.\conf\server.xmlãå
¶åæ°éä¸å¨è¡ï¼
å¯ä»¥å¯¹maxProcessorsï¼æ大è¿ç¨æ°ï¼/AcceptCount(æ大è¿æ¥æ°) ConnectionTimeoutï¼è¿æ¥è¶
æ¶ï¼è¿è¡ä¿®æ¹
(2)æ件路å¾ï¼CRN_ROOT\tomcat.\conf\web.xml
å¯ä»¥å¯¹session-timeoutè¿è¡ä¿®æ¹.
2.3Cognos severé
ç½®æ件ä¼å
2.3.1 reportservice.xmlä¼å
æ件路å¾ï¼CRN_ROOT\ webapps\p2pd\WEB-INF\services\ reportservice.xml
注ï¼ä¿®æ¹æ件åï¼éå¯æå¡åé
ç½®çæã
å
æ¬ä»¥ä¸åæ° max_process(交äºæ¥è¡¨å¤çè¿ç¨æ°ï¼åcpuæå
³) inger_process(交äºæ¥è¡¨åå§åè¿ç¨æ°ï¼åcpuä¼å
³)
max_non_affine_connections_per_process(交äºæ¥è¡¨æå 线ç¨æ°) idle_process_check_interval_ms(空é²æ£æµæ¶é´)
queue_time_limit_ms(æ¥è¡¨æå¡éåæ¶é´éå¶) async_wait_timeout_ms(Dispatcher请æ±çå¾
åæ¥æ¶é´)
2.3.2 batchreportservice.xml
æ件路å¾ï¼CRN_ROOT\ webapps\p2pd\WEB-INF\services\ batchreportservice.xml
注ï¼ä¿®æ¹æ件åï¼éå¯æå¡åé
ç½®çæã
å
æ¬ä»¥ä¸åæ° max_process(æå¡æ¹éæ¥è¡¨å¤çæå è¿ç¨æ°) linger_process(æå¡æ¹éæ¥è¡¨å¤çåå§åè¿ç¨æ°)
max_non_affine_connections_per_process(æå¡æ¹éæ¥è¡¨å¤çæå 线ç¨æ°) idle_process_check_interval_ms(空é²è¿ç¨æ£æµæ¶é´é´é)
idle_process_max_idle_ticks(空é²è¿ç¨æ£æµæ è®°) queue_time_limit_ms(æ¹éæ¥è¡¨å¤çæéæ¶é´éå¶) async_wait_timeout_ms(Dispatcher请æ±çå¾
åæ¥æ¶é´)
2.3.3 CQEConfig.xml
主è¦æ¯ä¸æ°æ®åºåæ°è®¾ç½®ï¼æ件路å¾ï¼CRN_ROOT\configuration\ CQEConfig.xml.sample
注ï¼å°CQEConfig.xml.sampleæ件åä¿®æ¹ä¸ºCQEConfig.xmlåï¼éå¯æå¡åé
ç½®çæã
å¯ä»¥ä¿®æ¹ä»¥ä¸åæ°ï¼Timeout(åºç¨æ°æ®åºè¿æ¥è¶
æ¶è®¾ç½®) PoolSize(åºç¨æ°æ®åºè¿æ¥æ± æ大è¿æ¥æ°è®¾ç½®) queryReuse(æ¥è¯¢ç¼å²è®¾ç½®)
2013-07-08 0
å享
çæ¡å¯¹äººæ帮å©ï¼æåèä»·å¼1
æ¾å - Cognos讲å¸ãCognosç¬ç«é¡¾é®ãæ°æ®ä»åºæ¶æå¸ 2013-07-08 åç
2.3.4 ppds_cfg.xml
主è¦è¿è¡ç¼ååæ¥å¿åæ°è®¾ç½®ï¼æ件路å¾ï¼\cognos\c8\configuration\ ppds_cfg.xml
注ï¼éå¯æå¡åé
ç½®çæã
å¯ä»¥ä¿®æ¹ä»¥ä¸åæ°ï¼ReadCacheSize(å¯åå°ç¨æ·è®¿é®æ¶æå¡å¨çç£çIOãæé«è®¿é®é度ã) pcQueryLogFile(建议ç产ç¯å¢å
³é该æ¥å¿çè·è¸ªï¼ä¸è¬é»è®¤ä¹æ¯å
³éç¶æ)
2.4 Cognos content storeä¼å
2.4.1ä¼åå
容åºè¿æ¥æå¡
å
容åºæ好å¤é
为db2 oracleçæ°æ®åºï¼ä¸è¦ç¨èªå¸¦çderby.å 为项ç®ä¸çæ¥å¿ä¿¡æ¯ä¼é常å¤ï¼ä¸¥éå½±åå
容åºçæçã
Cognos Administrationï¼å¨ç³»ç»ä¸éæ©éæ©å¯¹åºçæå¡ï¼éæ©ContentManagerServiceçå±æ§ï¼è®¾ç½®ç¸åºçè¿æ¥åæ°ä¿¡æ¯ã
2.4.2æ¥å¿ä¼å
éå½å¼å¯å个cognosæå¡çæ¥å¿çº§å«ï¼è¶é«çº§ç级å«å¯¹åºæ´è¯¦ç»ï¼æ´æç¡®çæ¥å¿ï¼ä½ä¹ä¼å½±åæ´ä¸ªç³»ç»çæçã
è¿æ¯ä¸æåååï¼éè¦éå½è°æ´ãæ¥å¿çº§å«è®¾ç½®å¾è¶é«ï¼å°±è¶éä½ç³»ç»æ§è½ãé常æ
åµä¸ï¼æ¨å¯ä»¥å°çº§å«è®¾ç½®ä¸º
âæå°âæâåºæ¬âæ¥æ¶éé误ï¼æ设置为â请æ±âæ¥æ¶éé误åè¦åã
2.5æé«è®¿é®æ°æ®åºé度
Cognosåæ°æ®åºé´åæ°å¨cer\bin\cogdm.iniæ件ä¸,(æ ¹æ®çæ¬ä¸åæ¯å®è£
ç®å½çæ°åï¼æ ¹æ®è¿æ¥çæ°æ®åºä¸åï¼æ¯å¯¹åºæ°æ®åºå称çå
³é®å)
以oracleæ°æ®åºä¸ºä¾,åæ°å¨cogdmor.iniæ件ä¸ï¼æå¼è¿ä¸ªæ件æ¥æ¾å符串Fetch Number of Rows=å»æè¿è¡åé¢çåå·ï¼å°10æ¹æ2000ï¼
è¿æ ·è¿è¡å°±æäºFetch Number of Rows=2000ï¼è¡¨ç¤ºæ¯æ¯æ¬¡ä»æ°æ®åºå2000æ¡æ°æ®ãå
¶ä»æ°æ®åºåºæ¬ä¸é½æ类似çé
ç½®ãç¨ä»¥æé«ä»æ°æ®åºä¸æåæ°æ®çé度ã
2.6å 大ç¼å
cer\bin\Cer.ini(*æ ¹æ®çæ¬ä¸åæ¯å®è£
ç®å½çæ°å)ï¼
SortMemory=5120
ï¼è¿é SortMemory åä½æ¯ 2kbytesï¼5120代表 2k x 5120 = 10Mï¼ï¼æå·§ï¼ä¸è¬ SortMemory å空é²å
åçååä¹ä¸å°å
«åä¹ä¸å¤§å°ï¼
2.7ä¿®æ¹cognos configurationä¸çåæ°æ¥ä¼å
å¨cognos configurationä¸æå¾å¤åæ°å¯ä»¥ä¼åæ¥æé«æ´ä½è½¯ä»¶çè¿è¡æçï¼æ¯å¦å¢å å
åãå¢å æ¥è¯¢ç¼å
2.8åå¸å¼é¨ç½²
åå¸å¼é¨ç½²å¯ä»¥å¤§å¤§æåCognosæå¡å¨çè´è½½è½åï¼åæ¶å®¹éä¿æ¤åè½å¯ä»¥ä½¿æå¡å¨æ´ä¸ºç¨³å®çè¿è¡ï¼å¾å¥½çæ¯æ大ç¨æ·éç并å使ç¨ã
2013-07-08 0
çæ¡å¯¹äººæ帮å©ï¼æåèä»·å¼1
æ¾å - Cognos讲å¸ãCognosç¬ç«é¡¾é®ãæ°æ®ä»åºæ¶æå¸ 2013-07-08 åç
3.æ¥è¡¨è®¾è®¡ä¼å
Cognosæ¥è¡¨ä½ä¸ºä¸ä¸ªå·¥å
·ï¼å¨écube模å¼ä¸ï¼æç»æ们æ§è¡æ¥è¡¨æ¥è¯¢çæ¶åï¼æ们çæ¥è¡¨åéå°æ°æ®åºè¿è¡æ¥è¯¢çæ¬è´¨è¿æ¯sqlï¼æ以ï¼å¨æ们å¶ä½ä¸å¼ æ¥è¡¨çæ¶åï¼æ们è¦å°½å¯è½çå©ç¨fm,rså½ä¸çåè½ï¼ä¼åæ¥è¡¨æç»æ§è¡çæçSQLå®ç°æ´ä¸ªæ¥è¡¨çä¼åãèCUBE模å¼ä¸ï¼æ们æ´å¤è¦èèé
ç½®ãåæ¾åæ°æ®åºå¤§å°æé æçå½±åï¼ä¸é¢æä¼ç»ç»è¯´æ¥ã
2013-07-08 0
çæ¡å¯¹äººæ帮å©ï¼æåèä»·å¼1
æ¾å - Cognos讲å¸ãCognosç¬ç«é¡¾é®ãæ°æ®ä»åºæ¶æå¸ 2013-07-08 åç
3.1 FM建模ä¼å
3.1.1æåSQLå®å¶æ¥è¯¢ä¸»é¢
å³é®ç¹å»æ¥è¯¢ä¸»é¢çèå项Edit Definitionâ¦å¯ä»¥è¿å
¥SQLè¯å¥ç¼åæ¡ï¼è°æ´æ¥è¯¢ä¸»é¢çSQLè¯å¥ãé»è®¤æ
åµä¸ï¼è¿éçSQLè¯å¥ä¸ºCognos SQLç±»åãå¦æéè¦ç¼ååºç¨æ°æ®åºå¯ä»¥ç´æ¥è¿è¡çæ¬å°SQLéè¦å°è¿éçSQLç±»åè¿è¡è®¾ç½®ãç¹å»å³ä¸æ¹çOptionsæé®ï¼éæ©SQL Settingsæ ç¾é¡µï¼éæ©SQL Type为Nativeãè¿ä¸ªæ¶åï¼æ们æåSQLå°±é常注éè¿ä¸ªSQLçä¼åï¼å°½éé¿å
SELECT *,ç¨EXISTSæ¿ä»£IN,å¤ä½¿ç¨DECODEæ¥è¿è¡å¤æï¼æ¡ä»¶è¯å¥æ³¨æç¹ç常ç¨SQLä¼åçç¥ï¼ç¼å对åºçSQL.
3.1.2å°½é使ç¨ç¹å®æ°æ®çæ°æ®åºå½æ°
å¨èå项Actionsä¸éæ©Specify Package Function Listâ¦æå®æ¥è¡¨å®å¶ä¸å¯ä»¥ä½¿ç¨çæ°æ®åºå½æ°å表ãå°é¤åºç¨æ°æ®åºæå¤çå
¶ä»æ°æ®åºç±»åä»Selected function setsä¸éå°Available function setsä¸ï¼å°½é使ç¨ç¹å®æ°æ®åºçèªå¸¦å½æ°å¯ä»¥æé«æ¥è¯¢æçã
3.1.3表å
³è设å®
å¨å»ºç«è¡¨å
³èå°½éé¿å
使ç¨å¤å
³èå
³ç³»ï¼å
æ¬å·¦å¤å
³èãå³å¤å
³èãå
¨å¤å
³èï¼ãå¤å
³èç使ç¨ä¼ä½¿æ°æ®åºçæ¥è¯¢åå骤å¢ï¼ä»èå½±åå端æ¥è¡¨ççæãå¨æåç»æãéªè±åç»æçæ°æ®ä»åºæ¨¡åä¸ï¼å°½éæç
§ä¸å¯¹ä¸ãä¸å¯¹å¤çå
³èå
³ç³»è®¾å®ç»´è¡¨ä¸å®äºè¡¨ä¹é´çå
³èï¼Cognos Serverä¼ä¾ç
§è¿éçå
³èå
³ç³»èªå¨ä¼åæ交ç»æ°æ®åºçSQLè¯å¥ãå¦æå
³èå
³ç³»ä¸åºç°äºç¯ç¶è¿æ¥å
³ç³»ï¼å¯ä»¥éè¿å«å表ææ¯å¿«æ·é®çæ¹å¼è§£å³ç¯ç¶è¿æ¥é®é¢.
3.1.4Edit Governorsæ¥è¯¢æ§è½è®¾ç½®
å¨èå项Projectä¸éæ©Edit Governorsï¼å¯ä»¥è®¾ç½®æ¥è¯¢çæ¥è¯¢æ§è½
Report table limits 该å±æ§è®¾ç½®æ¥è¡¨ä¸è¿è¡SQLææ¶åçTABLEæ°é
Data retrieval limits 该å±æ§è®¾ç½®æ¥è¡¨ä¸è¿è¡SQLè¿åç»æçæ°é
Query execution time limits 该å±æ§è®¾ç½®æ¥è¡¨ä¸è¿è¡SQLçæ§è¡æ¶é´
Large text items limit 该å±æ§è®¾ç½®æ¥è¡¨ä¸è¿è¡SQLè¿å大æååçå符æ°ééå¶
2013-07-08 0
çæ¡å¯¹äººæ帮å©ï¼æåèä»·å¼1
æ¾å - Cognos讲å¸ãCognosç¬ç«é¡¾é®ãæ°æ®ä»åºæ¶æå¸ 2013-07-08 åç
3.2 RSæ¥è¡¨è°ä¼
3.2.1æ¥è¡¨å½æ°ç使ç¨
å¨æ¥è¡¨å½æ°ç使ç¨ä¸ï¼å°½å¯è½ä½¿ç¨åºç¨æ°æ®åºè½å¤è§£æçæ¬å°æ°æ®åºå½æ°ï¼å½æ°å表ä¸çéç¨å½æ°ï¼å¨å¤çæ¶ä¼å°å½æ°æ¾å¨æ¥è¡¨æå¡å¨è¿è¡è¿ç®ï¼ä»èå¢å¤§äºæ¥è¡¨æå¡å¨çæ§è½å¼éã
3.2.2 è§å¯æ¥è¯¢çSQL
æ们éæ©æ¥è¯¢é¡µé¢ï¼GENERATE SQL/MDXè§å¯è¿ä¸ªæ¥è¡¨çæçSQL并è¿è¡ä¸æä¼åï¼
3.3.33.2 RSæ¥è¡¨è°ä¼
3.2.1æ¥è¡¨å½æ°ç使ç¨
å¨æ¥è¡¨å½æ°ç使ç¨ä¸ï¼å°½å¯è½ä½¿ç¨åºç¨æ°æ®åºè½å¤è§£æçæ¬å°æ°æ®åºå½æ°ï¼å½æ°å表ä¸çéç¨å½æ°ï¼å¨å¤çæ¶ä¼å°å½æ°æ¾å¨æ¥è¡¨æå¡å¨è¿è¡è¿ç®ï¼ä»èå¢å¤§äºæ¥è¡¨æå¡å¨çæ§è½å¼éã
3.2.2 è§å¯æ¥è¯¢çSQL
æ们éæ©æ¥è¯¢é¡µé¢ï¼GENERATE SQL/MDXè§å¯è¿ä¸ªæ¥è¡¨çæçSQL并è¿è¡ä¸æä¼åï¼
3.3.3æ¥è¯¢å段ãæ¥è¯¢è¡¨é¡ºåºè°æ´
æ ¹æ®æ°æ®åºçä¼åçç¥ï¼å¯è½éè¦å°æ¥è¯¢å段ç顺åºè¿è¡è°æ´ï¼å¯ä»¥å¨Data Itemsçªå£ä¸è¿è¡è®¾ç½®ãæ¥è¯¢SQLè¯å¥ä¸ï¼Fromå
³é®ååé¢ç表顺åºæ¯æç
§selectå
³é®åååºç°çå段顺åºè¿è¡è®¾ç½®çãå¨ä¸ºè¡¨é¡ºåºè¿è¡è®¾ç½®æ¶ï¼å±æ§ä¸ºIdentifieræAttributeçå段æ¯å±æ§ä¸ºFactçå段å¨ä¸ºè¡¨æåºæ¶çä¼å
级è¦é«ï¼å³ï¼å
以IdentifierãAttributeå段çåºç°é¡ºåºä¸ºè¡¨è¿è¡æåºï¼å¦æ没æä¸è¿°ä¸¤ç±»å段ï¼æ以Factå段çåºç°é¡ºåºä¸ºè¡¨è¿è¡æåºã
3.3.4èååå设置è¿æ»¤æ¡ä»¶
å°è¿æ»¤æ¡ä»¶çApplicationå±æ§è®¾ç½®ä¸ºAfter aggregationæBefore aggregationå¯ä»¥è°æ´è¿æ»¤æ¡ä»¶å¨èååææ¯èååçæãAfter aggregationçæè¿æ»¤æ¡ä»¶çSQLè¯å¥ä½¿ç¨çæ¯å
³é®åhavingï¼èBefore aggregationçæè¿æ»¤æ¡ä»¶çSQLè¯å¥ä½¿ç¨çæ¯å
³é®åwhereã
3.3.5åæ¶æ¥è¡¨èªå¨åç»æé«æç»æ¥è¡¨æ¥è¯¢é度
å¦ææ¥è¡¨è¦å±ç°æç»æ°æ®ï¼ä¸æ³ä½¿ç¨ä»»ä½æ±æ»ï¼æ们å¯ä»¥å°æ¤æ¥è¡¨å¯¹åºçæ¥è¯¢ä¸å°èªå¨åç»å±æ§å®ä¹ä¸ºå¦ãä¿®æ¹å°æ¹ï¼å¯¹è±¡çå±æ§Auto Group & Summarizeå¯ä»¥è®¾ç½®å½åSQLè¯å¥çæ¥è¯¢ä¸æ¯å¦å å
¥distinctãsumãgroup byè¿æ ·çå
³é®åãé»è®¤æ
åµä¸ï¼è¯¥å±æ§è®¾ç½®ä¸ºYesï¼å¯ä»¥æ ¹æ®æ¥è¯¢æ
åµå
³ææ¤å¼å
³é¡¹ï¼åå°SQLè¯å¥çå¤æ度ã
3.3.6èªå¨æåºè®¾ç½®
å¨QueryçAuto-sortå±æ§ä¸å¯ä»¥ä¸ºæ¥è¯¢è®¾ç½®æ¯å¦èªå¨æåºãå¦æéæ©æ¯ï¼åä¼å¨çæçSQLè¯å¥ä¸èªå¨å å
¥Order Byå
³é®åï¼æåºå段å°èªå¨æ ¹æ®æ°æ®é¡¹çå±æ§è¿è¡è®¾ç½®ï¼å¦ææ¥è¯¢å段çusageå±æ§ä¸ºAttributeãIdentifieråæåºï¼å¦æ为Factåä¸æåºï¼ï¼å¦æéæ©å¦ãåä¸æåºï¼å¦æéæ©æå°ï¼åæ ¹æ®æ°æ®é¡¹çæåºå±æ§è¿è¡æåºè®¾ç½®ãé»è®¤å¼ä¸ºæå°ã
3.3.7æ¥è¡¨Processing设置
å¨QueryçProcessingå±æ§ä¸å¯ä»¥ä¸ºæ¥è¯¢è®¾ç½®SQLçå¤ç设置ãCognos Report Studioä¼å°æ¥è¡¨çææ设置é¦å
转æ¢ä¸ºCognos SQLæ交ç»æ¥è¡¨æå¡å¨ï¼æå¡å¨å¨è¿è¡å¿
è¦å¤çåï¼ä¼å°SQLè¯å¥è½¬æ¢ä¸ºåºç¨æ°æ®åºæ¬å°æ§è¡çSQLè¯å¥ï¼è¿è¡æ°æ®åºå¤çã为æé«æ¥è¡¨çå¤çé度ï¼è¦å°½å¯è½çå°æ¥è¡¨çå¤çè¿ç®æ¾å¨æ°æ®åºè¿è¡ï¼ä»¥ä¿è¯å
¶è¿è¡é度ãå°è¯¥å±æ§è®¾ç½®ä¸ºDatabase onlyä¼å°æ¥è¡¨é¡µé¢çæçCognos SQLä¸ç»æ¥è¡¨æå¡å¨å¤çå
¨é¨è½¬æ¢ä¸ºæ°æ®åºè½å¤æ§è¡çæ¬å°æ°æ®åºSQLï¼å¦æå°è¯¥å±æ§è®¾ç½®ä¸ºLimited Localï¼åå°æ¥è¡¨é¡µé¢çæçCognos SQLå
è¿è¡å¿
è¦çæ¥è¡¨æå¡å¨è¿ç®ï¼ç¶ååå°å©ä½çé¨åæ交ç»æ°æ®åºè¿è¡æ¬å°SQLçå¤çãé»è®¤å¼ä¸ºFrameworkä¸ä¸ºDatasource对象ç设置çqueryProcessingå±æ§ã
3.3.8使ç¨Withåå¥
å¨QueryçUse SQL With Clauseå±æ§ä¸å¯ä»¥ä¸ºæ¥è¯¢è®¾ç½®æ¯å¦ä½¿ç¨Withåå¥ãé¨åæ°æ®åºä¾å¦Oracleæ¯æWithå
³é®åï¼å½æ¥è¯¢ä¸åµå¥åæ¥è¯¢æ¶ï¼å¯ä»¥éè¿Withåå¥ç使ç¨ï¼åè½»æ¥è¡¨æå¡å¨å¯¹Cognos SQLçå¤çï¼ä»èæåæ¥è¡¨çè¿è¡æ§è½ãå¦æå°è¯¥å±æ§è®¾ç½®ä¸ºYesï¼åå
许使ç¨Withå
³é®åï¼æ¥è¯¢ä¸çæçNative SQLå°åºç°Withåå¥ï¼å¦æå°è¯¥å±æ§è®¾ç½®ä¸ºNoï¼è½ç¶æç»ä½¿ç¨Withå
³é®åãé»è®¤å¼ä¸ºFrameworkä¸Edit Governorsä¸çUse WITH clause when generating SQLå±æ§è®¾ç½®ã
3.3.9æ¥è¡¨æå¡å¨æ¬å°ç¼å设置
å¨QueryçUse Local Cacheå±æ§ä¸å¯ä»¥ä¸ºæ¥è¯¢è®¾ç½®æ¯å¦ä½¿ç¨æ¬å°ç¼åãå¦æå°è¯¥å±æ§è®¾ç½®ä¸ºYesï¼åå¯ç¨æå¡å¨çæ¬å°ç¼åï¼æå¡å¨å°ä¸ºæ¥è¯¢ç»æä¿åå¨sessionä¸ï¼å½ç¨æ·å¨æµè§å¨å
å次æå¼åä¸å¼ æ¥è¡¨æ¶ï¼æ¥è¯¢ç»æå°åèªç¼åï¼ä»èåè½»äºæ°æ®åºçè´è½½ååï¼å¦æå°è¯¥å±æ§è®¾ç½®ä¸ºNoï¼åç¦ç¨æå¡å¨çæ¬å°ç¼åï¼æ¥è¯¢ç»æå
¨é¨åèªæ°æ®åºçå®æ¶æ°æ®ãé»è®¤å¼ä¸ºFrameworkä¸Edit Governorsä¸çAllow usage of local cacheå±æ§è®¾ç½®ã
æç¨çæ¯finereportï¼æ¯è¿ä¸ªæ¹ä¾¿
温馨提示:答案为网友推荐,仅供参考