Arul's.TEG Blog

Connect to Content Store Schema using Toad or SQL Navigator and execute below SQL SELECT   v_group_user.user_id, v_user.ldap_id,             LTRIM (RTRIM (UPPER (v_user.ldap_id))), v_group.cmid,             v_group.name_en name_en, v_group.name_fr name_fr, v_group.created,             v_group.modified, v_group.disabled, v_user.last_name,             v_user.first_name, v_user.email        FROM dba_group_info v_group,             (SELECT cmid GROUP_ID, refcmid user_id                FROM ops$cgs.cmreford1) v_group_user,             (SELECT c33.cmid user_id, UPPER (c33.NAME) ldap_id,                     c1.surname last_name, c1.givenname first_name,          ...

Connect to Content Store Schema using Toad or SQL Navigator and execute below SQL SELECT cmobjnames_base.cmid, cmobjects.pcmid, UPPER (cmobjnames_base.NAME),           cmobjects.created, cmobjects.modified, cmobjects.disabled,           cmobjnames_base.isdefault      FROM cmobjects, cmobjnames_base     WHERE cmobjects.classid IN (26, 54)       AND cmobjnames_base.mapdlocaleid = 24       AND cmobjects.cmid = cmobjnames_base.cmid

Connect to Content Store Schema using Toad or SQL Navigator and execute below SQL SELECT cmobjprops1.cmid, cmobjprops1.busphone, cmobjprops1.email,           cmobjprops1.faxphone, cmobjprops1.givenname, cmobjprops1.homephone,           cmobjprops1.mobilephone, cmobjprops1.pagerphone,           cmobjprops1.paddress, cmobjprops1.surname, cmobjprops1.TIMEZONE,           cmobjprops1.clocaleid, cmobjprops1.prodlocale, cmobjprops1.objid,           cmobjprops1.useaccessibility, cmobjprops33.cmid AS cmid1,           UPPER (cmobjprops33.NAME)      FROM cmobjprops1, cmobjprops33     WHERE cmobjprops1.cmid = cmobjprops33.cmid

Open Cognos FM Go to Projects > Options Go to Auto Save Tab and Click Auto Save On and enter the time-frame .   Click OK save the setting.

Chart Types in Cognos 8.4 1. Microcharts 2. Pie Charts 3. Column Charts 4. Marimekko Charts 5. Progressive Column Charts 6. Pareto Charts 7. Win-loss Charts 8. Bar Charts 9. Line Charts 10. Area Charts 11. Combination Charts 12. Radar Charts 13. Scatter Charts 14. Bubble Charts 15. Point Charts 16. Quadrant Charts 17. Polar Charts 18. Metrics Range Charts 19. Gauge Charts 20. Standard Charts 21. Stacked Charts 22. 100 Percent Stacked Charts 23. Three-dimensional Charts

Design Tip #117 Dealing with Data Quality: Don’t Just Sit There, Do Something! Most data quality problems can be traced back to the data capture systems because, historically, they have only been responsible for the level of data quality needed to support transactions. What works for transactions often won’t work for analytics. In fact, many of the attributes we need for analytics are not even necessary for the transactions, and therefore capturing them correctly is just extra work. By requiring better data quality as we move forward, we are requiring the data capture system to meet the needs of both transactions and analytics. Changing the data capture systems to get better data quality is a long term organizational change process. This political journey is often paralyzing for those of us who didn’t expect to be business process engineers in addition to being data warehouse engineers! Do not let this discourage you. You can take some small, productive steps in the short term t...

var form = getFormWarpRequest(); var textBox = form._textEditBoxMarketID; var parent=textBox.parentNode; var select; do { parent= parent.parentNode; var select= parent.getElementsByTagName("select"); } while(select.length ==0); var opt = select[0].childNodes; var length=opt.length if (length > 5) // User can select maximum of 5 values from prompt. { alert("You have selected " + length + " O&Ds, Please select only 5 or less "); } In the above code, MarketID is the ID of the TextEditBox Prompt