hi,

You have to add another vairable for storing the path and use that path in the design script area..set the variable scope to the package.

you can use the system.io.file.exist("filepath") to...

hi,

For getting into using MDX you must have a cube to query upon.SO first buld up a data cube using the tables availaible in the database.Then create a database...

hi,

Where condition is the last part of the select statement in MDX statement.GIven below the modified sample of yours...

WITH

MEMBER [Measures].[UniqueName] AS

[Op].[Key].CurrentMember.Unique_Name

MEMBER...

hi,

I have been with this company for the past four months..Havent done anything apart from couple of intranet prjects...Now am decided to move on fro here...But for four months...

hi,

The department wise metrics can vary according to the nature of work of departments.

An HR department worth KPI is more depends on the recruitment of number of Quality ...

hi,

Check whether you can login to your Sql Server Analysis Service 2005 using windows authentication.Problably that is the problem area for you, since the error message is an connection based...

hi,

What version of Sql Server is you using?

Regards

Vijay

hi,

I had gave the details all those you had asked to me.Now reply me mate.:)

vijay

hi,

AM famliar with the BI tool Proclarity...and SSIS and SSAS..I will be able to create cubes using those and can create KPI's using the proclarity nad show some...

hi mate,

Thats a not fair call...we have to be in balance in with our activity..am asking about the placement of a new job with four months BI experience...answer that...

hi,

Learning a lot i agree,but the thing is sometimes we never know what we did is corrrect or incorrect, if we are a single man team.Also we cant enjoy...

hi dave,

Do u know that by intution users eyes goes into the material they want most time rather than on ads....u can check it by yourself....;)..unless otherwise ads coming...

hi,

Now i had decided to move on from here.The reason is the lack of support from the management..I think they r not iterested in the BI,because we are not...

hi,

You have to use a go statement with the each set of stored procedures in the SSIS.

Thanks & Regards

vijay

hi,

yopu can use the proactive caching feature of SSAS.By using that feature we can set the cube updation property.Check the Sql Server help online for how to implement the proactive...