HELP! I've lost a SSAS "cube" due to a "File ==> Save as XML"

Then, the cube name became XML, listed under the "Assemblies"... and, then made the mistake of "deploy-ing"... and of course, didn't have a backup... It appears all of the recent "calculations" added to the cube are contained within the xmla file, yet the cube still looks like it is missing from the VisualStudio 2005 (VS2005).

Over in the SS Management Studio (SSMS), I tried wrapping the "Alter AllowCreate..." around the cube XML, and that seemed to work, so that now the Cube appears within the SSMS... However, I can't seem to find a way to open it up with VS2005, and see the cube name/measures, as I can see them within SSMS...

Thanks in advance for your help!

Hi Al,

If you can see the cube in SSMS then what you should be able to do is in BIDS (BI Developer Studio) go to File/Open then choose Analysis Services Database, specify the Server Name and Database name. You can put this to a new solution if you need to.

Once you click OK it will have a direct connection to the cube on the server where you can modify things.

Hope this helps,

David Botzenhart

|||

Thanks... I had proceeded to click on the XMLA file (which was actually within "Miscellaneous", instead of Assemblies), and then used "File ==> Save as Cube", which worked, for the most part... Also, apparently, I also saved the DSV as XML, which lost the relationships between the source tables... After I reconnected the table relationships, then the CUBE deployed successfully...

Thanks for the quick reply

p.s... Moral to the story, if you want to backup XMLA script file, then utilize the Deployment Wizard, and click the box to "create the script".... and/or Backup the source and/or SSAS database regularly

help! all of a sudden can't connect to my db

hello,
i've been running fine with the same msft sql server set up for over a year
now. each night i run some vba code which connects with the db and does some
data updates. all of a sudden i'm having trouble communicating with the db.
when i attempt to connect to the db via query analyzer, i get the message:
Server: Msg 924, Level 14, State 1, Line 1
Database 'artorius' is already open and can only have one user at a time.
what the dillyo? maybe some setting got changed? how can i change it back?
hopefully this is not a symptom of a larger problem. anyway, would
appreciate any suggestions to get this working again.
appreciated,
matthew
nevermind, i switched the setting back. sorry for the panic. i have no idea
how the setting got switched in the first place though.
"matthew c. harad" wrote:

> hello,
> i've been running fine with the same msft sql server set up for over a year
> now. each night i run some vba code which connects with the db and does some
> data updates. all of a sudden i'm having trouble communicating with the db.
> when i attempt to connect to the db via query analyzer, i get the message:
> Server: Msg 924, Level 14, State 1, Line 1
> Database 'artorius' is already open and can only have one user at a time.
> what the dillyo? maybe some setting got changed? how can i change it back?
> hopefully this is not a symptom of a larger problem. anyway, would
> appreciate any suggestions to get this working again.
> appreciated,
> matthew

HELP!

Hi everyone.
I got som textfiles that I have to load in to the server,
I've done that with DTS package. When I run the package
manually everything works fine but when I schedule it the
float numbers becommes integers.
Manually 2.2 in the textfile becomes 2,2
in the schedule 2.2 in the textfile becomes 22...
Anyone that know whats the problem is?
/Anett
Hi,
In the Data Transformation Task, click the Transformation and change the
format of the column to Float and save your package.
Thanks
Hari
SQL Server MVP
..
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:10bc01c541b4$810abb10$a401280a@.phx.gbl...
> Hi everyone.
> I got som textfiles that I have to load in to the server,
> I've done that with DTS package. When I run the package
> manually everything works fine but when I schedule it the
> float numbers becommes integers.
> Manually 2.2 in the textfile becomes 2,2
> in the schedule 2.2 in the textfile becomes 22...
> Anyone that know whats the problem is?
> /Anett
|||The format of the column is already float. Any other ideas?
/Anett

>--Original Message--
>Hi,
>In the Data Transformation Task, click the Transformation
and change the
>format of the column to Float and save your package.
>Thanks
>Hari
>SQL Server MVP
>..
>"Anett" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:10bc01c541b4$810abb10$a401280a@.phx.gbl...
server,[vbcol=seagreen]
the
>
>.
>

help with web admin

I've got the latest MSDE installed using SAPWD=<strongpw> SECURITYMODE=SQL
But I can't log on to it with the Web Administrator. Either I get a
"password is wrong or server doesn't exist" or a constant hour glass cursor.
Is there another administration program I can use for this? Or is there a
way to fix the Web admin?
Thanks.
hi Terry,
Terry Olsen wrote:
> I've got the latest MSDE installed using SAPWD=<strongpw>
> SECURITYMODE=SQL
> But I can't log on to it with the Web Administrator. Either I get a
> "password is wrong or server doesn't exist" or a constant hour glass
> cursor.
did you specify the correct instance name?
or
http://support.microsoft.com/default...06&Product=sql

> Is there another administration program I can use for this? Or is
> there a way to fix the Web admin?
you can have a look at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442 for other tools, both commercial and
free
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

HELP with Update with Join

Ive been trying to get this to work for a while now and I cant find anything in the forum that works. I am using DB2 UDB v8.1 for windows. Here the problem:

I have 2 tables

Product Table
----
ID (Primary key)
Vendor_ID

Warehouse Table
-----
Product_ID (Foreign key to Product.ID)
Reorder_Level

I want to update all Warehouse.Reorder_Level on products that have a Vendor_ID of 1.

I have tried the following statements without any luck:

Update Warehouse set Reorder_Level=5 from Warehouse inner join Product on (Warehouse.Product_ID = Product.ID and Product.Vendor_ID=1)

Update (Select Warehouse.* from Product, Warehouse where Product.ID = Warehouse.Product_ID and Product.Vendor_ID=1) as temp set temp.Reorder_Level
=5

Update Warehouse, Product set Warehouse.Reorder_Level=5 where Product.ID = Warehouse.Product_ID and Product.Vendor_ID=1

Im out of ideas and very frustrated Please HELP!I don't know db2, but msql would be

UPDATE Warehouse
SET Reorder_level = 5
WHERE EXISTS
(SELECT *
FROM product
WHERE id = product_id AND vendor_id = 1)|||It works... Thank you!