CORONA EVEN IN UK, GERMANY AND SWISS??

Steve Jobs : who took the world decades ahead no more.........

Steve jobs one of the world's greatest visionary, innovator on top of all kind hearted is no more. He is the man who made his company's financial health better than country's economy itself. Technology World is definitely missing many more innovations and greatest Apple products.

Effective Dashboard design with SAP BW/BI(BO) systems

BW 7.X with BI 4.0 (BO) version gives latest features to connect directly BW system using BICS . But previous versions has the following landscape.
Data in the Infocubes in BI system and the queries can be accessible by WebI report through Universe semantic layer or can be directly used by Infocubes with EHP1 or SP6 on SAP BI 7.1 version and BO XI 3.1 version SP3 and Fix pack 3.4(4).

Xcelsius dashboards directly fetch the live data and shows latest information to users..

The best approach for creating effective and efficient dashboards using SAP BW and BO systems.

1. User Requirements:
Understanding of user requirements and feasibility analysis of the requirements is very important. Communicating users about limitations using dashboards and keeping expectations right.

2. Dataflow:
Data flows and screen flows created is very much useful and saves time and improves clarity. Proper Modeling of Universe, WebI reports and Xcelsius is required to optimize the performance of the dashboards to handle the data volume.

3. Visualization
Visualization of the dashboards is very important. Details of graphs, charts, data points, filters, radio boxes, links to external reports, quadrants everything should be visualized before starting actual development of the dashboard.

4. High level analysis only
Dashboards are meant for only high level, aggregated analysis and don’t try to display too much of data on dashboard.

5. Detailed Requirements on WebI reports/Crystal Reports:
Should provide link using Open documents to WebI reports or Crystal reports .

6. Data Availability from the source
Data availability from the underlying source systems is the foremost important thing. Make sure the data from underlying BW system or any other source system is accurate.

7. Query structure:
BW query structure should be created according to the dashboard requirement and not to include too many free characteristics and query design should be at the possible aggregated level.

• 8. Improvisation of the dashboards
Keep on improvising the dashboards based on the input inputs from the stake holders.


9. System Limitations :
System performance should always be taken into consideration. Always better to know the limitations.

10. Calculations at BW system:
It is always advisable to keep calculations at BW level to improve the performance of the dashboard.

11. Avoid using unnecessary formulae in Dashboards:
Keep minimum formulae in dashboards to avoid unncessary performance issues and dashboard long runtimes.

12. Scheduling reports
Report scheduling is a two step process for dashboards in Xcelsius dashboard.
a. WebI reports can be scheduled from Infoview to get regular data refresh from BW queries.
b. Live office refresh loads at regular intervals refresh data mapped in Xcelsius.

13. Roles and security:
Define and Import roles from underlying SAP BW system and create appropriate user roles and security.

14. Testing:
Complete proper functional and technical testing.

Indian Sports Legends Awards by CNN IBN

It was a great positive event by CNN IBN channel to organize Indian Sports Legends award function for all the sports icons in India from all the sporting events.

This is a kind of unique event and brought all the sports icons under the same roof, whom we have already forgetten long back. We always get carried away by mega film functions and cricket events ignoring who really contributed and spread the glory of the nation throughout the world.

This event definitely showcases the talent pool, we really have. These sports persons are ready to contribute their services to the nation. Some have already started training Academies to coach and make their students the future stars in those sporting events.

But, unfortunate thing is the lack of motivation and directionless efforts from the Government to recognize these talented few and grow their community and fraternity. Lack of genuine corporate interest to encourage.
Incapable Federations, selfish buerocrates and corrupted politicians are the main culprits of the current situation.

We might even get surprised by the way some of these legends became victims of the politics just because they were not part of it also how their career is spoiled or totally ignored.

Jaspal Rana from shooting, Kapildev, captain from world cup winning team and Aslam Sher Khan from hockey world cup winning team in 1975 are few of the players (though the list is endless) who haven't got enough recognition for their contributions.

Also, encouraging the talent is just not spending the money the way we have spent on CWG. As most of these players are not looking for the money than signs of appreciation and recognition.

But, hope we can see similar events and genuine interest by the government as well and other organizers to encourage and motivate the future generations to contirbute to the glory of the nation.

SAP Links

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20902

SAP BI TCodes

S.No	Tcode	Description
1	RSA1	Administrator Work Bench
2	RSA11	Calling up AWB with the IC tree
3	RSA12	Calling up AWB with the IS tree
4	RSA13	Calling up AWB with the LG tree
5	RSA14	Calling up AWB with the IO tree
6	RSA15	Calling up AWB with the ODS tree
7	RSA2	OLTP Metadata Repository
8	RSA3	Extractor Checker
9	RSA5	Install Business Content
10	RSA6	Maintain DataSources
11	RSA7	BW Delta Queue Monitor
12	RSA8	DataSource Repository
13	RSA9	Transfer Application Components
	RSBBS	Maintain Query Jumps (RRI Interface)
14	RSD1	Characteristic maintenance
15	RSD2	Maintenance of key figures
16	RSD3	Maintenance of units
17	RSD4	Maintenance of time characteristics
18	RSDBC	DB connect
19	RSDCUBE	Start: InfoCube editing
20	RSDCUBED	Start: InfoCube editing
21	RSDCUBEM	Start: InfoCube editing
22	RSDDV	Maintaining
23	RSDIOBC	Start: InfoObject catalog editing
24	RSDIOBCD	Start: InfoObject catalog editing
25	RSDIOBCM	Start: InfoObject catalog editing
26	RSDL	DB Connect – Test Program
27	RSDMD	Master Data Maintenance w.Prev. Sel.
28	RSDMD_TEST	Master Data Test
29	RSDMPRO	Initial Screen: MultiProvider Proc.
30	RSDMPROD	Initial Screen: MultiProvider Proc.
31	RSDMPROM	Initial Screen: MultiProvider Proc.
32	RSDMWB	Customer Behavior Modeling
33	RSDODS	Initial Screen: ODS Object Processng
	RSDS	Data Source Repository
34	RSIMPCUR	Load Exchange Rates from File
35	RSINPUT	Manual Data Entry
36	RSIS1	Create InfoSource
37	RSIS2	Change InfoSource
38	RSIS3	Display InfoSource
39	RSISET	Maintain InfoSets
40	RSKC	Maintaining the Permittd Extra Chars
41	RSLGMP	Maintain RSLOGSYSMAP
42	RSMO	Data Load Monitor Start
43	RSMON	BW Administrator Workbench
44	RSOR	BW Metadata Repository
45	RSORBCT	BI Business Content Transfer
46	RSORMDR	BW Metadata Repository
47	RSPC	Process Chain Maintenance
48	RSPC1	Process Chain Display
49	RSPCM	Monitor daily process chains
50	RSRCACHE	OLAP: Cache Monitor
51	RSRT	Start of the report monitor
52	RSRT1	Start of the Report Monitor
53	RSRT2	Start of the Report Monitor
54	RSRTRACE	Set trace configuration
55	RSRTRACETEST	Trace tool configuration
56	RSRV	Analysis and Repair of BW Objects
57	SE03	Transport Organizer Tools
58	SE06	Set Up Transport Organizer
59	SE07	CTS Status Display
60	SE09	Transport Organizer
61	SE10	Transport Organizer
62	SE11	ABAP Dictionary
63	SE18	Business Add-Ins: Definitions
64	SE18_OLD	Business Add-Ins: Definitions (Old)
65	SE19	Business Add-Ins: Implementations
66	SE19_OLD	Business Add-Ins: Implementations
67	SE21	Package Builder
68	SE24	Class Builder
69	SE80	Object Navigator
70	RSCUSTA	Maintain BW Settings
71	RSCUSTA2	ODS Settings
72	RSCUSTV*
73	RSSM	Authorizations for Reporting
74	SM04	User List
75	SM12	Display and Delete Locks
76	SM21	Online System Log Analysis
77	SM37	Overview of job selection
78	SM50	Work Process Overview
79	SM51	List of SAP Systems
80	SM58	Asynchronous RFC Error Log
81	SM59	RFC Destinations (Display/Maintain)
82	LISTCUBE	List viewer for InfoCubes
83	LISTSCHEMA	Show InfoCube schema
84	WE02	Display IDoc
85	WE05	IDoc Lists
86	WE06	Active IDoc monitoring
87	WE07	IDoc statistics
88	WE08	Status File Interface
89	WE09	Search for IDoc in Database
90	WE10	Search for IDoc in Archive
91	WE11	Delete IDocs
92	WE12	Test Modified Inbound File
93	WE14	Test Outbound Processing
94	WE15	Test Outbound Processing from MC
95	WE16	Test Inbound File
96	WE17	Test Status File
97	WE18	Generate Status File
98	WE19	Test tool
99	WE20	Partner Profiles
100	WE21	Port definition
101	WE23	Verification of IDoc processing
102	DB02	Tables and Indexes Monitor
103	DB14	Display DBA Operation Logs
104	DB16	Display DB Check Results
105	DB20	Update DB Statistics
106	KEB2	DISPLAY DETAILED INFO ON CO-PA DATA SOURCE R3
107	RSD5	Edit InfoObjects
108	SM66	Global work process Monitor
109	SM12	Display and delete locks
110	OS06	Local Operating System Activity

111	RSKC	Maintaining the Permittd Extra Chars
112	SMQ1	qRFC Monitor (Outbound Queue)

Undecided yet...

I am still thinking about my topic to publish here.

Should I write about the Haiti earthquake where rescue teams are still finding survivors even days after the incident?????? Or should I write about injuries for most of the cricketers in Indian team before the test series win in Bangladesh??? Or this be about the elections in Srilanka where RajaPaksa is the winner as president?? Or is it about the weather in UK (hmmm... Almost a decade ago one of my culture trainer told us not to discuss Politics and weather here...)???

I couldn't sleep last night properly. It's not about the blog which I have not yet decided, but it could be insomnia which is causing disturbed sleep for some time.

Give me some more time (I don't know how much time) before I can think and come back with a good one.

Thanks for your patience.

Cheers

Paramesh