Showing posts with label analysis. Show all posts
Showing posts with label analysis. Show all posts

Monday, March 19, 2012

How to use reporting services with data mining ?

Hi ,

How can I use reporting services to get reports out of analysis Services Database ?

I found following on one site, but I tried to look for Analysis services database on the server I am deploying the model , but I am not able to find it.

'To use Reporting Services with data mining, you simply create a Reporting Services project with the BI Dev Studio and specify an Analysis Services database as your data source. Depending on the contents of the database, you will be presented with either an OLAP or Data Mining query builder as in Figure 3.23. You can always switch between the two modes by clicking the Switch '

thanks,

Vikas

Hi

Please try the following:

1. In your report project, right click the Shared Data Sources and select "Add New Shared Data Source"

2. In the Type box, select "Microsoft SQL Server Analysis Services"

3. Click on the "Edit" button. In the connection dialog, specify the Analysis Server name (Optionally instance name) in the Server name text box.

4. Drop the database name combo box and select the database name where your Data Mining models have been deployed.

5. Click OK to create a shared data source

When creating a new report, select this data source and select the "Query Builder". You should see a DMX query designer where you'll be able to create a dataset for your report.

Hope this helps. Please reply if you have any additional questions

Thanks

Shuvro

|||


Hi Shuvro,

I did everything you specified. But when I go to query builder window I do not see any mining model there. My mining project is fine. It shows me all models , lift charts etc in Analysis Services , which indicates the the SSAS Database I am using has all models etc. Why nothing is being shown whne I open the DB is RS ?

Thanks,

Vikas

|||

I think the UI is a little confusing. You'll see a empty Mining Model window with a button "Select Model...". If you click the button and navigate to the DB->Mining Structure->Mining Model and hit OK, the query window should get populated with the model and the columns

If this does not work, can you please send me a screen shot of your query window to (shuvrom at microsoft.com). at=@.

Thanks

|||Hi Shuvro,

Your answer is correct. However, that way I'm still unable to get the chart of decision tree using the Reporting Service (and Report Builder). How can I display the chart of decision tree, chart of time-series and clusters in the web? Your answer can only be used to display numbers that are the result of prediction-query or simple-query; not chart or picture in any way.

Thank you,

Bernaridho|||Currently there isn't any built-in way to display the graphical results of the DM viewers in a report. A sample that has thin client versions of the decision tree, classification and discrimination charts is provided if you install all of the samples included with the SQL Server product. You can also see these samples in action at www.sqlserverdatamining.com in the Live Samples section.|||Hi Jamie,

I've tried searching what you mean, but I have not found it.
Do you mean the thin client viewer? If that's what you mean, then I have problem downloading it yet I can try again later.

However, if you also mean one-or-more post(s) in sqlserverdatamining.com, could you please give the URL (or specific date) of that post(s)?

Thank you,

Bernaridho|||

The smples are included witht he product, but they need to be explicitly installed. To install, you need to click the advanced button on the page where you select components and drill down into the documentation and samples node.

The like I was referring to was http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/52.aspx, where it shows the viewers in action.

How to use reporting services with data mining ?

Hi ,

How can I use reporting services to get reports out of analysis Services Database ?

I found following on one site, but I tried to look for Analysis services database on the server I am deploying the model , but I am not able to find it.

'To use Reporting Services with data mining, you simply create a Reporting Services project with the BI Dev Studio and specify an Analysis Services database as your data source. Depending on the contents of the database, you will be presented with either an OLAP or Data Mining query builder as in Figure 3.23. You can always switch between the two modes by clicking the Switch '

thanks,

Vikas

Hi

Please try the following:

1. In your report project, right click the Shared Data Sources and select "Add New Shared Data Source"

2. In the Type box, select "Microsoft SQL Server Analysis Services"

3. Click on the "Edit" button. In the connection dialog, specify the Analysis Server name (Optionally instance name) in the Server name text box.

4. Drop the database name combo box and select the database name where your Data Mining models have been deployed.

5. Click OK to create a shared data source

When creating a new report, select this data source and select the "Query Builder". You should see a DMX query designer where you'll be able to create a dataset for your report.

Hope this helps. Please reply if you have any additional questions

Thanks

Shuvro

|||


Hi Shuvro,

I did everything you specified. But when I go to query builder window I do not see any mining model there. My mining project is fine. It shows me all models , lift charts etc in Analysis Services , which indicates the the SSAS Database I am using has all models etc. Why nothing is being shown whne I open the DB is RS ?

Thanks,

Vikas

|||

I think the UI is a little confusing. You'll see a empty Mining Model window with a button "Select Model...". If you click the button and navigate to the DB->Mining Structure->Mining Model and hit OK, the query window should get populated with the model and the columns

If this does not work, can you please send me a screen shot of your query window to (shuvrom at microsoft.com). at=@.

Thanks

|||Hi Shuvro,

Your answer is correct. However, that way I'm still unable to get the chart of decision tree using the Reporting Service (and Report Builder). How can I display the chart of decision tree, chart of time-series and clusters in the web? Your answer can only be used to display numbers that are the result of prediction-query or simple-query; not chart or picture in any way.

Thank you,

Bernaridho|||Currently there isn't any built-in way to display the graphical results of the DM viewers in a report. A sample that has thin client versions of the decision tree, classification and discrimination charts is provided if you install all of the samples included with the SQL Server product. You can also see these samples in action at www.sqlserverdatamining.com in the Live Samples section.|||Hi Jamie,

I've tried searching what you mean, but I have not found it.
Do you mean the thin client viewer? If that's what you mean, then I have problem downloading it yet I can try again later.

However, if you also mean one-or-more post(s) in sqlserverdatamining.com, could you please give the URL (or specific date) of that post(s)?

Thank you,

Bernaridho|||

The smples are included witht he product, but they need to be explicitly installed. To install, you need to click the advanced button on the page where you select components and drill down into the documentation and samples node.

The like I was referring to was http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/52.aspx, where it shows the viewers in action.

Friday, March 9, 2012

How to use information from a dimension in a calculated member

It would be really useful to be able to extract information from an Analysis Services 2005 dimension such as:-

"The number of seconds in the current time dimension member".

This will enable calculated members such as the following to compute a process percent operation time.

Member = [Measures].[Sum of seconds the process was operating] / "No of seconds in the current time dimension member" (eg.Day, Week, Month etc.)

How can I get this information from the dimension for use in a calculated member?

Many thanks

There could be various approaches to this - here's an example for Adventure Works, which computes the number of seconds for the selected Date dimension members, based on counting the number of days (leaf level) which "exist" with the currently selected Date members:

>>

With Member [Measures].[Seconds] as

Count(Existing [Date].[Date].[Date].Members) * 24 * 60 * 60,

FORMAT_STRING = '#,#'

select {[Measures].[Seconds]} on 0

from [Adventure Works]

where {[Date].[Calendar].[Date].&[1],

[Date].[Calendar].[Date].&[46]}

-

Seconds
172,800

>>

But this approach may not work as desired with nested from sub-cube queries:

>>

With Member [Measures].[Seconds] as

Count(Existing [Date].[Date].[Date].Members) * 24 * 60 * 60,

FORMAT_STRING = '#,#'

select {[Measures].[Seconds]} on 0

from

(select {[Date].[Calendar].[Date].&[1],

[Date].[Calendar].[Date].&[46]} on 0

from [Adventure Works])

Seconds
100,051,200

>>

A more tedious approach, which will work in both scenarios above, is to create a separate measure group on the Date dimension table, with a Named Calculation like: Seconds = 24 * 60 * 60. Then a "Seconds" sum measure can be created for this Named Calculation, which returns the seconds spanned by the selected Date members.

|||

Thanks for the suggestions Deepak however what I am trying to do does not directly involve the time dimension.

I have another dimension called Shift which contains information about the process operator shifts. The shift dimension information comes from a SQL table which has ShiftID, Shift Start Date Time, and Shift End Date Time fields. The main process data table links to the shift table using ShiftID.

Using the shift dimension I can now extract from the cube the process run time per operator shift - all works very well so far.

What I now want to do for each of the shifts, is to set up a calculated measure to compute the shift length in seconds based on the shift start and shift end fields in the shift dimension. I can therefore compute the percent run time per shift using this information together with the process run time.

I am very new to MDX so any help would be appreciated.

Thanks in advance.

|||

Add a Named Calculation to the Shift dimension table, and make this an Attribute (its hierarchy doesn't need to be enabled) - the attribute value can be set equal to the key (ie. integer):

ShiftLength: datediff(second, "Shift Start Date Time", "Shift End Date Time")

Then, [Measures].[ShiftLength]: [Shift].[Shift].Properties("ShiftLength", TYPED)

|||

Hi Deepak,

I have tried out your suggestion:-

- Set up the calculated member ShiftLength which works fine
- Added ShiftLength as an attribute to the Shift Dimenson (Property of the key ShiftID)

I can now browse the shift dimension and see the ShiftLength member property which is fine.

I have created a calculated member:-

CREATE MEMBER CURRENTCUBE.[MEASURES].[ShiftLength]

AS [Shift].[Shift ID].Properties( "Shift Length", TYPED),

VISIBLE = 1 ;

However for some reason no values are returned from the cube for this calculated member. What am I doing wrong?

Thanks for your continued help.

|||

A couple of things to consider:

Is "Shift Length" the name of the attribute, or ShiftLength - the same spelling should be used everywhere?|||

Hi Deepak,

Thanks for the reply - I can now extract the shift length successfully, it was a ShiftID level problem!.

Would you have an answer to my earlier unanswered post "strToMember Execution Problem"?

Many thanks

Adrian

|||

Adrian West wrote:

Hi Deepak,

Thanks for the reply - I can now extract the shift length successfully, it was a ShiftID level problem!.

Would you have an answer to my earlier unanswered post "strToMember Execution Problem"?

Many thanks

Adrian

I'm struggling a bit here
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=524766&SiteID=1

I changed mine to this, no luck (doesn't show up on Browser)

CREATE MEMBER CURRENTCUBE.[MEASURES].[% Capacity Sold]

AS [Dim Performances].[Dim Performances].Properties( "Perf Capacity", TYPED),

VISIBLE = 1 ;

What exactly goes into the 2nd [ ] bracket? Does it have to be a hierarchy, or can it be an attribute? Does it have to be "Key"?

How to use information from a dimension in a calculated member

It would be really useful to be able to extract information from an Analysis Services 2005 dimension such as:-

"The number of seconds in the current time dimension member".

This will enable calculated members such as the following to compute a process percent operation time.

Member = [Measures].[Sum of seconds the process was operating] / "No of seconds in the current time dimension member" (eg.Day, Week, Month etc.)

How can I get this information from the dimension for use in a calculated member?

Many thanks

There could be various approaches to this - here's an example for Adventure Works, which computes the number of seconds for the selected Date dimension members, based on counting the number of days (leaf level) which "exist" with the currently selected Date members:

>>

With Member [Measures].[Seconds] as

Count(Existing [Date].[Date].[Date].Members) * 24 * 60 * 60,

FORMAT_STRING = '#,#'

select {[Measures].[Seconds]} on 0

from [Adventure Works]

where {[Date].[Calendar].[Date].&[1],

[Date].[Calendar].[Date].&[46]}

-

Seconds
172,800

>>

But this approach may not work as desired with nested from sub-cube queries:

>>

With Member [Measures].[Seconds] as

Count(Existing [Date].[Date].[Date].Members) * 24 * 60 * 60,

FORMAT_STRING = '#,#'

select {[Measures].[Seconds]} on 0

from

(select {[Date].[Calendar].[Date].&[1],

[Date].[Calendar].[Date].&[46]} on 0

from [Adventure Works])

Seconds
100,051,200

>>

A more tedious approach, which will work in both scenarios above, is to create a separate measure group on the Date dimension table, with a Named Calculation like: Seconds = 24 * 60 * 60. Then a "Seconds" sum measure can be created for this Named Calculation, which returns the seconds spanned by the selected Date members.

|||

Thanks for the suggestions Deepak however what I am trying to do does not directly involve the time dimension.

I have another dimension called Shift which contains information about the process operator shifts. The shift dimension information comes from a SQL table which has ShiftID, Shift Start Date Time, and Shift End Date Time fields. The main process data table links to the shift table using ShiftID.

Using the shift dimension I can now extract from the cube the process run time per operator shift - all works very well so far.

What I now want to do for each of the shifts, is to set up a calculated measure to compute the shift length in seconds based on the shift start and shift end fields in the shift dimension. I can therefore compute the percent run time per shift using this information together with the process run time.

I am very new to MDX so any help would be appreciated.

Thanks in advance.

|||

Add a Named Calculation to the Shift dimension table, and make this an Attribute (its hierarchy doesn't need to be enabled) - the attribute value can be set equal to the key (ie. integer):

ShiftLength: datediff(second, "Shift Start Date Time", "Shift End Date Time")

Then, [Measures].[ShiftLength]: [Shift].[Shift].Properties("ShiftLength", TYPED)

|||

Hi Deepak,

I have tried out your suggestion:-

- Set up the calculated member ShiftLength which works fine
- Added ShiftLength as an attribute to the Shift Dimenson (Property of the key ShiftID)

I can now browse the shift dimension and see the ShiftLength member property which is fine.

I have created a calculated member:-

CREATE MEMBER CURRENTCUBE.[MEASURES].[ShiftLength]

AS [Shift].[Shift ID].Properties( "Shift Length", TYPED),

VISIBLE = 1 ;

However for some reason no values are returned from the cube for this calculated member. What am I doing wrong?

Thanks for your continued help.

|||

A couple of things to consider:

Is "Shift Length" the name of the attribute, or ShiftLength - the same spelling should be used everywhere?|||

Hi Deepak,

Thanks for the reply - I can now extract the shift length successfully, it was a ShiftID level problem!.

Would you have an answer to my earlier unanswered post "strToMember Execution Problem"?

Many thanks

Adrian

|||

Adrian West wrote:

Hi Deepak,

Thanks for the reply - I can now extract the shift length successfully, it was a ShiftID level problem!.

Would you have an answer to my earlier unanswered post "strToMember Execution Problem"?

Many thanks

Adrian

I'm struggling a bit here
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=524766&SiteID=1

I changed mine to this, no luck (doesn't show up on Browser)

CREATE MEMBER CURRENTCUBE.[MEASURES].[% Capacity Sold]

AS [Dim Performances].[Dim Performances].Properties( "Perf Capacity", TYPED),

VISIBLE = 1 ;

What exactly goes into the 2nd [ ] bracket? Does it have to be a hierarchy, or can it be an attribute? Does it have to be "Key"?

How to use information from a dimension in a calculated member

It would be really useful to be able to extract information from an Analysis Services 2005 dimension such as:-

"The number of seconds in the current time dimension member".

This will enable calculated members such as the following to compute a process percent operation time.

Member = [Measures].[Sum of seconds the process was operating] / "No of seconds in the current time dimension member" (eg.Day, Week, Month etc.)

How can I get this information from the dimension for use in a calculated member?

Many thanks

There could be various approaches to this - here's an example for Adventure Works, which computes the number of seconds for the selected Date dimension members, based on counting the number of days (leaf level) which "exist" with the currently selected Date members:

>>

With Member [Measures].[Seconds] as

Count(Existing [Date].[Date].[Date].Members) * 24 * 60 * 60,

FORMAT_STRING = '#,#'

select {[Measures].[Seconds]} on 0

from [Adventure Works]

where {[Date].[Calendar].[Date].&[1],

[Date].[Calendar].[Date].&[46]}

-

Seconds
172,800

>>

But this approach may not work as desired with nested from sub-cube queries:

>>

With Member [Measures].[Seconds] as

Count(Existing [Date].[Date].[Date].Members) * 24 * 60 * 60,

FORMAT_STRING = '#,#'

select {[Measures].[Seconds]} on 0

from

(select {[Date].[Calendar].[Date].&[1],

[Date].[Calendar].[Date].&[46]} on 0

from [Adventure Works])

Seconds
100,051,200

>>

A more tedious approach, which will work in both scenarios above, is to create a separate measure group on the Date dimension table, with a Named Calculation like: Seconds = 24 * 60 * 60. Then a "Seconds" sum measure can be created for this Named Calculation, which returns the seconds spanned by the selected Date members.

|||

Thanks for the suggestions Deepak however what I am trying to do does not directly involve the time dimension.

I have another dimension called Shift which contains information about the process operator shifts. The shift dimension information comes from a SQL table which has ShiftID, Shift Start Date Time, and Shift End Date Time fields. The main process data table links to the shift table using ShiftID.

Using the shift dimension I can now extract from the cube the process run time per operator shift - all works very well so far.

What I now want to do for each of the shifts, is to set up a calculated measure to compute the shift length in seconds based on the shift start and shift end fields in the shift dimension. I can therefore compute the percent run time per shift using this information together with the process run time.

I am very new to MDX so any help would be appreciated.

Thanks in advance.

|||

Add a Named Calculation to the Shift dimension table, and make this an Attribute (its hierarchy doesn't need to be enabled) - the attribute value can be set equal to the key (ie. integer):

ShiftLength: datediff(second, "Shift Start Date Time", "Shift End Date Time")

Then, [Measures].[ShiftLength]: [Shift].[Shift].Properties("ShiftLength", TYPED)

|||

Hi Deepak,

I have tried out your suggestion:-

- Set up the calculated member ShiftLength which works fine
- Added ShiftLength as an attribute to the Shift Dimenson (Property of the key ShiftID)

I can now browse the shift dimension and see the ShiftLength member property which is fine.

I have created a calculated member:-

CREATE MEMBER CURRENTCUBE.[MEASURES].[ShiftLength]

AS [Shift].[Shift ID].Properties( "Shift Length", TYPED),

VISIBLE = 1 ;

However for some reason no values are returned from the cube for this calculated member. What am I doing wrong?

Thanks for your continued help.

|||

A couple of things to consider:

Is "Shift Length" the name of the attribute, or ShiftLength - the same spelling should be used everywhere?|||

Hi Deepak,

Thanks for the reply - I can now extract the shift length successfully, it was a ShiftID level problem!.

Would you have an answer to my earlier unanswered post "strToMember Execution Problem"?

Many thanks

Adrian

|||

Adrian West wrote:

Hi Deepak,

Thanks for the reply - I can now extract the shift length successfully, it was a ShiftID level problem!.

Would you have an answer to my earlier unanswered post "strToMember Execution Problem"?

Many thanks

Adrian

I'm struggling a bit here
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=524766&SiteID=1

I changed mine to this, no luck (doesn't show up on Browser)

CREATE MEMBER CURRENTCUBE.[MEASURES].[% Capacity Sold]

AS [Dim Performances].[Dim Performances].Properties( "Perf Capacity", TYPED),

VISIBLE = 1 ;

What exactly goes into the 2nd [ ] bracket? Does it have to be a hierarchy, or can it be an attribute? Does it have to be "Key"?

how to use Foodmart sample reports?

i'm new to reporting service and would appreciate some helps with the
problem i ran into.
background: sql2k on w2k3 with sp3a. sql analysis service, vs .net
2003. and reporting service.
I set up the distributed installation, sql server, reporting server,
analysis service on the same box, but the report designer and vs .net
2003 are on developer's machine.
After installation and upload of the sample database (AdventureWorks),
all the reports worked except Foodmart Sales report. see error msg:
============== An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'FoodMart 2000'.
(rsErrorOpeningConnection) Get Online Help
Unspecified error
===============
how to make this report works? i've installed the analysis services on
the server, but i didn't see a database for foodmart on the sql server
(i saw AdventureWorks, ReportServer, ReportServerTempDb)
Thank you!Foodmart is the sample database that ships with SQL Server 2000. You should
be able to find the foodmart cube with your original SQL distribution.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"lins" <steve.lin@.powells.com> wrote in message
news:1106169708.806166.137040@.c13g2000cwb.googlegroups.com...
> i'm new to reporting service and would appreciate some helps with the
> problem i ran into.
> background: sql2k on w2k3 with sp3a. sql analysis service, vs .net
> 2003. and reporting service.
> I set up the distributed installation, sql server, reporting server,
> analysis service on the same box, but the report designer and vs .net
> 2003 are on developer's machine.
> After installation and upload of the sample database (AdventureWorks),
> all the reports worked except Foodmart Sales report. see error msg:
> ==============> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'FoodMart 2000'.
> (rsErrorOpeningConnection) Get Online Help
> Unspecified error
> ===============> how to make this report works? i've installed the analysis services on
> the server, but i didn't see a database for foodmart on the sql server
> (i saw AdventureWorks, ReportServer, ReportServerTempDb)
> Thank you!
>|||i saw the foodmart cube in analysis service, but not as a database in
sql server. am i missing something here? can someone give me some step
by step check list to make that reprot works? i searched online help
and microsoft site and found no info how reporting services work with
analysis servcies.
thank you.|||Yes, foodmart is a cube. here's the description of the sample report:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_samplereports_v1_0jlf.asp
here's a description of how to install AS and the foodmart sample database:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/aginstalling_5trn.asp
Once this is done, you'll need to configure the report's datasource to
access the foodmart database (cube). You can do this on the
properties->data sources tab for the report.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"lins" <steve.lin@.powells.com> wrote in message
news:1106248441.279279.304390@.c13g2000cwb.googlegroups.com...
>i saw the foodmart cube in analysis service, but not as a database in
> sql server. am i missing something here? can someone give me some step
> by step check list to make that reprot works? i searched online help
> and microsoft site and found no info how reporting services work with
> analysis servcies.
> thank you.
>|||thank you for the reply. as i said earlier, i'm new to reporting
service. i wonder if someone has worked with the foodmart sample
report before can provide me a sample data soruce connection string.
the current one on my reporting server for the foodmart looks like this
Connection Type: OLE DB
Connection String: Provider=MSOLAP.2;Client Cache Size=25;Data
Source=localhost;Initial Catalog=FoodMart 2000;Auto Synch Period=10000
(but this connection string is not working for me. )
and i'm using Windows NT Integrated Security.
thank you.|||Do you have Analysis Services deployed on your machine?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"lins" <steve.lin@.powells.com> wrote in message
news:1106259008.263757.204280@.z14g2000cwz.googlegroups.com...
> thank you for the reply. as i said earlier, i'm new to reporting
> service. i wonder if someone has worked with the foodmart sample
> report before can provide me a sample data soruce connection string.
> the current one on my reporting server for the foodmart looks like this
> Connection Type: OLE DB
> Connection String: Provider=MSOLAP.2;Client Cache Size=25;Data
> Source=localhost;Initial Catalog=FoodMart 2000;Auto Synch Period=10000
> (but this connection string is not working for me. )
> and i'm using Windows NT Integrated Security.
> thank you.
>

Wednesday, March 7, 2012

How to use combo box for a parameter on reporting services?

I have created a reporting services report based on data elements from an Analysis Services cube. I have selected one of the data element as the parameter on the report. The default for the selection list of the parameter is a drop down box. My users didn't like to go through a long list of values in the drop down box to find a specific value. How can I convert the drop down box to a combo box so that my users can search for a specific value and therefore shorten the selection list.

Any help is greatly appreciated!!!

Mitch

Hello. Combo boxes are not a part of SSRS2000/2005.

Your best choice to simplify parameter search is to build cascading parameters.

Here is a link to an article of how to do this with SSAS-cubes

http://www.databasejournal.com/features/mssql/article.php/3653271

HTH

Thomas Ivarsson

Friday, February 24, 2012

How to use Analysis Services with reporting Services

Hi,
How to use Analysis Services with reporting Services?http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
http://www.google.com/search?hl=en&lr=&q=analysis-services+reporting-services
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Dhar" <Dhar@.discussions.microsoft.com> wrote in message
news:E615D6AD-EB9E-4FBA-B9F1-2CDDF7AE5388@.microsoft.com...
> Hi,
> How to use Analysis Services with reporting Services?

How to use already created Dimensions in SSAS project in new Cube

I have an task in which I have to use already created Analysis Services project for building up new cube. now for building up new cube i need to use some of the dimensions that are already in place. and some i have to create.. Till Data Source View I have almost done. But while cube designing from Data Source View I am facing problem. I am not able to use already present dimensions.

I am using wizard to construct CUBE. now what happens when i create the cube using wizard it automatically creates already present dimensions under new name by appending 1 or 2 etc. I tried the other way by unchecking the already present dimensions but this generates other problem after finishing this way i couldn't see relationships presnt in fact and dimension table as expected by me.

I am new to Analysis Services being my first project i am unable to come out of situation. Somebody has told me by constructing CUBE by not using wizard instead doing it manually will sort out the things... Can anybody provide me any link in which there is explanation how to design cube manually OR solution to my problem

Please mail me at mandipjutla@.hotmail.com

Thanks
Mandip

Hi Mandip,

If you have the dimension already defined in the project all you will need to do is add them to the cube by taking the following steps.

1. Edit the cube that you want to add the dimension to. This OK even if you have created the cube via the wizard.

2. Remove the existing dimension created by the wizard from the cube, by right clicking and choosing delete.

3. Add in the existing dimension that you want by right clicking and choose add.

4. Even if it puts a different name, you can always rename it.

I hope this helps,

David Botzenhart

|||

Hi David,

Thanks for the help.

I have applied the same process as explained by you. But still i can't see the relationship between fact and newly added dimension on Cube's Data Source View.

I have also set up the relation betwwen fact and dimension by going into Dimension Usage tab.

Thanks,

Mandip