Thanks a lot!!!!

it works! :-D:-D:-D:-D:-D

Your manager is an idiot :hehe::hehe::hehe::hehe::hehe::hehe::hehe::hehe::hehe::hehe::hehe:

I know!!

Well let me figure out!

Thanks a lot for your grt help! 😀

Yes!!! it's a Tabular cube.

Agree with you that we don't need separate cube for fact table.

But my manager wants to have different cube for different fact table (His own...

No!! i cant do like that.

See i have a reference cube which i have made first (Sales) which has all calculated column, measures , relationships defined on the fact.

Same kind...

1. In the object list in the AS processing task, when you click add you have an option to add what object gets processed. Choose the entire database.

Thanks 🙂

2. No....

Thanks for the same!!

Quick questions :

1. How to process whole SSAS database : In SSIS, i can see option of processing only Cube

2. Every time processing the whole db...

Thanks!!

I do 'Process All' for my cube. but still the same issue.

Other than that i dont want to show the stake holders multiple database when they connect with Excel to...

I Know Sir!!

Previously i posted in Reporting service section the moment i have reliazed i raised the same question in Analysis service.

can you can help me with my question?

please reply somebody [Crazy]

please reply somebody [Crazy]

please reply somebody [Crazy]

please reply somebody :crazy:

Yes!!! Exactly 🙂 🙂 🙂 😀

My flat file should have 1st line as column headers and rest is my data.

Hi,

Yes i am able to export my data. BCP uses format to export the data using comma separated.

I have to define each column name to export the data with...

Thanks David for the reply.

I am not using reporting services.

Basically i am creating pivot of my data using TSQL and trying to dump the data into flat file using BCP.

so...