In a generalized way it should go like this:
1. read your SRS.
2.understand your reporting requirements.
3.Be through with reporting DB, in respect of Joins between the tables, typical query...
Type: Posts; User: pat.mclean; Keyword(s):
In a generalized way it should go like this:
1. read your SRS.
2.understand your reporting requirements.
3.Be through with reporting DB, in respect of Joins between the tables, typical query...
There is yet another way....
you can save the excelsheet as CSV file.
Cognos Transformer supports CSV files as source. you can directly read the data from CSV file & start building your dimensions...
Hey Kumar!
you haven't specified which tool you are using. BusinessObjects has different method of creating cascading prompts than Cognos.
if you can tell us on which tool you are looking...
well, there is 1 strong reason for it. say, i've customer name & ph_no as dimensions, BOBJ will try to calculate for both these objects if included in single query.
If you are aware about...
bhakshi, this sounds an interview question, why not try putting it in "Interview Questions" --> "Data Warehousing" --> "Cognos" ?
it would be better if we discuss some real time problems or cases...
Just a curiosity, have you tried writing macro for this?
Hey Vekat, can u be more elaborative? are there any dimansions being shared by both fact tables? is it creating loops?
if you look forward for perfect (or close to perfect sollution) try to be...
Well friends,
Thanks for your reply !
I'm obliged to know that you all are also looking forward for a common place to share knowledge & help others.:)
Lets discuss, how this board can be...
Hey Admin,
Thanks for the information:) . You have saved my time, I would have spent it in search of these resources. It seems, now I will have to play around with the tool & learn.:rolleyes:
...
Dear All,
Hi !
I've to work on "Ab Initio" ETL tool & I'm absolutely newbie in it. I searched on web for the resources such as documentation, help etc. but not succeeded.
Can anybody please...
Denormalization is a data model designing technique. It is used for Data Warehouse designing. your transactional systems ([OLTP] - Billing or online booking systems for example) are in generally 3NF...
Well, Ryan, The basic intention to build the data warehouse is to have a single version of truth of the historical enterprise data. The data warehouse building strategy is generally driven by the...
visit Kimball Group: Data Warehouse Training, Consulting, and Kimball University, it has truckload of information.
DataWarehousing.com - documenting data replication and data transformation ...
No. you can't insert alphanumeric data in numeric column. there are some functions to convert the data type like to_number(), to_char(), to_date() in Oracle.
if your data is between 0-9 that is...
hey shivanna,
its cool..... personally I love using shortcuts like these.
thanks for adding lots of them in my poor list
If considering platform independent DB, it would be good to get into Oracle else, You always have an option of SQL Server.
Yes, all of them work in ORACLE.
why don't you try it on your own?
Patrick.:cool:
create table target tablename as (select * from source tablename);
Patrick.:cool:
Dual table is like your scratch-pad. you can try different queries & functions using Dual.
For. E.g. if you want to find out max of any numbers that are not present in your schema & you want to do...
The numbers denote versions of ORACLE.
Well, for 'i' in 8i or 9i I dont know but
'g' in 10g stands for "GRID" i.e. Grid computing across the network.
You can create clusters in network to...
Hi Admin,
Is this the list of private forum members?
I'm interested in the contributions & according to your prior post, I have sent my experience info.(1.6 yrs Oracle, BusinessObjects,...
Hi Admin!
I've 1.5 yrs experience in Oracle, DWH, BusinessObjects Enterprise Suite (Supervisor,Designer,BusinessObjects,WebI).
I deal with development as well as training new recruits on...
Hi Admin!
This quiz package is really awesome.:) Thanks for making such a great tool available for the newbies !
I wonder if we can have something like this(may be a guide for dummies/newbies...
Dear All,
Hi !
It seems preety good to have forums on this tech site!! I'm impressed!
well, I was thinking about starting a Business Objects Forum right here on this site!
How is the...