how can i add measures and dimensions of a cube of SQL Server's Analysis services 2005 in a DataTable in .NET

MS SQL SERVER

    Sponsored Links

    Next

  • 1. How much free space is required in tempDB?
    I have a Cube with 30 Dimension and it can grow to 75 or more. Last night i tired to process the cube and in storage wizard it had 656 aggregation and 15% performance but It gave to error of tempdb is full and tempdb grew from 8 MB to 25GB and I had just 25GB free space. So I am not sure how much space is required for temdb to grow? Is 100GB or what? If I need 100 GB space is there way to avoid it? Thanks Sameer
  • 2. How to allow normal user (not Administrator) deployment of SSAS Cube?
    Hello, how to allow normal user (not Administrator) deployment of SSAS Cube? It says always that normal user cannot create new objects. Andrey.
  • 3. Incremental Process - why do Dim updates query entire table?
    I am using AS2000 with SP4. I have a cube which has been fully processed. I got the Max(ID) = 27199456 from the fact table and then executed a manual incremental process, giving "ID > 28000000" as the filter expression. This filter excudes all rows, but I was surprised to see that the queries to update the private dimensions did NOT use the filter. So even though there was nothing to be done, the processing still took a couple of minutes. Why don't the dim updates use the filter expression? So now I am considering complicating my DTS further by adding a SQL task to retrieve the Max(ID) from the fact table and comparing to the Max ID of records processed into the cube (stored in SQL after previous processing). If the IDs are the same (i.e. no new events) then completely skip the cube processing task. That should save me those 2 minutes. Is there an easier way? LMcPhee
  • 4. characters in Calculated Members
    Hi Folks, i must display a text information as a measure - i do this via a Member Property iif( [IRISBAU].currentmember.level.name = "ActualPhase", [IRISBAU].currentmember.properties("Freecomment"), "") This works fine, but: The Calculated Member displays only the first 255 Characters form the Member Property..... if i check via a second calculated Member with this Function: Right([Measures].[New Calculated Member 2], 250) ic cann see, that all Characters ar in the calculated member - it is also only a problem to display more than 255 Characters..... Does anybody know a way to format (or anything else) a calculated member to display more than 255 Characters...... THX a lot Dietmar

how can i add measures and dimensions of a cube of SQL Server's Analysis services 2005 in a DataTable in .NET

Postby nikky » Thu, 07 Feb 2008 16:06:03 GMT

Hi

             I want to know that can i add measures and dimension of a
cube to a DataTable through .NET.the connection is made to  OLAP
AnalysisService 2005.And if i can add then how to add it.

Re: how can i add measures and dimensions of a cube of SQL Server's Analysis services 2005 in a DataTable in .NET

Postby Elad » Thu, 28 Feb 2008 04:49:02 GMT

You can use either AdoMd.Net (AdoMdConnection.GetSchemaDataSet) or OleDb 
(OleDbConnection.GetSchemaTable()).

AdoMd.NET can be downloaded at:

 http://www.**--****.com/ 

Elad
 http://www.**--****.com/ 
"BI For Everybody!"








Similar Threads:

1.Calculated Measure in Analysis Services 2005 CUBES


I am trying to create a calculated member with multiple dimensions as
conditions.

Same thing can be acheived by below SQL Script.


SELECT SUM(f.Amt)
FROM Fact f
inner join dimension1 d1 on d1.d1_ID = f.d1_ID
inner join dimension2 d2 on d2.d2_ID = f.d2_ID
inner join dimension3 d3 on d3.d3_ID = f.d3_ID
where d2.Num = 20 and d3.index >=100 and d3.index <=500


Num is a column in d2 table and index is a column in d3 table.


Please advise. 


Thanks, 
Dana

2.Analysis Services 2005 - Impact of having more secured dimensions on OLAP cube performance and size

Hello Gurus,

What I have: one big OLAP (20 million rows) cube with 3 secured
dimensions and 4 unsecured dimensions.
What I want to do is to make one of the unsecured dimensions become
secure.
What I cannot estimate is: How this can:
1) impact the performace of the OLAP cube (retrieving data, processing
cube and dimensions) and
2) impact size of my OLAP cube (in memory and on disk)

Thanks alot

3.Create serverbased and lokale Cubes with .NET an Analysis Services 2005

Hello,

I want to create a Programm, which create in Analysis Services 2005
first a serverbased Cube and then a lokale Cube. I used VS.2005, C#
and the Namespace Microsoft.Analysisservices.

So, I create a Server-Object an conect to the Server, then I create a
Database-Object, a RelationalDataSource-Objekt and ADD it to the
Database-Object. Second I set the ConectionString with
"Provider=SQLNCLI.1;Data Source=HAUPTPC;Integrated
Security=SSPI;Initial Catalog=P21TestDaten" an make a Update() of the
DataSource.

            Server mServer = new Server();
            mServer.Connect("localhost");

            Database mDatabase = new Database(strgName);
            mServer.Databases.Add(mDatabase);
            mDatabase.Update();
            RelationalDataSource mRDataSource = new
RelationalDataSource("Fall", Utils.GetSyntacticallyValidID("Fall",
GetType()));
            mDatabase.DataSources.Add(mRDataSource);

            mRDataSource.ConnectionString = "Provider=SQLNCLI.1;Data
Source=localhost;Integrated Security=SSPI;Initial
Catalog=P21TestDaten";

            mRDataSource.Update();

If I look at the Analysis Services, all things are created. But I
don't know the next step. I start to create a DataSourceView, but I
crashed. If I ignore the DataSourceView and want to create direct the
serverbased Cube, I crashed, too.

Can someboday help me? I searched, but found nothing (wrong
keywords?). Have someone QC-Examples?

4.Adding a dimension into the cube makes the measures blank

I have a dimension called Prodh1 when I add this dimension to the cube
and process and browse the cube the browser does not display the
measures any more all the measure values are displayed as blank. When I
remove the ProdH1 dimension and reprocess the cube and now the measures
are displaying.

I am puzzled why adding this dimension Prodh1 blanks the measures out.

Thanks
Karen

5.Cube reprocess necessary when adding a new dimension not used in existing measure gropus

I have a cube with four measure groups. I am adding a fifth measure group 
which includes a new dimension to the cube (not used in any of the other 
four measure groups.)

From what I've experienced, it is not possible to add that dimension to the 
cube without having to reprocess the existing four measure groups. This 
really doesn't many any sense to me since those four measure groups will not 
be using that new dimensions.

Why does this happen? Any way to get around it?





6. SQL Server 2005 Analysis Services - Aggregating Two Ways in one table/dimension

7. Cube Browser limitation in SQL Server 2005 Analysis Services

8. Creating Local cube Using SQL Server / Analysis Services 2005



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 5 guest