How will u execute a stored procedute from a reportstudio
Answers were Sorted based on User's Feedback
Answer / poorna chandra reddy
When ever we run the report, SP will automatically run, if
u use the SP columns in the report
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / kk
Please use the below command to execute the report studio.
{exec dw_xli_dev.dbo.sp_sample}
| Is This Answer Correct ? | 0 Yes | 1 No |
what is dimention?explain dimentable with example?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
WHAT ARE THE TYPES OF LIST REPORTS?
I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?
What do you understand by the term 'dynamic cube'?
What is the metric store database?
---------------How to identify First Record and Last Record?
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
Can you define confirmed dimension?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You
How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?