When I have parameter set in the MDX query, how to test it in mquery analyser ..

Thank you but I have Date as a parameter so user can pass any date and based on it, I need to calculate current week and previous week? Can...

Thanks Sean. and I agree to what you said as its important to make people understand what i am trying to communicate.

With the issue, I think i have used...

I do understand what you mean! But I am in middle of Live issue thinking if i post here, I can get solution.

When you start typing the issue in...

Ok so I have read the article and also did try to explain which can help me to get the solution:

I have a table :

CREATE table Statistics

(

Status Varchar(10),

Opco Varchar(30),

Region Varchar(30),

Country...

Yes you got me right , I need that but in very efficient way.

Not able to access reporting services from Database.

Please refer the attachmenet which seems oto be an issue where it should be logon as Built in account but how to address it

Its the same user for both , still the issue

No Difference.

Ho wto check that?

From config file, i tried to find authentication and this is what it contains:

<Authentication>

<AuthenticationTypes>

<RSWindowsNTLM/>

</AuthenticationTypes>

<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

<EnableAuthPersistence>true</EnableAuthPersistence>

</Authentication>

Getting the following error when i try to deploy reports from BID:

TITLE: Microsoft SQL Server Report Designer

------------------------------

Could not connect to the report server http://Local-pc/ReportServer. Verify that the TargetServerURL...

Yes, I am do admin rights and I am logged in as administrator. Still cant resolve the isse.

Regards

Daily Backup is already taken of dev server but as it is 200GB, it occupies a lot space so I was wondering if we stop it , what will be...

Thanks a lot.It really helped to clear the concept.