10 Replies Latest reply on Jan 31, 2013 9:04 AM by user248025

    Distribution List Reports

    Govi
      Hi
      Could you please suggest me below issues.

      1.I have reports(may be 10 to 100).I have send those reports to my business users(10 or 100 or 200).Can i configure smtp then send or through email?

      2.Similarrly i have to send multiple coutry (country wise data only not all data).Can i create mutiple folder based on coutry wise,then i have to store each folder wise and data
      How will do this.

      3.Is it possible to send link to business After schedule report(Server location Not OBIEE link ).If possible how will do this.


      Could you please let me .If we have 10 user which ways is better.
      Simil 100 user ?
      200 user?

      Thanks
      Gram.

      Edited by: Raj on Jan 30, 2013 1:06 PM
        • 1. Re: Distribution List Reports
          user248025
          Raj wrote:
          Hi
          Could you please suggest me below issues.

          1.I have reports(may be 10 to 100).I have send those reports to my business users(10 or 100 or 200).Can i configure smtp then send or through email?

          2.Similarrly i have to send multiple coutry (country wise data only not all data).Can i create mutiple folder based on coutry wise,then i have to store each folder wise and data
          How will do this.

          3.Is it possible to send link to business After schedule report(Server location Not OBIEE link ).If possible how will do this.


          Could you please let me .If we have 10 user which ways is better.
          Simil 100 user ?
          200 user?

          Thanks
          Gram.

          Edited by: Raj on Jan 30, 2013 1:06 PM
          1) Yes, Try to configure Agent (before configure LDAP then Configure BIScheduler via weblogic)

          http://obiee2go.wordpress.com/2012/06/07/obiee-11g6-configuring-bi-scheduler-for-ibots-on-windows/
          http://www.biztech.com/blog/2012/10/setting-up-ibots-in-obiee-11-g/

          2)No need, you just simply try to implement data level securty for country dimensional column. this will restrict data for each country.

          http://www.rittmanmead.com/2012/03/obiee-11g-security-week-row-level-security/
          http://www.clearpeaks.com/blog/oracle-bi-ee-11g/obiee-11g-advanced-row-level-security
          3) i didn't get your query, can you provide more input?

          Thanks
          Deva
          1 person found this helpful
          • 2. Re: Distribution List Reports
            Govi
            Hi
            I implemented row level security and based on user login coutry i can see report.My question is when i login Administrator(All coutry able to view).I created one agent(schudule) it should be send mail to based on coutry user wise.
            Login:Adminis
            Coury Amount
            US--------1000
            UK-------2000
            MY--------4000
            IND-----------10000


            But when i schedule this report through mail,

            User1@Ind.com he able to see only india information mail not for all information Like that.
            • 3. Re: Distribution List Reports
              user248025
              Raj wrote:
              Hi
              I implemented row level security and based on user login coutry i can see report.My question is when i login Administrator(All coutry able to view).I created one agent(schudule) it should be send mail to based on coutry user wise.
              Login:Adminis
              Coury Amount
              US--------1000
              UK-------2000
              MY--------4000
              IND-----------10000


              But when i schedule this report through mail,

              User1@Ind.com he able to see only india information mail not for all information Like that.
              Hi,

              All your above query can be done.

              Make sure your BIAdminstrator Role should not have data level filter (so that he can able to see all data) and try to set data filter to particular custom application role only (let say set data level filter for INDrole, MYrole,UKrole,USrole etc) this will restrictrict based on data filter condition.

              once you configured data level filter properly and configured mail will send report based user role (i.e mail attachment will show only user filterd data based on country so this wont show all info.

              Thanks
              Deva
              1 person found this helpful
              • 4. Re: Distribution List Reports
                Govi
                "try to set data filter to particular custom application role only (let say set data level filter for INDrole, MYrole,UKrole,USrole etc) this will restrictrict based on data filter condition.

                once you configured data level filter properly and configured mail will send report based user role "

                Could you pls explain this.How to set data filter to particular custom application role only.Where can i set.
                How to configure data level filter.While scheduling report and send mail in that time how will restric data.

                Note:I have 2 user in group MY.When this 2 user login analytics then data will restric but when mailing?


                Thanks
                gram
                • 5. Re: Distribution List Reports
                  user248025
                  Raj wrote:
                  "try to set data filter to particular custom application role only (let say set data level filter for INDrole, MYrole,UKrole,USrole etc) this will restrictrict based on data filter condition.

                  once you configured data level filter properly and configured mail will send report based user role "

                  Could you pls explain this.How to set data filter to particular custom application role only.Where can i set.
                  How to configure data level filter.While scheduling report and send mail in that time how will restric data.

                  Note:I have 2 user in group MY.When this 2 user login analytics then data will restric but when mailing?


                  Thanks
                  gram
                  Hi,

                  Let say you have two application roles (INDrole, SGrole etc) this are mapped with users (userA,UserB etc) now go to RPD -->manage --> Identity -->look at application roles tab (if non of users/roles apper try to set online filter then it will populate roles/users) --> just double clik on SGrole then --> clik on permission tab--->select data filters tab --> add your country dimensional table filter value (Singapore), as well as INDrole application role (India)

                  Once done data level filter then user only able to see their authorized data and same data will deliverd into mail (IBOTS)

                  For more,
                  http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/dataaccess.htm#CHDIFDJD

                  Thanks
                  Deva
                  1 person found this helpful
                  • 6. Re: Distribution List Reports
                    Govi
                    Now i login Admin User.My account i set delevery option like mail User1@Company.com and User2@company.com. and i set delevery profile also.

                    USer1 is MY country and user2 is SG country.(I dont have information like which user is belong to which country)

                    I login Admin then i can see all country data.When i login MY i can see only My data similarrly i login SG i can see SG data.
                    But i login admin and schedule a report.While scheduling i select receipt MY and SG.i set delivery mail also.

                    Now i login MY i got alert it shows only MY data.
                    I loign SG i got alert only SG data.

                    But delivery mail i checked user1@company.com
                    Now i can see all country data.Not restricted based on MY country.

                    My requirment is User1 mail he can see only MY
                    USer2 mail he can see only SG data.

                    Could you pls let me know How to configure this.
                    Note:I login Admin user then i create agent.

                    Thanks
                    Govind R
                    • 7. Re: Distribution List Reports
                      Paul
                      When you create the agent, look on the General tab > Run as > Recipient

                      Paul
                      • 8. Re: Distribution List Reports
                        user248025
                        Hi,

                        Edit your agent --> then select Genral tab and make sure u have select "Run As" --> weblogic (Specified user radio button) user and click on recipients tab and add Select Recipients tab (just Specify who will receive this Agent)
                        and then run it and test it

                        Thanks
                        Deva
                        • 9. Re: Distribution List Reports
                          Govi
                          Before doing this.I have to login user1 i need to set my account mail delivery.
                          similarlly i have to login User2 i need to set mail id in my account.
                          After i login administrator then agent i should selecte user1 and user2 in my receipient list.

                          Am i correct?

                          Thanks a lot to paul and deva

                          Thanks
                          Gram.
                          • 10. Re: Distribution List Reports
                            user248025
                            Hi,

                            Yes.

                            Thanks
                            Deva