I got over it temporarily by concatenating item_nbr and item_id (unique) as the name but is this really the only way? What does the setting 'Member names unique' False mean then?

Ville

Hi, (I'm AS newbie)

I viewed this thread and based on the solution I fear that my case could be hopeless?

I've been asked to implement cubes with several dimensions and several...

Hi,

I found out that (in this case) the sql run OK when the 'order by' clause was removed. Well, the (Informatica ETL) lookup sql requires the condition colums to be ordered...

ROUND function

select round(1342671.000/1000000,1) ==> 1.3

select round(13426.000/1000000,1) ==> 0.0

etc.

Ville

This was my original idea too but

I did check the nulls - none. Only NOT nullable fields were the ones in the PK's in the tables and none of them...

Yes, sp3 was the solution indeed.

For others, atleast running win XP/SP2, please read the short discussion at Sql Server / Service packs about installing the Sql Server / Analysis services sp3.

My thanks...

Yep, you pulled the right straws, thank you.

Strangest thing (if possible with upgrades nowadays) though...the article

http://support.microsoft.com/Default.aspx?kbid=837188 suggests the logfile (dahotfix.log) is either locked, read-only or hidden attribute set. None of these...

I'm dealing with same kind of problem here. After allowing (exceptions) Analysis Services through the firewall (even though I'm running a standalone laptop), I was able to view the cube...

Thanks,

I read these articles and some other linked to these but unless I missed some crucial part, I still can't update SqlServer/Analysis S with sp3...

I allowed 'Sqlservr.exe' and Analysis services 'Msmdsrv.exe'+port 2725...

Hi Wes and Goce,

thank you both for your efforts

The instance is now allowed via tcp/ip,port and it works okay. It can be rather difficult in these kind of situations: The...

Hi Goce,

the thing is that the connection to the desired server works when the other SqlServer instance (on the same server) is started and dies shortly after its shutdown....?