Metric Studio: Import Source Time Periods Stage File (.ctp)

Home

Library

Main Menu

Member Menu (Login Required)

Countries

50.1%		United States
7.6%		India
7%		United Kingdom
5.1%		Australia
4.8%		Canada

Visitors

Today:	39
Yesterday:	573
This Week:	39
Last Week:	3348
This Month:	9424
Last Month:	15365
Total:	383511

Metric Studio: Import Source Time Periods Stage File (.ctp)

(0 votes, average 0 out of 5)

Tuesday, 22 March 2011 07:58

The import source time periods stage file identifies time period information in the cube import source.

The import source time periods stage file loads the import_source_tp_stage table. The columns in the import source time periods stage file are as follows.

No.	Column	Description
1	level_id	The unique identifier for the time level.
2	start_time_cd	The calendar date that identifies the period for the current data row.
3	end_time_cd	The calendar-based end date for the specified period. Value: yyyy-mm-dd hh:mm:ss (24-hour clock) The end_time_cd value must be specified as the last minute of a time period. For example, 2005-01-01 23:59:00. Required
4	import_source_id	The unique identifier of the cube import source.
5	time_period_exp	The IBM Cognos 8 expression for the time period used in the cube.
6	created_dt	The date the import was created. Format: yyyy-mm-dd hh:mm:ss (24-hour clock) (hh:mm:ss values are optional) Required

Source: Metric Studio User Guide 8.4.1

www.cogknowhow.com

Login

CogKnowHow Newsletter

Polls

How many users are working on your Cognos environment?

	1 - 100 users
	101 - 250 users
	251 - 500 users
	501 - 1000 users
	1000 or more users