SSAS data source calculating from two data source

10-11  Source: Network gathering  Views:0 

Advertisement
Hi There,
I have SSAS cube and use SSRS 2008R2. Basically I have cube A for current month income statement, cube B from previous month, they have shared the same dimensions. I want to create  report to show
                  current month  previous Month            Calculation
   Account               Amount A         Amount B            Amount A - Amount
B
Revenue                 Amount A         Amount B            Amount B
   Expense              ,,,,,,
Net Income
Any advice?
Thanks
Don
Hi Dz0001,
According to your description, you want to combine the data from two cube into one tablix. Right?
In this scenario, since your two cube share same dimensions, we can use lookup() function to retrieve the income from another dataset based on the data field for dimension rows.
For example, let's say you have DataSet1 retrieves data from cube A with data fields
Account and Income, DataSet2 retrieves data from cube B with data fields
Account and PreIncome. When rendering the data field from DataSet1 in a table, you can use the expression below in detail row.
=Lookup(Fields!Account.Value,Fields!Account.Value,Fields!PreIncome.Value,"DataSet2")
Reference:
Lookup Function (Report Builder and SSRS)
If you have any question, please feel free to ask.
Best Regards,
Simon Hou
TechNet Community Support
Related articles
  • SSAS data source calculating from two data source 10-11

    Hi There, I have SSAS cube and use SSRS 2008R2. Basically I have cube A for current month income statement, cube B from previous month, they have shared the same dimensions. I want to create  report to show                   current month  previous M

  • Collecting data from two R3 source systems 11-30

    Dear All, Scenario: We are in the process of implementing SAP BI 7.0 in our organisation. We have a single BI server (7.01) collecting data from two source systems from two different divisions within the group. The first system is of Company 1 where

  • Differentiating Master Data from two different source systems 11-30

    Friends, i have used standard InfoObjects that provide master data for two InfoCubes which take data from two different source systems. Now the some of the master data is identical in both the source systems (example: 10 stands for "Industrial"

  • How to generate a number from two dates 10-11

    I am 'new' at this of using Numbers for anything.  What I want to do AND I can't seem to figure it out, is to generate a 'days total' from two dates.  I get paid S.S. on the 2nd Wednesday of each month.  I have X number of dollars to spend.  In order

  • Urgent Q-adding elements from two data sets 11-30

    How to add two fields from two data sets. in RTF template the fields have same names too.BIPuser wrote: If you are grouping within one data set, then the current-group will only work for an element within that group. For the second one, try to use th

  • Web report data provider change from Master data table to InfoCube 11-30

    hi Experts, I have created one report on top of multiprovider but in the selection screen when i check the values for a variable I came to know that data is coming from master data table and not from data provider(InfoCube).Can any one help to change

  • One target table is loading from two different source but same columns but one source is in a database and other is in a flat file. 10-11

    Hope you all are doing good. I have a business issue to be implemented in ODI 11G. Here it is. I am trying to load a target table from two sources having same coulmn names. But one source is in file format and other is in Oracle Database. This is wha

  • Condition Type for item calculated from delivery date 10-11

    Dear Experts, We need that the condition type MWST for PO item will be calculated from Item delivery date , But we see that always in Analysis pricing the efected date is PO date and not item delivery date . Please advise how we should configure the

  • Hardware needed to record from two HD sources 10-11

    Hi. I'm a researcher studying social interactions in children with autism. I would like to capture compressed HD video from two sources simultaneously using a mac mini and with real-time output to two monitors. The reading I've done so far indicates

  • Data from two data providers 11-30

    In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report le

  • Weeks calculation from the date 11-30

    Hi BW mates, I am currently working on SCM Queries. I have a report where I have to display the sales for 16 weeks from the date of release of cinema. For eg. In rows, Title and Release date are displayed in rows. In columns data is displayed with We

  • Data not going from active data table to new data table -DSO activation iss 10-11

    Hi Experts, Data is going from DSO1 to DSO2. I see some of the records are getting missed in DSO 2 which are supposed to come. There is start routine from DSO1 TO DSO2 and as per the start routine some records should come but they are getting missed.

  • Query data being picked from which data targets and dimension tables. 11-30

    Hi Guys, I need help from you people. My query is "If we execute any query, i want to know from which data targets and from which dimension tables data being read in the run time", is there any program or any table to find this data. thanks in a

  • Combine output  from two data sources for a line graph. 11-30

    Hello Experts, I need your help in following scenario. Scenario - We have a line graph created in VC. We have a numeric field in the data seris and a date field in the Category axis.                   This is working fine. Requirement - Customer want

  • Data Extraction issue from the data source 2LIS_08TRTLP 10-11

    Hi All,         We are facing one issue in time of extraction from data source 2LIS_08TRTLP(Shipment Delivery Item Data per Stage) in BW. For some out bound delivery no. Gross weight(BRGEW) is coming zero though there is value showing in the source s

  • Updating div  from two data sets with fading 10-11

    Hi, I am trying to do the following: I have a main area where I want to display an image (main image) of a product. This product has associated with it a few detail pictures of that product that are displayed next to the main image. I want to let the

  • Due date calculation from GR Date / Service entry sheet date 10-11

    Dear Friends, GRN Date--01.05.2009 Payment terms--- Within 45 days due net Transaction code---FBL1N System should not output these records before 14.06.2009 in FBL1N. It should ouput on or after 14.06.2009. Regards R Panda Edited by: Rutabhadra Panda

  • How can I save multiple data coming in from my data string 10-11

    I am a newbie at labview. I have a scale connected to my RS 232 and made a VI to display the changing scale. I am trying to save the multiple changes as my weight varies but have been only able to save the last value. Is there a simple way to save al

  • Integration with Outlook - how to increment end date and time from start date/time 10-11

    Hi, I want to add a variable amount of time to an appointment start date and time in outlook, through vba in access.  Code below shows what I've done: ======================================     Dim olApp As New Outlook.Application     Dim olAppointme

  • Basic / Scheduling dates are calculated for both main orders and Collective 11-30

    How the Basic / Scheduling dates are calculated for both main orders and Collective orders? when in master data we have given different value of in house production time for both the orders.Hi, The basic dates are calculated from the data mentioned i