Interested to Buy Any Domain ? << Click Here >> for more details...
what is dimention?explain dimentable with example?
- 3 Answers
- 9495 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / palzkumar
Dimension Table is a table which contains categories and
hierarchies with lowest granule.
Data stored in dimension are nothing but the masters.
Its doesn't store any numeric value or summerised data.
eg.
Product dimension
Customer dimension
Channel dimension
Time dimension
etc..
Time dimension will have the foll records..
Year > Quarter > Month > Week > Day
-------------------------------------
2009 > Qtr-02 > Aug > 35 > 04-sep-08
2009 > Qtr-02 > Aug > 35 > 05-sep-08
2009 > Qtr-02 > Aug > 35 > 06-sep-08
rgds
palz
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Can we test the report other than manual testing?
how to create cubes in transformer ?
When we save a report in report studio with what extn it save?
What is Online View?
Can you define confirmed dimension?
Explain is there any comparison available for cognos reportnet vs crystal reports?
What is the use of powerplay web viewer in cognos?
What is Metrics designer?
What are the roles defined by cognos platform?
What is cognos reporting tool?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What do you mean by drill across?
Can you define pivot?
what are the dimensions that you have in your current project?list them?
how to merge 2 crosstabs thans
