Hi Champs!!
I am totally new in OLAP and want know more prior to start...pls tell me know the difference between these..
Regular/Virtual/Linked cubes..
Star schema/ snow flake/ parent-child/ virtual dimension/ mining model
Thanks in advance
-Deepak Kumar.Cubes
Cube consist of dimensions on ehich to analyse the data.
1>Regular Cube
A regular cube is based on tables in the databases specified in
the data sources of the cube's partitions
2>Virtual Cube
created with one or more regular cubes.
A virtual cube is a combination of multiple cubes in one logical
cube, somewhat like a relational database view that combines other
views and tables.Thus it contains measures from the related cubes.
3> Linked Cube
A linked cube is based on another cube that is defined and stored
on another Analysis server. To end users, linked cubes appear and
function like regular cubes. By using linked cubes, you can create,
store, and maintain a cube on one Analysis server while the cube is
also available as linked cubes on multiple Analysis servers
----------------------
**Dimension
1>Regular Dimension
every cube must has atleast one dimension.It is the default dimension.
dimensions have associated aggregation data in the cubes in which they
are used. A regular dimension contains a number of levels equal to the
number of columns selected during its definition
2>Virtual Dimension
Based on other dimensions.
A virtual dimension is a logical dimension based on the columns from
a physical dimension
3>Parent Child Dimension
A parent-child dimension is based on two dimension table columns that
together define the lineage relationships among the members of the
dimension. One column, called the member key column, identifies each
member; the other column, called the parent key column, identifies the
parent of each member. This information is used to create parent-child
links, which are then combined into a single member hierarchy that
represents a single meta data level.
For example, in the Employee table, the column that identifies each
member is Employee_Number. The column that identifies the parent of
each member is Manager_Employee_Number
----------------------
**Mining Model
A mining model enables you to analyze your data for patterns and to make
predictions based on the patterns. You can create a mining model from a
relational schema or a cube, and you can store output from the model in
a tabular column, a cube dimension, or a mining model diagram.
----------------------
**Star Schema
Star Schema: A single dimension table
Select to create a regular dimension based on a single dimension table.
The depth of the dimension depends on the number of levels you select
in a later step. Each level is derived from a column.
When the dimension is added to a cube, the dimension table joins
to the fact table. If each of the cube's dimensions is based on a
single table, the cube has a star schema.
**Snowflake Schema: Multiple, related dimension tables
Select to create a regular dimension based on multiple, joined dimension
tables. The depth of the dimension depends on the number of levels you
select in a later step. Each level is derived from a column.
When the dimension is added to a cube, only one of its dimension
tables joins to the fact table. Therefore, the cube has a snowflake schema.
Regards
Praveen Kumar Pandey
CoVisible Soltuions (http://www.covisible.com)
Showing posts with label olap. Show all posts
Showing posts with label olap. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
basic authentication with olap failing
Hi,
I've got a situation where I am trying to connect from my local PC to
a windows 2003 server that is running SQL Server2k EE with Analysis
Services and IIS.
I have followed a number of Microsoft articles for configuring http
access to the Analysis Services, and my msolap.asp file is located
correctly and I have tested that I can access it with both anonymous
and basic authentication enabled on the site. The connection string I
am using is pointing to the correct directory for my msolap.asp file.
I can type the url to my msolap.asp file into my browser and do not
get any errors, both on anonymous or basic authentication access (I
need to have basic authentication).
The problem lies in the fact that when I try and access my web site
pages that contain the OWC components, if I turn on basic
authentication on msolap.asp I get unspecified errors and cannot load
data. If I leave the msolap.asp file as anonymous access and my web
site virtual directory with basic authentication, I am promted to
login and the data displays correctly. However, if I refresh the
page, I am prompted to login again - which should not be happening.
The frustrating thing is, if I remove the dynamic OWC component from
my page but leave the static OWC component, then I do not get prompted
to log in multiple times and it behaves as it should.
I know I've outlined a few problems in this post, but I'm pretty new
to OLAP and I'm just trying to get it running on a server.
Thanks in advanceTo clear up a few items, it appears there is no impact of the OWC
component being dynamic or static, as either one of them results in
multiple login prompts. If I disable basic authentication on
msolap.asp, then the strange behaviour I notice is that when I have the
site marked as "Trusted" in my browser, I am prompted to login on first
page access (which is correct), but then prompted to login again on any
hyperlink click on the page or on a page refresh. If I remove the
"Trusted" status, then I am only prompted to login on first access to
the site and on any subsequent refresh of the page in the browser.
Is this the correct behaviour for OWC/OLAP components?
Thankssql
I've got a situation where I am trying to connect from my local PC to
a windows 2003 server that is running SQL Server2k EE with Analysis
Services and IIS.
I have followed a number of Microsoft articles for configuring http
access to the Analysis Services, and my msolap.asp file is located
correctly and I have tested that I can access it with both anonymous
and basic authentication enabled on the site. The connection string I
am using is pointing to the correct directory for my msolap.asp file.
I can type the url to my msolap.asp file into my browser and do not
get any errors, both on anonymous or basic authentication access (I
need to have basic authentication).
The problem lies in the fact that when I try and access my web site
pages that contain the OWC components, if I turn on basic
authentication on msolap.asp I get unspecified errors and cannot load
data. If I leave the msolap.asp file as anonymous access and my web
site virtual directory with basic authentication, I am promted to
login and the data displays correctly. However, if I refresh the
page, I am prompted to login again - which should not be happening.
The frustrating thing is, if I remove the dynamic OWC component from
my page but leave the static OWC component, then I do not get prompted
to log in multiple times and it behaves as it should.
I know I've outlined a few problems in this post, but I'm pretty new
to OLAP and I'm just trying to get it running on a server.
Thanks in advanceTo clear up a few items, it appears there is no impact of the OWC
component being dynamic or static, as either one of them results in
multiple login prompts. If I disable basic authentication on
msolap.asp, then the strange behaviour I notice is that when I have the
site marked as "Trusted" in my browser, I am prompted to login on first
page access (which is correct), but then prompted to login again on any
hyperlink click on the page or on a page refresh. If I remove the
"Trusted" status, then I am only prompted to login on first access to
the site and on any subsequent refresh of the page in the browser.
Is this the correct behaviour for OWC/OLAP components?
Thankssql
Subscribe to:
Posts (Atom)