No mapping between account names and security IDs was done

Hi
I haven't done much with AS2005. Today I was trying to migrate an AS2000 cube to As2005 using Migration Wizard.

Existing AS2000 cube is on Windows 2000 Server (SP4). Destination server has Windows 2003 Server with June CTP.

Migration Wizard goes through the validating databases. During metadata migration I get the following error "The following system error occurred: No mapping between account names and security IDs was done."

I am running the OLAP Service on Win 2000 and 2003 Server under LocalSystem (might not be the best option).

Has anyone come across this before or know how to resolve it?

Thanks

SuthaAs Chris W suggested, I made a copy of the AS2K cube and removed the roles from the cube and then ran the migration wizard. The meta data migration was successful.

Thanks Chris

Sutha|||

Hi Folks,

i've had the same message in SSAS 2005 whilst trying to add a domain local group to the "Server Role".

e.g. Right click the server, select "Properties" and then select "Security".

Is it possible to add a windows group here or is it just restricted to users? The wording is "The server role is used to grant server-wide security privilages to a user".

If this is restricted to just user accounts, then how could i add a windows group (a group of users that are administrators) to a similar role?

Cheers,

Kyle.

|||

Hi,

PLEASE NOTE: My post above is now out of date! I tried adding the groups again and it worked fine.

In my place it can take up to 15 minutes for replication to occur on the domain so it looks like the account i created wasn't immediately visible!

Watch out for this one if you use domain replication on you domain servers!

Cheers,

Kyle.

No grand total if Time Intelligence Calculation is drag on row

Hi,

I've deployed a simple cube with a time dimension on SQL 2005. I added the time intelligence which generated some calculations like Day over Day difference, Month over Month difference. If I drag it to row on a pivot table, the grand total of the measures cannot be shown.

Is it because the calculated member is not aggregatable? Is there any ways to show the grand total as well as those calculation on the pivot table?

Million Thanks.

KJ

Kelvin,

This is the intended behaviour. The calculations are written in such a way as to purposely place "NA" in cells where the calculated value would not make sense. For example, if you think of a YTD calculation in the context of all years, it doesn't really make sense; likewise for a year over year calculation.

-rob

No data in Data Mining cube.

Hi,

I've created a Cluster data mining model and seems to correctly return data. However I've created a data mining dimension and cube but when I go to query the cube it doesn't return any data if I select any members on the data mining dimension. Any suggestions to where I can look to resolve this?

Thanks

Sanjay

Hi,

I found out how to see the data in the cube. I was using the data mining dimension in relation with the dimension it was based on. So now I can see data for the years that I've trained my model on. Is there anyway to make the cube predict the values for the other years in the cube with data?

Thanks

Sanjay

|||

Are you saying that for example you've created a cluster model on a set of items, and you want to see the cluster values for items not in the set? And you want the slicing behavior to work against those values as well?

If this is the case, unfortunately, that's not the way it works. The cluster dimension is only on the cases for which it was trained. You could apply the clustering to the data outside the cube, write the results to a table and process it as a regular dimension, though.

|||

Hi,

Ideally yes. For example if I generate a cluster model and train it with a couple of years data, potentially I would then like to use the data mining dimension and cube to predict or classify the current years data. I will look to use your suggestion.

Thanks

Sanjay

No data found when I browse cube

Hi,I have MS SQL Server (& Analysis Server) installed on a Windows 2000 server machine.I installed the MS SQL Server client and Analysis server on my local machine too(Windows NT).Now,I created an Analysis database on my local machine whose data source lies on the Windows 2000 server machine.When I access the cube data from my local m/c,I can see the data.
Then,I took the backup of my local Analysis database(.CAB) and restored it onto the Windows 2000 server machine.But now,when I try to browse the cube data on the Windows 2000 server machine,I don't find any data!!
I don't have to clue about what went wrong.I have installed SP3 on both the machinessql

No aggregations for Measure Group possible in Analysis Server 2005

I have a cube with about 20 Measure Groups and 30 dimensions. I built some dimensions using BI Development Studio a few weeks ago. The aggregations were build for any measure group without problems.

Now I changed some attributes and want to run the aggregation wizard on my test plattform to design new aggregations. But there were no aggregations build. It shows 0 aggregations.

I read that sometimes this happens when the cube is too complex. But the complexity did not grow very much.

What should I do to be able to design aggregations again?

Best regards,
Stefoon

There is an exellent writeup about aggregations in performance guide.

Chirs's blog is good source for information http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!907.entry

Edward.

--

This posting is provided "AS IS" with no warranties, and confers no rights.

Newbie: what kind of "cube" is this?

1. In sql 2005 Analysis services how can I tell what kind of "cube" I'm viewing -- ROLAP, HOLAP, or MOLAP?

2. During cube creation where do I specify the type of "cube" I want to create

TIA,

Barkingdog

The cube wizard will not ask you for the storage settings that you want to use. After you have run the wizard and created the cube, go to the "Partitions" tab of the cube editor. You will then see information for your partitions. You can click on a partition and then click on the "Storage Settings..." link to specify MOLAP, HOLAP or ROLAP.

HTH,

- Steve

|||Cube and dimensions will initially be MOLAP when creating cubes and databases with Cube or Dimension wizards.

Newbie: what kind of "cube" is this?

1. In sql 2005 Analysis services how can I tell what kind of "cube" I'm viewing -- ROLAP, HOLAP, or MOLAP?

2. During cube creation where do I specify the type of "cube" I want to create

TIA,

Barkingdog

The cube wizard will not ask you for the storage settings that you want to use. After you have run the wizard and created the cube, go to the "Partitions" tab of the cube editor. You will then see information for your partitions. You can click on a partition and then click on the "Storage Settings..." link to specify MOLAP, HOLAP or ROLAP.

HTH,

- Steve

|||Cube and dimensions will initially be MOLAP when creating cubes and databases with Cube or Dimension wizards.

Newbie: Viewing KPIs thru MOSS

I'm a newbie with SSAS so please bare with me.

I've create a data cube and subsequent KPIs. I now want to be able to publish these KPIs from within MOSS. All of the literature up until now seemed to indicate that I could easily attached to the KPIs from within MOSS, but now I finding that I need to publish them to Excel then to MOSS. Is this correct?

If so, I do not have Excel 2007, so is there a work around to this? Also, similiar to how Reporting Services when deployed provides the ability to render the reports via the web browser...does this functionality exist within SSAS and KPIs?

Thanks for your time and assistance.

SArnwine wrote:

..

but now I finding that I need to publish them to Excel then to MOSS. Is this correct?
...

If you follow the blog entry below, you should be able to create a KPI list, add items to this list for SSAS KPI's, and display the KPI's in the list using the MOSS built-in Key Performance Indicators Web Part:

KPI's in Microsoft Office SharePoint Server (MOSS) 2007

|||thanks.

When I try to connect to the KPI's from SSAS thru MOSS (as depicted in the blog you sent the link to), I'm asked for a ODC connection.

How do I create/determine what my ODC connection is to my SSAS Cube/KPIs? I've seen ways to create it via Excel, but once again, can I bypass Excel and just create the ODC myself?

Thanks.
|||The Office Data Connection Wizard (which I think is shared among Office apps like Excel and InfoPath) allows you to create ODC files - there may be tools to create ODC files outside of Office, but I'm not aware of them.