Again,

It is important to understand that OLAP cubes are meant for end users(business users) who actually are the beneficiaries. Thus it is they who will decide what they want to...

My two cents:

Remember to make a good compiled document for all metadata and processes

Cube wizard will just provide a "doable" structure. Good for learning. Cannot be used for live systems/projects 🙂

Click here[/url]

OK. This is the case of MDX member missing

What version of Analysis service instance are you using

Reading!!!

Worth a shot...

The .NET library has a host of solutions for your need. Try implementing any of the algorithm within a Script Task/Component.

SELECT [Measures].[M1] on 0,

[Dimension].[DimensionName] on 1

FROM CUBE

Virender,

Before OLAP, I would recommend you brush up your skills with DW principles. This will indeed help you a lot, in the longer run.

da-zero (12/16/2010)

---

Oh allright, it is for an interview. Why didn't you mention this in the beginning?

Your answer should definately be:

first yellow boxes. If you're lucky, green boxes. If not, red...

venus.pvr (12/13/2010)

---

Hi,

I have a package which calls Package1 and Package2. I have implemented an event handler which fires OnError,

I have a ExecuteSQL task that logs the Error into a table.

There...

I am not clear with your question.

Anyways ISNULL('"Column_name")?"some_value_if true":"else_value_if_false"

Hope this helps!!

I have an alternate approach,

Implementation of a system wide Active directory for authentication of the users for report access is beneficial. I have tried this for hosting a report for...

Using dataset you cannot restrict users to access reports. Though using your Report manager or Sharepoint you may achieve it with ease

Can you please share your approach