my 2 cents..

Check your cube schema. Make sure all the dim keys in the fact table(s) are linked to appropriate dimension table keys.

If the problem persists, try removing dimensions...

hmm.. did you try to create a test database/cube manually on the OLAP server? check what happens.. if you are able to, then something to do with this particular cube;...

ok. did you try the options I said?

To validate this, you can try adding an user explicitly to that login for which access is denied. And, ask the user to test. If it works, (i.e. the user...

Not to my knowledge.

Hi,

Why don't you try this:

Select user_name, count(All login), count(All login) - count(All logoff)

From table_name

group by user_name

All is default anyway, just to make sure it will not count null values.

hope...

It's not possible. You should explicitly mention the column names you want:

Select column 1, column2, column 5, column 7

From...

That's also a best practice.

I would have a partition for each survey..

Hi,

Not sure what you mean by KPI key. The fact as such can contain only dim keys and facts. You already have the dim keys in your fact table and...

Hi,

Without understanding your exact requirement, it would be difficult to help. How do you want your cube to look like? what do you want to analyze? what are the dimensions?

Be...

Hi,

Not sure what exactly you are trying to do here. What do you do with the rating? use it in a calculated member? or is it just a dimension attribute?

Regards,

Vijay.

Hi Sindu,

As far as I know, there is no stored proc in SSAS. But, I presume that you are using a ETL tool for loading your dim table, so you...

Hi David,

Not sure if you are still doing by this method. SQL Server Analysis services is bundled with sql server so why don't you use that? You can forget about...

Hi,

That's a pretty simple scenario.

I would go with your design. You can have 2 cubes, each serving different purpose. If required, you can always have a virtual cube to...

Hi,

The necessity of keeping historical data should be business driven. if the Business wants to report on historical data (say 5 years), it should be kept.

Regarding partition, you can process...