Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
No Answer is Posted For this Question
Be the First to Post Answer
What is etl process?
How we can see table structure?
State the differences between shortcut and reusable transformation
how do use session mapping parameters ?(in which transformation)
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
can be used COM component in Informatica ?
what are business components in Informatica?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What is the difference between project backlog and product backlog?
When do we go for the tools in the market?
how do u extract data from different data sources explain with an example?