what is dimention?explain dimentable with example?
- 3 Answers
- 8240 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
--------------Explain Table of contents?
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 is cognos connection?
Write some methods to apply securities in framework manager model?
How to create a cube in Transformer? What is the process? Please mention process thank u
What is drill down and slicing and dicing whats the difference between them?
What you mean by drill across?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
How to generate cubes in cognos?
What are all the types of hierarchies?
What is model filter?
How the Bursting happens in same report and how to Print the bursting Report?
-----------Diff b/w OLAP and RDBMS?
Explain the difference between native sql and cognos sql?
----------------Diff b/w Dimensional modeling and Relational modeling?
