Saturday, April 2, 2022

STDDEV (standard deviation) MDX (calculated members)

STDDEV (standard deviation) MDX (calculated members)

Hi all,

I was wondering if there are any examples in MDX for calculating stddev.

I know there is a function STDDEV that I can use but the scenario below might not work.

Fact table is event based facts.

I have 1 date dimension (date portion only), 1 user dimension, 1 application dimension

there is also a Time dimension (24 records, hour only, 12 AM, 1 AM, etc..)

1. given 2 date ranges (including time), calculate the STDDEV and STDDEV ERR

the formula is:

STDDEV = Square Root (   (Summation of (X - Xavg)^2) / (N-1) )

STDDEV ERR = (Xmax - Xavg) / STDDEV

I was thinking of the following example:

for date range between Date1 and Date2

Count of Events         Time

3                                  8 AM

2                                  9 AM

5                                 10 AM

6                                  11 AM

3                                   12 PM

8                                    1 PM

7                                    2 PM

5                                    3 PM

5                                    4 PM

3                                    5 PM

----------------------------------------

47 events / 10 time intervals = 4.7 Average

STDDEV = SQRT (  ((3 - 4.7)^2 + (2 - 4.7)^2 + (5 - 4.7)^2 + (6 - 4.7) ^2 + (3 - 4.7)^2 +

(8 - 4.7)^2 + (7 - 4.7)^2 + (5 - 4.7)^2 + (5 - 4.7)^2 + (3 - 4.7)^2 ) / (10 - 1) )

 = approximately 1.9

STDDEV ERR = (8 (which is the max) - 4.7 (which is the average) ) divides by STDDEV (which is 1.9)

ATTEMP SOLUTION:

1. I created a Count Measure

2. I created Max(TimeKey) Measure to be used as N in the STDDEV formula above

3. I created a Sum Measure of the above Count Measure in #1

4. so Average = Sum in #3 divides by N in #2

so based on these and the formula

STDDEV = Square Root (   (Summation of (X - Xavg)^2) / (N-1) )

STDDEV ERR = (Xmax - Xavg) / STDDEV

QUESTIONS:

1. how do I get sum of (X - Xavg) ?

2. how do I get Xmax ?

3. is this the right way to do this? any resources would be helpful.

The idea is that the user wants to raise a red flag if the Counts of events (fact records) is more than a certain STDDEV threshold.

thank you

 

 

 

 

 

How to ignore a dimension in MDX?

So my fact table looks like this:

SurveyID ( --> Survey Dimesion)
GroupID( --> Group Dimension)
StatusID ( --> Status Dimension ... e.g. Complete, InProgress, New)
GroupCount (the actual measure)

How would I create a calculated member that would return the "overall" count for a specific group in a survey (e.g. ignore Status dimension) regardless if the user is slicing the data by Status or not?

Thanks again - wgpubs

Reply:

Try this ("ignoring" the status dimension - your exact naming may differ):

CREATE MEMBER CURRENTCUBE.MyCount AS

'([Status].[StatusID].[All StatusID],[Measures].[GroupCount])';


------------------------------------
Reply:
tried this ... but if I include the ResponseStatus dimension in my slicer it still filters on ResponseStatus.

In my slicer I got survey, group and response status ... the kind of report I'm trying to generate in SSRS needs to looks something like this:

Survey      Group      Count      OverallCount


... where Count should use the ResponseStatus dimension (so that users can filter out certain statuses and what not thru a RS parameter) while OverallCount should not.



------------------------------------
Reply:
My suggestion should work, if I understand you correctly. Please post your exact MDX query.

------------------------------------
Reply:
Yah I thought it would too ... but no go.  here is the query:

CREATE MEMBER CURRENTCUBE.[MEASURES].[Overall Group Count]
 AS ([Response Status].[Response Status].[All], [Measures].[Group Count]),
VISIBLE = 1  ;

------------------------------------

How to create an age dimension

Hi

I have a time dimension and i'm wondering how to create a dynamic age dimension on SQL AS 2K. It would be very nive to represent an entity by its age or (age interval ).(The age should increase everyday)

Can anyone help

Regards

VS Express free for good and other fun stuff

A whole bunch of exciting new stuff announced around the Visual Studio Express Editions today.  VS Express is now free for good, not just 1 year (just like SQL Server!).  Also lots of great new content and fun projects to do.

See Dan Fernandez's blog posting at http://blogs.msdn.com/danielfe/archive/2006/04/19/579109.aspx for lots of details.

Best, MJ


Reply:

can i used it for network applications/solutions?

------------------------------------

Teacher Starter Kit: Missing "Microsoft.ReportViewer.Common"

If anyone else is trying this starter kit and getting error messages like:
"The referenced component 'Microsoft.ReportViewer.Common' could not be found"

Then you will need to install this first:
Microsoft Report Viewer Redistributable 2005


New Server Registration to External Database

Hi All,

Quick question ...

Is it possible to add an external server registration using SQL Server Management Studio Express CTP?

Reason being I have been doing some work from home  and need to port the data back to the office who are on SQL 2000. I have a database with my web hosting company and wanted to export the data to the 'live' database so I could import to the office database - any ideas?

I've tried to connect using my login details and I know the live DB is operational as I can connect through my work system. I just can't seem to be able to do it on my system at home.

Any help would be greatly appreciated as it's been a real pain to get stuff transferred. I've so far had to generate SQL script to create the procs and tables for when I get to work - the proper down side is that I lose the content of the tables which not much right now but will be loads soon!

Many Thanks

 

--

 

I have just dicovered that the CTP management studio will not connect to SQL 7 - is there any alternative or does the new version compensate for this?


Reply:

There is now way to connect to SQL Server 7 in Management Studio(Express Edition or otherwise).

If you want to move the data from 2005 to 2000/7 your best bet is BCP or DTS/SSIS


------------------------------------
Reply:

I'm afraid you will have to excuse my ignorance here as I am not a terribly experienced user of SQL Server. I've only be developing for the last year and a half and have always been able to use Enterprise Manager at work as everything is SQL 2000. This fortunately also connects to SQL 7 but SQL 2005 Express rather conveniently appears to have no easy backward compatibility.

So - what is BCP, DTS/SSIS and where might I find them on SQL 2005 Management Studio CTP - if that's where I should be looking?

So far, in order to migrate the structure of a database from 2005 to 2000 I have had to generate SQL scripts to create the tables and procs. A bit of a nightmare as I lose all data this way. Will the above solution resolve this issue?

Many Thanks


------------------------------------
Reply:

First step is to upgrade from the CTP to the production version...

 

If you have the scripts then you now need the data, there are 2 choices, use whats called a linked server(Books On Line can help you try this out) or you can generate text files using BCP. DTS/SSIS is not available if you are pushing the data from a 2005 server, however you could try pulling it from the 2005 to the 7 server on the 7 server, ie have DTS in 7.0 connect to 2005.

 

BTW in your statement above you are mixing up the tools and the products...

EM and QA come with SQL 7 and 2000, the 2000 versions work with 7 and 2000.

SSMS comes with SQL 2005, it works with 2005 and 2000.

Once you have a database in a higher version (2000 or 2005) there is no easy way to go back to an older version (7 or 2000)


------------------------------------

Time series calculation

Hi,

is this "best practice" (adding a separate dimension for time series calculation, like described here: http://blogs.msdn.com/bi_systems/articles/187639.aspx) still valid for SQL 2005? Or is there any better solution for that? I simply don't want to write one MDX per time series calculation (YTD, MTD, ...) per measure...

Thanks,


Reply:

Hi Thomas,

This SQL Server Magazine article discusses the approach to Time Intelligence taken in the AS 2005 Business Intelligence Wizard:

http://www.sqlmag.com/Article/ArticleID/46157/Analysis_Services_2005_Brings_You_Automated_Time_Intelligence.html

>>

June 2005]

  • Analysis Services 2005 Brings You Automated Time Intelligence
  • The Business Intelligence Wizard makes time analysis a snap
  • By:  Mosha Pasumansky , Robert Zare

    • ...

    First, the wizard creates a new named calculation within the time-dimension table in the Data Source View (DSV). (A named calculation is a calculated column that resides purely within the DSV; no changes are written to the underlying data source.) The named calculation serves as the source for a calculated attribute hierarchy. The calculated attribute will contain a single noncalculated value (based on the named calculation) in addition to all the user-selected calculations. The wizard uses a constant as the basis for the calculation so that it applies to all rows in the dimension table. This column returns the natural values over time, both as the default value and to allow comparison to the calculated views.

    Next, after creating the column, the wizard creates a dimension attribute that points to the calculated column. Because this attribute's hierarchy primarily contains calculations, we can't logically aggregate these members. To mark a hierarchy as being nonadditive, we disable the system-generated All level. The IsAggregatable property of a dimension attribute controls the existence of the All level; because we don't want to aggregate the members in the calculated hierarchy, we set it to False.

    ...

    >>

     

    Hopefully, you have SP1, because some Time Intelligence Wizard issues may be fixed there:

    http://spaces.msn.com/cwebbbi/blog/cns!7B84B0F2C239489A!379.entry

    >>

    Some Time Intelligence Wizard-generated calculations don't work
    This is an issue I came across a while ago during beta testing, but now I know it is present in the RTM version and because I know this is going to be a major cause for confusion, I thought I'd blog about it. Put simply, the MDX for certain calculations generated by the Time Intelligence Wizard in BIDS doesn't work.
    ...
    >>


    ------------------------------------

    OLAP Survey 6

    OLAP Survey is open for the participants again for the sixth year. OLAP Survey is conducted by Nigel Pendse - probably the most respected and influential analyst in the OLAP industry. Microsoft studies the detailed results of this survey every year (although it doesn't publish PRs about the survey's results - which is a shame, since Microsoft scores very well in this survey every year). This year, though, is especially important to us, since it will be the first time when we will be able to study the results for Analysis Services 2005. AS2005 has been on the market for more then half year now, we already shipped SP1 last month (and some organizations won't start using a product until first service pack is out). During the five years that AS2000 was on the market, we learned a lot about its strengths and weaknesses, but we really need the feedback about AS2005 from the real world. What works well, what doesn't work well, what are the pain points. It is a perfect time to collect this feedback, since next year it might be too late to incorporate into the next version, but now the plans for the next version are still very flexible. So, please, go ahead and fill it, and tell us honestly how it works for you. We are always pleased to see positive feedback, but it is the negative feedback which is the most important, because it tells us what to improve. Below is the official invitation for the survey:

    We would very much welcome your participation in The OLAP Survey 6. This is the largest independent survey of business intelligence/OLAP users worldwide. The Survey will obtain input from a large number of users to better understand their buying decisions, the implementation cycle and the business success achieved. Both business and technical respondents are welcome. The OLAP Survey is strictly independent. While Microsoft and other vendors assist by inviting users to participate in the Survey, the vendors do not sponsor the survey, nor influence the questionnaire design or survey results. As a participant, you will not only have the opportunity to ensure your experiences are included in the analyses, but you will also receive a summary of the results from the full survey. You will also have a chance of winning one of ten $50 Amazon vouchers. Click here to complete the survey on-line: http://www.survey.com/olap6sur10.html . The German version of survey is here: http://www.survey.com/olap6survey6.html

    Mosha Pasumansky (http://www.mosha.com/msolap)

    Update cube with ADOMD and SSAS 2005 : CellSet value is not refreshed

    Hi,

    I'm trying to port an existing piece of VB6 code that works fine on SSAS2000 onto SSAS2005.
    This code uses ADOMD to perform an MDX select statement by opening an ADOMD.CellSet object.
    It then performs an Update Cube statement on the same data and then displays the CellSet updated value again.

    Both Select and Update fonctions work fine except that the value in the cellset is not updated. When I close and reopen the connection, I can control that the cube has been correctly updated - the transaction commit works fine - the value is updated but the value in the cellset is not updated.

    I enclose here a piece of sample close which illustrates.

    Is there any way to get this corrected (eg by setting some connection property) or is this a (un)kown issue/limitation ?

    Many thanks in advance
    Rgds,
    Francois

    ---------------------------------------------------------------------------------------------

    ' Form contains the folowing components:
    ' Label : Label1
    ' Button cmdLoad : performs the Select statement
    ' TextBox txtNew : use to type in the new value
    ' Button cmsSave : performs the Update cube

    Private m_CellSet_Cube      As ADOMD.Cellset
    Private m_ConMdx            As ADODB.Connection
    Private m_ReportQuery       As String


    Private Sub cmdLoad_Click()

        On Error GoTo gest_err
       
        Label1.Caption = "Initializing"
        DoEvents
        m_ReportQuery = "..."
       
       
        Set m_ConMdx = New Connection
       
        m_ConMdx.ConnectionString = "Provider=MSOLAP;Data Source=spantik;"
        m_ConMdx.Open
        m_ConMdx.DefaultDatabase = "Analysis Services Project1" 'm_DatabaseName
       
        Set m_CellSet_Cube = New ADOMD.Cellset
        Set m_CellSet_Cube.ActiveConnection = m_ConMdx
       
        Label1.Caption = "Executing query"
        DoEvents
       
        m_CellSet_Cube.Open m_ReportQuery, m_ConMdx
       
        Label1.Caption = CStr(m_CellSet_Cube(0).Value)
        DoEvents
       
        Exit Sub

    gest_err:
       
        Label1.Caption = "Query Nok"

    End Sub


    Private Sub cmdUpdate_Click()
       
        Dim Updatecommand As ADODB.Command
        Dim cs As ADOMD.Cellset
        Dim MdxString As String
       
        Label1.Caption = "Performing update"
       
        Set Updatecommand = New ADODB.Command

        MdxString = "Update Cube ... USE_EQUAL_ALLOCATION"
       
        Set Updatecommand.ActiveConnection = m_CellSet_Cube.ActiveConnection
        Updatecommand.CommandText = MdxString
        Updatecommand.ActiveConnection.BeginTrans
        Updatecommand.Execute
        Updatecommand.ActiveConnection.CommitTrans
        Label1.Caption = "updated local value is :" &
    CStr(m_CellSet_Cube(0).Value)
       
    End Sub

     


    Reply:
    Hi,

    Is there any chance to get an answer on this or is ADOMD.Net the one and only answer ?

    Thanks & regards,
    Francois

    ------------------------------------

    Problem in deployment on SSAS 64 bit with Oracle 10g 32 bit client (as datasource)

    Hi,

    I installed SQL Server 2005 64 bit and have Oracle 10g 32 bit client,
    I am creating a cube based on Oracle datasource by connecting Oracle 10g 32bit client.

    when I build and process cube it Done successfully but when I deploye it to server then it gives following error.

    Error 1 Errors in the high-level relational engine. The following exception
    occurred while the managed IDbConnection interface was being used: Attempt
    to load Oracle client libraries threw BadImageFormatException. This problem
    will occur when running in 64 bit mode with the 32 bit Oracle client
    components installed.. 0 0

    Error 2 Errors in the high-level relational engine. A connection could not
    be made to the data source with the DataSourceID of 'Oracle DW Call Detail',
    Name of 'Oracle DW Call Detail'. 0 0

    any suggestion regarding this ?

     


    Reply:

    Hi Kawish,

     

    Did you solve this prolem?  I am having the same problemss as you describe here.

     

    look forward to hearing from you..


    ------------------------------------

    Business Object Integration with AS2005 Cubes

    Hi All,

    I currently have a microsoft client who wants to use Business Objects (latest version) with Analysis Services 2005 but does not know if Business Objects would be able to connect to AS2005.  If you know of any information, that would help a great deal.

    thank you

    PS: of course, I have recommended reporting services and proclarity and the client is also looking into it.

     

    Unable to connect to Analysis Services as a client

    Hi,

    I got SQL SERVER 2005 SP1 installed on a server and is running fine. I've installed BI studio on a client computer and I can access the database engine. On the client computer, while deloying my cube I get the following error :

    the project could not be deployed on the server "server_name\instance_name" due to connectivity problems. Verify that the server is running

    I've checked the project properties and in the deployment section I have the right server : "server_name\instance_name" and the right database : "database_name".

    I can access the server since i've created the datasource using the sqlclient provider.

    On the server all services are green (sql browser also) and all tcp ports are opened.

    Perhaps it is a configuration problem of analysis services on the server !!

    Thanks for an answer.

    Reply:

    Hi,

    You mentioned that the server is started because you created the datasource using the sqlclient provider. The datasource will point to the relational SQL Server (out of which the AS2005 cubes and dimensions will be processed), while your BI project needs to be deployed to the Analysis Services server. "server_name\instance_name" needs to refer to the AS2005 server ("SQL Server Analysis Services" service), not to the relational SQL Server.

    I hope this helps,

    Adrian Dumitrascu.


    ------------------------------------
    Reply:

    Thanks Adrian for your answer.

    Where in the BI project should I spécify to refer to Analysis Services and not to the SQL relational server?

    In the project properties and in the deployment section I have the right server : "server_name\instance_name". Should we specify to point to analysis services in the datasource (in the connection string)?

    Thanks


    ------------------------------------
    Reply:

    In the BI project properties (right click on project node -> Properties), in the Deployment tab there are the 'Server' and 'Database' settings. Those are for the AS2005.

    The connection string for the DataSource is for the relational SQL Server.

    Adrian Dumitrascu.


    ------------------------------------
    Reply:
    Hi Adrian,

    These are my settings :

    In the project properties in the deloyment tab :
    server : server_name\instance_name
    database : database_name

    Datasource connection string : SQL Native Client
    connection test : OK

    After building my cube, I get the following error while deploying it :
    the project could not be deployed on the server "server_name\instance_name" due to the following connectivity problems : A connection cannot be made. Ensure that the server is running...

    It seems that I can't connect to AS2005 on the server as a client. I'm trying to connect as administrator.

    I've check all services and tcp/ip connections and the firewall is off on the server and I still can't solve the problem. Any ideas?

    ------------------------------------
    Reply:

    I've tried to connect to Analysis Services on the server using SQL Server Management Studio as a client, I have the following errors :

    A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

    Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

    An existing connection was forcibly closed by the remote host (System)

    The SQL Server 2005 is installed on the local network and is running on an XP SP2 32bits PC, and the client is a windows 2000 SP4 PC.

    I wonder if the server should not be a Windows 2003 for appropriate server/client applications?


    ------------------------------------
    Reply:

    This error suggests that you don't have permissions with the user connecting from the client machine.

    On the client machine, run the SQL Management Studio under a user that is administrator on the server machine (we don't need it to be a full admin on the server machine, only AS2005 admin, but we'll try this as a test).

    If the connection succeeds, right click on the AS2005 server item, use 'Properties', go to the 'Security' tab and add your initial user (for which the connection failed) as an AS2005 administrator. Then you should be able to connect fine. You can also lower the rights for the user, to make it just database(s) administrator, instead of full server administrator.

    Adrian Dumitrascu.


    ------------------------------------
    Reply:

    Adrian,

    I found out that on the server, I cannot log on to analysis services using SQL Management Studio as administrator. The authentification, user and password are greyed. I can only log on using the windows authentification mode and with my windows user name.

    When I browse for network servers, still with SQL Management Studio, I have only the database engine as net work server on both server and client.

    When I browse for local servers on the server, all the servers are present :

    • database engine
    • analysis services
    • reporting services
    • integration services

    In the SQL Server Configuration Manager, all services are configured as "Network Service".

    How to make available the other 3 services on the network (SSAS, SSRS, SSIS).

    The server's firewall is set off for tests.

    Thanks Adrian.


    ------------------------------------
    Reply:

    Hi:

    How I can conecting to analysis services from BI Studio with sql authtentication?


    ------------------------------------
    Reply:

    Basic authentication (with user name and password) is only supported for http connections (where the user name and password are passed to IIS for verification and impersonation).

    For native connections (native connections = the regular ones, non-http, non-local cubes) only integrated authentication works. That's why the user name and password are greyed out in the connect dialog from SQL Management Studio.

    Adrian Dumitrascu.


    ------------------------------------
    Reply:

    1. If the AS2005 server is on the same machine where you are opening SQL Management Studio, then login (to Windows) with an Windows local administrator account. Then open SQL Management Studio and connect to AS2005. Integrated authentication is done, so you will have AS2005 admin rights. Then right click on the AS2005 item, use 'Properties' and go to the 'Security' tab. Add your normal user name as an AS2005 admin. Later you can lower this permission to make your user just a database admin, but for the moment we'll go with the full server admin to see if this will work. Then logout from Windows and loging with your user. You should be able to connect now to AS2005. Please note that you can also run SQL Management Studio under a different user (to skip the Windows loging-logout parts).

    2. If the AS2005 server is on machine A and SQL Management Studio is on different machine B, then you need to loging on machine B under an account who is admin on machine A (or run SQL Management Studio under that account).

     

    Adrian Dumitrascu.


    ------------------------------------
    Reply:

    Hi Adrian,

    I think the problem is with win XP and SQL SERVER 2005 Enterprise Edition. It seems that we cannot connect clients to a SQL SERVER having win XP as OS. We need a server OS (win2000 server SP4 or win 2003 server)

    Do you confirm that??

    Thanks


    ------------------------------------
    Reply:

    No, Windows XP Professional is supported. (I use it all the time to connect to AS2005) The problem is caused by something else. The AS2005 server machine and the client machine are both on the same domain ? What I suggested on the previous messages didn't work ? (with logging in on the client machine with an user who is AS2005 admin)

    Can you connect to the AS2005 machine from any other machine ? Can you connect to it locally ? When connecting, please try SQL Management Studio and either one of MDX Sample App if you have it (from AS2000), Excell or the data link dialog (.udl file)

    Adrian Dumitrascu


    ------------------------------------
    Reply:

    Well Adrian I got my OS changed to WIN 2000 Server SP4 and now I can connect clients using either SQL Management Studio and BI studio.

    I've tried with XP to connect clients using the AS2005 admin logon, with no results. The machines are on the same domain.

    Now it is working fine with WIN 2000 Server SP4. I don't unserstand, normally it should also work under an XP OS!

    Thanks a lot Adrian


    ------------------------------------
    Reply:

    Well Adrian I got my OS changed to WIN 2000 Server SP4 and now I can connect clients using either SQL Management Studio or BI studio.

    I've tried with XP to connect clients using the AS2005 admin logon, with no results. The machines are on the same domain.

    Now it's working fine with WIN 2000 Server SP4. I don't unserstand, normally it should also work under an XP OS!

    Thanks a lot for your help Adrian


    ------------------------------------

    ใช้msn

    เข้าmsnไม่ได้ ช่วยแนะนำด้วย

    Reply:
    This group operates in english, Could you please use a english character set that everybody can have a look at your problem ?

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

    ------------------------------------

    XML as Data Source for Reporting Services

     

    XML as Data Source for Reporting Services

     

    Reporting Services Express Edition cannot accept XML as DataSource.

     

    XML is a great technology, and it does not look like a "big deal" for Microsoft to let developers use XML as the DataSource for the Reporting, even in Express Edition

     

    How to convince Microsoft to revoke this limitation?

     

    Thank you very much for attention.

    Poll: Followup --> How often do you reboot your server ?

    Hi everybody,

    as a followup to the latest post of Louis I created a poll where you an quickly share your experiences with rebooting your server.

    The poll can be reached under: http://www.sqlserver2005.de/Polls

    Feel free to enter any poll wishes under the feedback site, I will consider to publish them there.

    -Jens Suessmeyer

    ---
    http://www.sqlserver2005.de
    ---

    Reply:
    First thanks to anyone participating in the survey on my site about "Reasons and how often you reboot your server".

    If you are interested in, the results can be viewed here http://www.sqlserver2005.de/Polls/Results/Poll1.pdf.

    Have fun, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

    ------------------------------------

    Please tell me you are joking - All member multivalue parameter

    In 2005 SP1, there is no longer an automatic <Select All> option for multivalued parameters.  You now need to modify the dataset providing the values for the prompt and modify the dataset containing the parameter.  This makes no sense!  I am so confused.  It was working fine.  Why did you have to go and mess with it?  If you want to add value somewhere, try making the width of the drop down box for multi value parameters resize to the text in the box, or at least make the width configurable.  I am not accepting any multi dimensional data source performance excuses either.  Rediculous.

    Reply:

     

    I agree 100%.

    The worst part is that I cannot uninstall SP1 by itself.


    ------------------------------------

    "SQL Everywhere" is a Sybase trademark

    It's all well and good that Microsoft has finally entered the well-established mobile database market (the market that iAnywhere Solution's SQL Anywhere product current *owns* by a wide margin). However, it should be noted that "SQL Everywhere" is a Sybase trademark. For confirmation of this fact, see http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.mro12.6.mro126ig/html/mro126ig/legal.htm

    For confirmation of the fact that SQL Anywhere owns the mobile database market, note that it is the database of choice for the 500,000 mobile devices that will be used in the 2010 US Census; see http://www.internetadsales.com/modules/news/article.php?storyid=7347

    Breck


    Reply:

    The full name of the new mobile db is SQL Server Everywhere Edition, and I don't see that in the list you're linking.

    Plus, wouldn't you think that a company like Microsoft has done some research before they decide on their product names?


    ------------------------------------
    Reply:

    "Plus, wouldn't you think that a company like Microsoft has done some research before they decide on their product names?"

    http://seattletimes.nwsource.com/html/businesstechnology/2002397450_microvista23.html

    By naming the next version of Windows "Vista," Microsoft may have stepped on the toes of another software company just down the road in Redmond.

    So, no, or:  When an 800-lb gorilla has got to go, he doesn't ask where's the restroom, he just goes!

    Whois vista.com?

    Registrant:
       CommunityIQ
       11241 Willows Road
       Redmond, WA 98052
       US

       Registrar: DOMAINBANK
       Domain Name: VISTA.COM
          Created on: 02-NOV-94
          Expires on: 01-NOV-14
          Last Updated on: 27-OCT-05

       Administrative, Technical Contact:
          Admin, Domain  ***@VISTA.COM
          vista.com
          11241 Willows Road
          Redmond, WA  98052
          US
          3609208478

     

    'She said the company filed for trademark protection of the words "Windows" and "Vista" used together. ..."The name Vista is commonly used by a variety of companies in a variety of industries," she said. "We are only using the word Vista paired with our trademark Windows so the two together - 'Windows Vista' - ...

    If that's MS's stance, then it should have no problem with "Linux Windows".  After all,
    Windows is used by a variety of ... (yada-yada-yada).



    ------------------------------------

    Connection latency

    It seems that connection latency information is not saved when you perform a file/save.

    Reply:
    SCCP does not save simulation results out as part of the system architecture file - you will have to rerun the simulation when you open the the file to regenerate the results.

    If you want to persist simulation results (both utlization and latency), use the Export to Excel functionality under the File menu.

    ------------------------------------

    Enhancement: SSIS Designer

    Not quite sure if this is the right place for this comment...

    While using SSIS Designer came across a DUE where the package was setup to:

    1. SEQ1 - Truncate staging tables
    2. SEQ2 - Load staging tables (sequence container had been setup to hold multiple data flows)

    For some reason one data flow was run before the truncate table sequence.

    Looking in the designer it appeared that the dataflow was a member of SEQ2 but looking at the Package Explorer it was outside the sequence container.

    It would be good to have some visible indicator  to show that a task is a member/not a member of a container

    John.


    Reply:

    You can collapse the container thereby hiding everything that's in it. Everything not in it will still be displayed.

    -Jamie

     


    ------------------------------------
    Reply:

    Thanks Jamie, I agree that the container could be collapsed (and the user could also check the Package Explorer... ) - just thinking that the simplest way to avoid this kind of DUE is to have some visible indicator.

     


    ------------------------------------
    Reply:

    Well, implicitly every task/container is a child of another container (http://blogs.conchango.com/jamiethomson/archive/2004/12/13/445.aspx). So, at what point would you draw the line and say "Well its a child of containerA but not containerB, so let's indicate that". I fear its a bit unworkable.

    -Jamie

     


    ------------------------------------

    How to address hierarchies with different # of members in lowest level

    I have a cube with 2 hierarchies for Geography dimension

    1) Standard Hierarchy: Levels (ALL-> Group -> Division -> Region -> Country)

    2) Custom Hierarchy: Levels (ALL -> Country)

    The lowest level is the same in both hierarchies (COUNTRY), but I have different # of Countries for each hierarchy.

    I will have 3 possibilities for the Country Level:

    1) Countries that are in both hierarchies

    2) Countries that should be only in Standard Hierarchy

    3) Countries that should be only in Custom Hierarchy

    Right now, Analysis Services 2005 is creating a "Unknown" parent for the countries that don't have parent and adding them up to the "ALL" level.

    I am aware that I could hide the "Unknown" members, but the level "ALL" still aggregates the data.

    For example:

                                                      Standard Hier             Custom Hier

    Ctry A                                          100                                 100

    Ctry B                                          100                                 100

    Ctry C                                          50                                     

    Ctry D                                                                                100

    Ctry E                                                                                100

    ALL LEVEL (Desired Resuts)           250                                 400

    ALL LEVEL (Current Results)          450                                 450

    Right now I'm getting the same value for both hierarchies (ALL Level), and i would like to have different totals, depending on the hierarchy.

    Any help would be appreciated.

     

    at No comments:

    denying read rights to a dimension

    denying read rights to a dimension

    Hi,

    When you give read rights to a cube then the dimension gets read rights by default. Is there a way by which you can grant read rights to certain dimensions of that cube and deny the read rights to certain dimensions of that cube?

    thanx.


    Reply:

    In AS 2005, just create a new Role, and select what the users belonging to that role can see in the Dimension Data tab. If you select the "Deselect All Members" option, then the users of the role won't be able to see any data of that dimension.

    In AS 2000, you have to add the dimension to the restricted dimension list when editing the proper role.

    Hope this help,

    Santi

     


    ------------------------------------
    Reply:

    Thanx. But then in that case I can still see the dimension. However if I dont want to show any of the attributes of a dimension, is it possible to hide the dimension completely..

     

     


    ------------------------------------

    XQuery Functions Tutorial

    Dear SQL Server XML Fans

    There's a new tutorial on how to write XQuery functions written by Dr. Michael Kay. (You can use XQuery functions in both SQL Server 2000 and SQL Server 2005 using 3rd party components like DataDirect XQuery). It's the 4th in a series of XQuery tutorials and covers these topics:

  • A simple XQuery function example
  • The function name, arguments, body and result type 
  • Modules and Schemas
  • Documenting Functions
  • Using Functions to Mask Schema Complexity
  • Writing Recursive Queries

    • Sincerely,
    The Stylus Studio Team

    Overlap overload, even though I think I love this thing.

    SQL 2005 Dev, IIS 5.1, Win XP Pro, .Net Framework 2.0, IE 6

    I'm a big MS Access Reporter, now importing reports to SQL Server. When reports are imported from Access, textboxes and labels are not imported at size but rather at size + .1 in. width and height. This is a drag as it causes object overlap errors when built, and total chaos when rendered. (Good luck if you use mozilla!)

    Hello Product team! I love this thing. I will keep using it. But whether reports are imported from Access or not, the rendering engine should do something intelligent with overlapping output. As it is, overlapping output throws every object on the page off grid. This is perhaps the limitation of XML and tables?

    Keep on coding.

    Column Total

    Hi,

    How can I get the sum of a calculated member in office pivot table. Here is the example

    I created a calculated member using

    CREATE MEMBER CURRENTCUBE.[MEASURES].PerDay AS ( [Measures].[Total Amount]/[Measures].[Days count]) ;

    I display this measure in office pivot table. But the problem is the grand total row is coming row. the values displayed is a divison of total amout / days count. How can I prevent this from happing.

     

    Any suggestions.

    Many thanks,

    Yash

     

     

    After Transaction Log Grows, it won't shrink.

    The other day I had someone truncate an extremely large transaction log (100GB) but it wouldn't return the space to the OS, not even after a backup and restore operation. There's an interesting bit of trivia around shrinking this file. When the log file is truncated, you may not see all of the space returned to the OS. The reason is the way the data might be spread. Here's the way we think data looks in the log file:

     

    <BeginFile>xxxxxxxx-----------------------------------------------<EndFile>

     

    So when you truncate it and it gets another couple of transactions, it should do this:

     

    <BeginFile>xx<EndFile>

     

    But in fact it might look more like this:

     

    <BeginFile>xx----xx----------------xxxx------------------------xxx<EndFile>

     

    So if you truncate the entries and a couple are left it really looks like this:

     

    <BeginFile>x-----------------------------------------------------x<EndFile>

     

    So when you shrink it, you don't gain any space back because of this file marking. So what do you do?

     

    There are two ways to shrink a large log file, both of which are a bit painful, and not always practical in production. The first is to write enough transactions into the log to "bump" the data all the way to the end. Since that makes it contiguous, when you truncate it you'll get the shrink you're looking for – probably. You can do this by creating a table, adding thousands or millions of rows to it, and then deleting them and the table.  Of course this slows down a production system while you do it, and it's difficult to figure the math.

     

    The other way is more problematic in a production system, but works every time. Take a full backup of the database. Follow the process to "detach" the database as described in Books Online. Find the transaction log file for that database (and only that database) and delete it. Then, "attach" the database. The system will automatically build a new, clean log file. Obviously, there are a lot of places you can be careless here, so I recommend this process only for extreme cases.

     


    Reply:

    Hi,

    have a look here:

    http://www.aspfaq.com/show.asp?id=2471

     

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

     


    ------------------------------------
    Reply:
    Good info - but you'll find that the DBCC shrink commands won't work with the TL as I mentioned. It's less a question than some real-world experience -  but thanks for the links! I think they will help people to understand how the logs and files are used.

    ------------------------------------

    Welcome!

    Welcome to the Windows Server "Longhorn" Server Core Discussion Forum!  This is the new home for all Server Core discussions related to Windows Server "Longhorn" and do not fit in any of the other specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team.  We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

    Welcome!

    Welcome to the Windows Server "Longhorn" File Security Discussion Forum!  This is the new home for all security discussions related to Windows Server "Longhorn" and do not fit in any of the other specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team.  We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

    Welcome!

    Welcome to the Windows Server "Longhorn" Terminal Services Discussion Forum!  This is the new home for all Terminal Services discussions related to Windows Server "Longhorn" and do not fit in any of the other specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team.  We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

    Welcome!

    Welcome to the Windows Server "Longhorn" Setup & Deployment Discussion Forum!  This is the new home for all setup and deployment discussions related to Windows Server "Longhorn" and do not fit in any of the other specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team.  We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

    Welcome!

    Welcome to the Windows Server "Longhorn" Platform Networking Discussion Forum!  This is the new home for all networking discussions related to Windows Server "Longhorn" and do not fit in any of the other specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team.  We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

    Welcome!

    Welcome to the Windows Server "Longhorn" Network Access Protection Discussion Forum!  This is the new home for all Network Access Protection discussions related to Windows Server "Longhorn" and do not fit in any of the other specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team.  We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

     

    Welcome!

    Welcome to the Windows Server "Longhorn" Management Discussion Forum!  This is the new home for all system management discussions related to Windows Server "Longhorn" and do not fit in any of the other specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team.  We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

    Welcome!

    Welcome to the Windows Server "Longhorn" Migration Discussion Forum!  This is the new home for all discussions relating to migrating to Windows Server "Longhorn" and do not fit in any of the other specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team. We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

    Welcome!

    Welcome to the Windows Server "Longhorn" File Services and Storage Discussion Forum!  This is the new home for all file system services and storage functionality discussions related to Windows Server "Longhorn" and do not fit in any of the other specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team.  We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

    Welcome!

    Welcome to the Windows Server "Longhorn" General Discussion Forum!  This is the new home for all general discussions related to Windows Server "Longhorn" and do not fit in any of the specialized forums. Our aim is to make this a collaborative forum, and that it will be driven by the community more than the team.  We want to hear from you and value your experience!

     

    One of the goals of this forum is to provide quality information and reduce the amount of noise.  To achieve this, some off-topic posts may be removed, or moved to more appropriate forums. If one of your posts is moved – don't be alarmed – we're trying to get the most appropriate answer in the shortest timeframe. Another key goal is answer questions whenever we can, and attempt to point you to the appropriate resources when we can't. While we cannot commit to answering everything because of development cycles, we will do our best to get you the information as soon as we can.

    In the spirit of fair exchange, for the information we'll be providing to you, this is what we would like to see in return:

    • Read it: Read regularly. You can read the forums using any RSS reader (although you can't reply). Look for the small orange XML button near the bottom of the page.
    • Search it: Search before you post – you may find that what you are looking for has already be raised by somebody else.
    • Mark it: If a post helps you out, mark it as helpful so that it can rise to the top of searches.  Chances are other people are looking for the same thing. If someone answers your question, mark the response as an answer. If there are multiple helpful responses, mark all of them as answers.
    • Answer it: If someone asks a question that you know the answer to, post the answer! It doesn't have to be definitive; pointing someone in the right direction can be good enough.

    Thanks, and we look forward to hearing from you!

     

    Julius Sinkevicius, Windows Server

    Error 1 Exception of type 'System.OutOfMemoryException' was thrown.

    The Error 1 Exception of type 'System.OutOfMemoryException' was thrown.

    STRIKES BACK!

    I have had two other postings in the past few weeks on the error in various forms that state:

    'System.OutOfMemoryException'  was thrown.

    This error had apeared on trying to use the migrationwizard.exe, loading /3GB, as well as after breaking the script up into smaller chunks.  You name it, we have tried it (that we know of).  We are now back to the error 'System.OutOfMemoryException'  was thrown once again.  Additionally, I was able to build the dimensions without error and now THAT is failing with the following error:

    Errors and Warnings from Response
     Memory error: Allocation failure : Not enough storage is available to process this command. .
     Errors in the metadata manager. An error occurred when loading the AggregationDesign aggregation design, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\XXXXXXXX.1.db\TA.0.cub\TA.0.det\AggregationDesign.0.agg.xml'.

    XXXXX- replaced the real file names.

    The Memory usage was @ 3.59 GB when it "rolled-back" on a rather large cube.  One should be able to process cubes and dimensions as part of daily maintenenace as that is how it is done every day on the production SQL 2000 OLAP with no issues. 

    We are down to just a few more FACT cubes.  In order to get these created we imported the database into BI Studio.  That is as far as it can go at this time.  Trying the build and deploy the BI solution results in further negative results.  3.59 GB usage seems to be the kill-point for BI Studio 2005.  It loads 3.58 GB while importing and then throws the following error trying to deploy the solution directly back into the database we had just imported to:

    Error 1 Exception of type 'System.OutOfMemoryException' was thrown.

    Please see previous postings for a history of this behavior:

    http://forums.microsoft.com/forums/ShowPost.aspx?PostID=385617&SiteID=1

    http://forums.microsoft.com/forums/ShowPost.aspx?PostID=385633&SiteID=1

    We are so very close to getting this POC completed.  We have only these three FACT tables remaining and we are on the very edge, it seems, to even getting the SSAS 2005 DB to even load.  There is nothing else lodaed on the server at all at this time.  We have done NO load-testing or comparitive testing as of yet because of the lack of syncronicity.

    Any help is welcome.

     

     

     

    Report Services

    Configuring sql services is a nightmare. Why? it seems like the tools to configure it are quirky and don't work as advertise. Anways, I've spent the last two weeks trying to set up remote reporting.

    The following list are a few issues I ran into and what I did to get around them. Hope this helps.

    Tip: If possible, don't every mess with the report server virtual directories (like recreating them), you'll end up with a permissions nightmare.

    Issue: Report Builder wasn't launching (clicked on the link but nothing happen)

    solution    : In turn out to be some Internet explorer setting. I ended up resetting IE to all of it's defaults, which fixed the problem. But I still haven't figure out which setting breaks it.

    Issue: Reports not running in report builder. Get the error "Cannot create a connection to data source 'dataSource1'".

    solution: If you're not using windows integrated security
    try creating the data source (to your report model) using the SQL reporting services web app (http://<localhost>/Reports/Pages/Folder.aspx), instead of creating the datasource in the report designer (which is quirky). Just click the "New Data Source" link and make sure you select the "Credentials stored securely in the report server" option, entering the user name and password of the role you specified of the remote database you using for the reports.

    If you are using windows integrated security
    Windows Integrated Security only works if your domain has Kerberos-delegation enabled - otherwise you will need to store credentials on the report server (more details: http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx)


    Excel Pivot Table and Time Dimension

    I'm using the OLEDB Provider for Analysis Services 9.0 in Excel 2003 to get to my OLAP cubes in SQL Server 2005 Standard SP1.  When I use Time as a Page filter in an Excel Pivot table, the dropdown looks like this (May_2006 is the default period):

     

    -2006
         -Qtr2_2006

               +May_2006

               +Apr_2006

               +Jun_2006

         +Qtr1_2006

         +Qtr3_2006

         +Qtr4_2006

    +2004

    +2005

     

    I checked the field settings in Excel and it is using the data source order option.   When I browse the dimension, the Time members are shown in chronological order.  I've concluded that this behavior is a result of setting the default month in the Time dimension.  Anyone know if this is simply the way it is when working with a defaulted Time dimension in Excel?


    Reply:
    Moving to SQL Server Analysis Services forum.

    ------------------------------------

    how to see print preview of owc11 in vb.net

    hello all,
       
        I have developed a vb .net applciaiton for using OLAP (Analysis Services 200) .
        I have used OWC 11 component for the purpose. Pl suggest me how to see the print preview    of the current view of pivot table (or what steps to use).
       
        Regrds,
        Deepti


       

    Some info on setting row delimiter values in package configurations

    I just spent the past 3 or 4 hours trying to figure out how i could represent carriage returns and line feeds properly in package configuration variables that an SSIS package can properly handle, so i figured I'd post my results in case anyone else has struggled with this.

    Initially, I thought I would be able to just represent the delimiter as the same value that you can pick from in the flat file connection manager dialog, i.e. {CR}{LF}, {CR}, {LF}, etc. nope.

    Then I decided to try actually storing the characters as hex, i.e. _x000D__x000A_ for {CR}{LF}. nope.

    After scanning the .dtsx packages for a while, I finally found something that works: you have to represent the curly brackets in hex, and you can simply use the CR or LF string literals. so if you wanted to have a row delimiter that was {CR}{LF}, you would need to set your variable to: _x007B_CR_x007D__x007B_LF_x007D_

    Hope this saves some people the pain I had to endure.


    Reply:

    Thank you, I will work to at least get this documented so others can benefit from your time.

     


    ------------------------------------
    at No comments:
    Subscribe to: Posts (Atom)

    Setup is Split Across Multiple CDs

    Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...