timestamp to date function

timestamp to date function:

cast([Audit].[Threshold Violations].[Time stamp], date) = current_date

Running a Report via Trigger

Running a Report via Trigger


https://www.youtube.com/watch?v=yhV8Q5SeTSU

Cognos audit package name conver to readable format :

Cognos audit package name conver to readable format :


SUBSTRING(
SUBSTRING([Audit].[Run Reports].[Package]
,CHARINDEX('=',[Audit].[Run Reports].[Package]
)+2,1000)
,1,
CHARINDEX(''']',SUBSTRING([Audit].[Run Reports].[Package]
,CHARINDEX('=',[Audit].[Run Reports].[Package]
)+2,1000)))

SQL Server with Cognos Year, Month, Day convertion

SQL Server with Cognos Year, Month, Day conversion

Year
convert(Char(4),Year(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))


Month

case when convert(Char(2),Month(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))<10 then
'0'||convert(Char(2),Month(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))
else convert(Char(2),Month(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))
end

Day

convert(Char(8),Day(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))

cognos visualization library and customizer

IBM Vizualization Customizer : https://www.ibm.com/communities/analytics/cognos-analytics-
blog/cognos-business-intelligence-cognos-analytics-visualization-customizer/

1. Run VisCustomizer.jar
2. Open vis.sample.clusteredbar.zip from file menu
3. Amend the vizJSON part as you required .
4. Select Chart Type Definition tab
5. Change the values of Bundle Name text box  
6. Example : in place sbm any text you  can mention
7. vis.sample.clusteredbar.zip to vis.sample.clusteredbar.sbm.zip
8. Select String Resources tab 
9. Tag Metion : clusteredbar
10. Change the values of lblChartType=clusteredbar to lblChartType=clusteredbar-sbm
11. Validate Bundle button
12. Upgrade Definition  button
13. Generate Vis Bundle Definition button
14. click to save / save as
15. Give new name : vis.sample.clusteredbar.sbm.zip
16. import file to cognos

        2.3 : Select String Resources tab and change the values of lblChartType=Chord to lblChartType=Chord-sbm
        2.4 : Click on Validate Bundle button to check the validity of changes. (Valid message will appears).
         2.5 : Click on Upgrade Definition  button. (The definition was successfully upgrades message will appears).
               2.6 : Click on Generate Vis Bundle Definition button then click to save the file with new name  (ex: vis.sample.chord_sbm_10_2_2.zip.)
               2.7 : Import the file to your Cognos Environment then you will have two visualizations as below

==================================================

If you are facing some issue while open library file ?

1. Open VisCustomizer.jar
2. Remove validate check box then click on Draw chart.
3. then open library file