Hi I am wondering if there exists documentation that in much more details
describe how to deploy/process cubes from BI studio to SSAS?
I do this all the time, but realized that sometimes I have a hard time
understanding what is really happening when.

Specific questions I would have are:
1. Lets say it takes me 3 hours to process cubes on SSAS. Then I find some
problem in cube level calculations (Calculation tab in cube editor). How can
I deploy changes just to calculations and leave data in cubes in place? I am
sure this should be possible, but how?
2. In BI studion my measure groups have just a single partition. After I
deploy model to SSAS, I drop that partition and then create partitions on
the fly based on my parameters. Is it possible to deploy model from BI
studio to SSAS, but keep all partition that already exists on SSAS? I need
this when I just change dimensions on calculations, but all measure groups
stayed as before. Any workarounds?

Thanks

Try to edit your cube in connected mode instead-of solution mode.
I mean you can edit the cube like in SQL2000, when you save, the change is
saved on the server directly.
I'm using this to edit my calculations, no reprocess needed.
but with this option there is no local files and no source safe storage;
everything is stored on the server only.
but advantage, if you create a partition using a script, you have access to
this partition from VS

if you want to keep the entire solution in VS without editing the server
directly and if you work with a model without partitions, you can create an
XML/A script to create these partitions.
So you deploy the non-partitionned version , then you reexecute the create
partitions script.


"Vimas" <Vimas (AT) nospam (DOT) nospam> wrote

Hello,

Thank you for your post in MSDN newsgroup. Please see my inline comments


I understand that you'd like to change calculations without reprocess the
cube and you'd like to know if there is some detailed information on
processing. As Jeje mentioned, you could edit cube like SQL 2000.

Analysis Services 2005 Processing Architecture
http://msdn.microsoft.com/library/en...asprocarch.asp


As Jeje metnioned, youcan create an XML/A script to create these
partitions, so you deploy the non-partitionned version , then you reexecute
the create
partitions script.

If you have further questions on this, please feel free to let's know.
Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Jeje, Peter,

Thank you for your help. I was hopping that there is some way to partially
publish BI model from BI studio, but from your replies I can see that that
is not true.I do use "Direct edit" mode, but that means I have to do changes
twice: one in BI disconnected model, and then again in direct mode. I hope
that some time in the future microsoft will release option to deploy
"calculations only". During certain points of development I have to do many
calculation changes, and my default working environment is "disconnected".
For these periods I do switch do "Direct" cube edit mode.

Thanks again for help

Vimmas




""privatenews"" <petery (AT) online (DOT) microsoft.com> wrote

this is how I work:
I have 2 instances of AS installed on the server.
I work on the dev instance in direct connected mode.
when I'm happy, I synchronize the dev instance with the prod instance.

if you want to apply minor changes, you can play with XML/A scripts to alter
the targeted database.
work on a dev version of the database deployed anywhere, create the alter
xml/a script using the management studio and apply it on the production
version.

you can edit this script before you apply it to insure that you don't alter
what you don't want, but the system should alter only what is different (the
calculation in your case)

also, you can use a "template" XML/A script around the calculation only. (to
alter the calculation only)
copy / paste the new calculations into this alter template and execute it.

maybe only this template is enough: (not tested)
<Alter ObjectExpansion="ExpandFull"
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>DatabaseID</DatabaseID>

<CubeID>CubeID</CubeID>

</Object>

<ObjectDefinition>

<Cube xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<ID>cubeid</ID>

<Name>cubename</Name>

<Description>Contains all attendance information including high
absences.</Description>

<Language>1033</Language>

<Collation>Latin1_General_CI_AS</Collation>

<MdxScripts>

<MdxScript>

<ID>MdxScript</ID>

<Name>MdxScript</Name>

<Commands>

<Command>

<Text><!!! new calculations here !!!>

</Text>

</Command>

</Commands>

</MdxScript>

</MdxScripts>

</Cube>

</ObjectDefinition>

</Alter>


"Vimas" <Vimas (AT) nospam (DOT) nospam> wrote

Hello Vimas,

Please rest assured your feedback on this is routed to the proper channel.
In the meantime, I also encourage you submit via the link below

http://lab.msdn.microsoft.com/produc...k/default.aspx

Also, thanks Jéjé for the great comments here which shall benefit the
community.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

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

Jeje,

Thank you very much for sharing this info. I'll definatelly use your advice
for future developments. I especially like your idea on generating ALTER
XMLA script. I'll try it later.

Thanks again



"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote