OBIEE: Calculating First Day of Year, Quarter, Month in Answers / Analytics

The difference between syntax is highlighted:

First Day of Calendar Year: TIMESTAMPADD(SQL_TSI_DAY, -1*(DAYOFYEAR(CURRENT_DATE )-1) , CURRENT_DATE )

First Day of Calendar Quarter: TIMESTAMPADD(SQL_TSI_DAY, -1*(DAY_OF_QUARTER(CURRENT_DATE )-1) , CURRENT_DATE )

First Day of Calendar Month: TIMESTAMPADD(SQL_TSI_DAY, -1*(DAYOFMONTH(CURRENT_DATE )-1) , CURRENT_DATE )

Hope this helped!

SQL: Formatting SQL Statement

Key components of Data Manipulation Language (DML) SQL statement's format:

SELECT	INSERT	UPDATE	DELETE
SELECT	INSERT INTO VALUES	UPDATE SET WHERE	DELETE FROM WHERE
FROM	INSERT INTO SELECT FROM WHERE
WHERE AND OR
GROUP BY
HAVING AND OR
ORDER BY

Hope this helped!

Business Intelligence Project Information Gathering Template

Please note that this templates are created in MS OneNote.

This template illustrates a basic technical information gathering for a new BI project.




Contact	File Transfer Process	File Name
John Doe	FTP / www.sample.com	Sample_File.csv




Project/Metric Name	Source File Name	Data-Load Frequency	Data-Load Type	File Transfer Method
Product Count	SampleFile.csv	Daily	Full / Increment	Upload



• Database Table:
• T_DIMENSION_TABLE_D
• T_FACT_TABLE_F
• Date Column:
• ACTIVITY_DATE
• Measures the metrics over certain period of time. i.e. MTD, QTD, YTD
• Hierarchy / Drills:
• Country > State > County > City > Zip Code
• Filters:
• Zip Code, First_Name, Last_Name etc...
• Subject Area / Cube Name:
• Sample Sales
• Metrics:
• A / B = C


• Meeting Minutes:

YYYY-MM-DD Abc Action item needs to be completed and colored into black

YYYY-MM-DD Abc

Business Intelligence Basic IT Infrastructure Template

Please note that this templates are created in MS OneNote.

This template is an overview of What you need to start a BI project.

1. DOCUMENTATION:
1. IT infrastructure
2. Workflow process
3. Data warehouse design - ER Diagram (ERD)
4. On-going projects / new project initialization


2. COMMUNICATION:

	Login:	Password:	Note:
E-mail:	username@doamin.com	***
Chat Client:	IM Chatter / username	***
VPN:	VPN Client / username	***



3. SERVER ACCESS/NAME (Linux via Putty):

Server Name	Description	Access Point	User/Password
n10:		Server_name	Username/Password



4. BI ENVIRONMENT:

	URL	Login	Password	Note
DEV:		Username	Password
SIT:		Username	Password
STAGE:		Username	Password
PROD:		Username	Password



5. DATABASE CONNECTION (TNS):

TNS Name / Environment:	Schema User/Password	Hostname	Port	Service Name
TNS1	Username/Password	Host_name	1234	ORCL



6. Other:
1. Abc

Entity Relationship (ER) Diagram

How to read Entity Relationship (ER) diagram? and ER basics:

Source