Saturday, April 2, 2022

Change Linked Measure Groups - blow away partitions in base cube?

Change Linked Measure Groups - blow away partitions in base cube?

If I add or remove a linked measure group in a cube, and then deploy the cube, my original base cube partitions get deleted.

Is this a known feature, and are there any resources out there pertaining to linked measure groups? 

SQLServer2005_ADOMD.MSI and ClickOnce

Hello,

We need to install ADOMD.NET on client workstations and would like to install it via ClickOnce.  Has anyone built a ClickOnce Bootstrapper Prerequisite Package for SQLServer2005_ADOMD.MSI?

Also, when running SQLServer2005_ADOMD.MSI on a client workstation manually, we receive an error stating that an updated version of MSXML 6.0 must be installed as a prerequisite.  We run the MSXML6.MSI (11/7/2005) found in the SS05 November 2005 Feature Pack and then run SQLServer2005_ADOMD.MSI and everything is fine.  This workstation already has Version 2.0 of the .NET Framework installed on it.  Isn't MSXML 6.0 a prerequisite for installing V 2.0 of the .NET framework? 

If we need to install the updated version of MSXML 6.0 prior to installing ADOMD.NET, has anyone built a ClickOnce Bootstrapper Prerequisite Package for the updated version of MSXML 6.0?

We realize these components might be part of the SQL Server 2005 Express Edition Prerequisite Package that is available, but would like to avoid an additional 35 mg download if at all possible.

Thanks in advance for your help.

Wendell G.

 

 

Error when deploying Cube

Hi,

Just wondering if anyone is aware of why this error might occur.  I am deploying a cube to a named instance of Analysis Services (2005).  The user is a sysadmin and apart of the roles of the analysis database.

The following system error occurred:  Logon failure: the user has not been granted the requested logon type at this computer. .

Thanks.

Encryption whitepaper

There is a whitepaper discussing an application of the SQL Server 2005 encryption features at:

http://www.microsoft.com/technet/itsolutions/msit/security/sqldatsec.mspx

Thanks
Laurentiu

Need Enlightenment on an AS2005 Error

Dear Anyone,

File system error: The following error occurred during a file operation:  Insufficient system resources exist to complete the requested service. . 

We're using AS2005. We get this error during our DW process -- specifically during the partition process. Around 3 to 5 partitions are processed in parallel during this operation. We're using a server box with 4CPUs and 8GB of memory. Both SQL Server and Analysis is on a single box. 32 bit is our version of SQL2005.

Can anyone please enlighten me on what is causing this? PLease! =]

 

 

Thanks,

Joseph

Dundas Gantt Chart in Reporting Services

I was wondering if it is possible in RS to have a predecessor arrow drawn from one task to the other, depending on who is dependent of other tasks.

The Dundas website shows exactly what I need but it is in the Dundas Reports for .Net gallery.  The Dundas Gantt in reporting services doesn't seem to have the ability, or I haven't found it yet.

If anyone knows if this can or can't be done in Reporting Services and how, if it can be done.

 

Thanks.

Using AMO to create a Named Set in Analysis Services Database 2005??

Hello,

Does anyone know how to create a named set using AMO? 

The Analysis Services Tutorial DB has a "[Core Products]" named set, but I can't find the code in AMO sample application for the Analysis Services Tutorial that creates the named set.

Thank you very much,

Sincerely,

Hsiao-I

Calculation automatic formatting removes ;

Whenever we go between script view and calculation view in the cube, the semicolon seems to be removed from certain formulas.

The string looks something like this (pseudocode)

CREATE MEMBER

CURRENTCUBE.[measurename] AS '

[Measures].[Measurename] / 100

--,

--NULL

; --)', FORMAT_STRING = '#,#0';

What happens is the semicolon is removed from the end of the format string, which results in a processing error.

Has anyone else encountered this problem?  I have similar problems with the auto-formatting functionality of Reporting Services queries.  Is there any way to disable these features?

Update tracking in BI application [Analysis Server 2005]

Hi All,

 

I have a BI application in which I want to track update/insert and delete. The application that I have developed can track the INSERT to Fact table and any other dimension tables; but I am facing issue with UPDATE and haven't tested the same against DELETE. I have tried this using "SQL Server Notification" and "Scheduled Polling with Enable Incremental Updates". Could you please tell me what is the best way to track updates in BI applications. Is there anything else that I can look for?

 

Thanks a lot J

 

Warm regards;

Rakesh

Setting up roles - what to view when restrctions on a P/C dimension

Hello,

 

I am setting up roles in AS2005. I have come to realize that when you restrrict on a parent Child dimension you cannot enable the visual total as you then get an error.

OK so until visual totals is possible I will have to live with that...

I test the role and when I drag in the dimension I have restricted on it all works fine. I only see certain data, and the total amount in the cube as a TotalTotal in the cube... on the otherhand if I remove that dimension and drag in another normal hierarchy dimension I get to see all data - even the ones I should not...and the sums spent on these dimensions in TotalTotal. In other words I see too much.

I assume that it is enough to set restrictions on one dimension to restrict the viewing on other dimensions... How do I go about setting up the role in order for it to work?? Has it got anything to do with the visual totals?

Can anyone explain this...Please...

Sincerely,

 

The mechanism of notification for "proactive caching"?

There is an notification optioin in proactive cahcing, which can be set notification on update of sql server tables.

When the tables were updated, I used sql profiler to trace the SSAS activities and I got the notification logs on tables updated.

But the problem is I cannot find any notification services or events that handle the notifitcaiton to SSAS on the source database. So could you tell me how the mechanism of notification for "proactive caching" works? Can I trace the process of the notification?

Thanks 

Insufficient System Resources

Hi Guys,

I'm having problem regarding an error "File system error: The following error occurred during a file operation:  Insufficient system resources exist to complete the requested service". This happens during Update Dimension processing. Before the error was generated, reports have been created using pivot table. What I'm doing currently to resolve the problem is to restart analysis services and process update the dimension.

Another problem I encountered is, both pivot table and dimension processing hangs up if both process comes together simultaneouly. Is this a limitation of the SQL server2005 analysis services?

 

Cube Template

So my problem is the following,
i have created a cube without using a data source (from the wizard of cube creation). And i have generated the relationnal schema thanks to the following wizard. But i don't succeed to bind the data from my database to this cube. I found no documentation for this problem,  not in the msdn books onlines eigther.
Thanks

Determining the calculations affecting a particular cell

I currently have an application developed for MSAS2000 that permits users to enter data against a cube.  However, there is a need to prevent users from entering data into cells that are calculated in the cube based on MDX syntax (i.e. calculated members, calculated cells, etc.).  In MSAS2000, the cell evaluation list contains information about a cell's intrinsic properties which includes calculations, but this feature has been deprecated in MSAS2005.  What is the best way to interogate a cell and determine if it is affected by calculations in MSAS2005?  Is there someting I can use that will work in both 2000 and 2005?

Thanks,

SHW

How to bind PivotTable with ChartSpace in C++

I follow some sample code (VB) on internet, but it seem not work in C++. Does anyone tell me what is wrong with my code?

I want to bind PivotTable of OWC with ChartSpace. When user modify the column/row in PivotTable, the ChartSpace will sync automatically.

    mPChart.Clear();
    mPChart.put_ConnectionString(strSRC);
    mPChart.put_DataMember(_T("Adventure Works"));
    mPChart.putref_DataSource(mPTable.get_DataSource());

Thanks for your help.

What to do with a measure of varying data types?

Hi Folks,

I've asked this question to a few guy in the industry and would like to get some feedback and what ya'll think in here regarding this design problem.   Here it is ...

Anyways, one of the architectural issues I'd like to get some input on regards the design of my Answers Fact table.  Each row in this table respresents an answer to a question by a survey user.  The obvious measure (at least I think so) is the answer itself ... the problem is ... the underlying data type for an answer can vary from question to question (e.g. one can be an integer, the next a currency, the next short text, a yes/no, a true/false, a decimal, or a date/time, etc...).  So my question is ... "How should I  factor this idea of a measure with a varying data type into my dimensional model?"

One approach recommended to me was to create a separate column for each possible data type ... so my Answers fact table would look something like below.  Upside seems to be that the data is typed, most measures are addititive ... downside is that it seems like there will be alot of wasted space:

<foreign keys to dimension tables here...>
AnsInteger (int)
AnsMoney (money)
AnsDateTime (datetime)
AnsText (varchar(255))
AnsYesNo (boolean)
AnsTrueFalse (boolean)

Another approach I came up with was to simply create a generic AnswerValue column of type varchar (255) and the indicate the *true* data type of the answer through an attribute in the related Question Dimension.  My thought is that I could simply evaluate this attribute in my calculations to determine how to actually work with the data in the generic column.  Downside of this approach seems to be lack of type-safety and a totally non-additive measure .... up-side seems to be reduction of space in the DW.

Is one approach above preferably over the other? If so, why?

Or is there perhaps a better way to deal with the issue? 

Thanks!
- Wayde

Dimension Security Issue

I am trying to define a proper role (Dimension Security) for the following problem.

I want to have an "Allowed member set" for the attribute REGION:

{[Geography].[REGION].&[North America]}

And an "Allowed member set" for the attribute COUNTRY:

{[Geography].[COUNTRY].&[Germany]}

I would like to see North America and Germany in my Geography dimension.

The result of this two member sets is nothing. Each role alone gives back the expected result.

How to handle this security related issue?

 

SSAS non default instance while disconnected from domain

For those still being plagued by the bug (which is fixed in SP1), that prevents the SQL Browser from resolving SSAS instances on a machine that is disconnected from the domain, the resolution is simple.

There is misleading advice about using local security accounts and other hacks, however all that is required is to connect to the instance directly using the machine:port syntax.

SSAS will by default use a dynamically allocated port number so you would benifit from setting a fixed port number if this is something you need to do regularly.

Project REAL Source Code

I am reading the Project REAL documentation, which is really useful and interesting, but I think it would be more efficient if we had the project (even without the data).

Is the source code of Project REAL gonna be available for download one day ?

Add-in for SQL Server Management Studion

Announcement

New tools for MSSQL administering
Add-in for SQL Server Management Studio
http://www.aris-soft.com
http://www.ssmsaddin.com

Tables Data Scripting extension of SSMS
at

No comments:

Post a Comment

Subscribe to: Post Comments (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...