5 Replies Latest reply on Apr 6, 2016 12:32 PM by Tiago Ferrucio

    Problem with publish datasource

    Tiago Ferrucio

      Hi guys

       

      I have 2 (two) dashboard that use only datasource. This datasource there are some calculated field, but when publish to server this datasource the field is invalid in other dashboard..

       

      Below printscreen to error:

       

        Someone know about this erro?

       

        Regards,

        Tiago Ferrucio

        • 1. Re: Problem with publish datasource
          Andrew Watson

          Are the calculated fields actually within the published data extract OR are (were in the case were they're invalid) they only in the workbook?

           

          A good way to find out would be to connect an empty workbook to the data source and see if the calculated fields are there.

          • 2. Re: Problem with publish datasource
            Tiago Ferrucio

            Andrew

             

            The calculated fields are in published data extract, but when publish he lose references.

             

            Below printscreen to calculated field with error and correct:

             

            - The calculated filed use field others datasource.

             

            Thanks,

            Tiago Ferrucio

            • 3. Re: Problem with publish datasource
              Andrew Watson

              Ok, I understand now and can only make assumptions as to what it looks like is happening. It appears you're trying to link to a calculated field within a secondary data source. Logically this would create problems as an extract is a stand-alone object, it appears it's not possible to build in dependencies on other extracts that may or may not be available for the extract to read.

               

              I think you would be better having cross extract calculated fields within a workbook where the extracts are actually available, which does mean they wouldn't be available in a published extract. If they have to be available within a published extract then based on what I'm seeing the data from the different extracts would require combining into one master extract.

               

              Perhaps someone else has a better idea than I about this.

              1 of 1 people found this helpful
              • 4. Re: Problem with publish datasource
                Andrew Connolly

                Hi Tiago--

                 

                I think I've seen this issue before. Try publishing the secondary data sources (orange check marks) first. Then republish the primary data source (blue check mark, has these broken calculations). When you publish the primary data source, you may get a warning message, but just hit okay. Then connect your workbook and swap in these new, published data sources. The calculations should be working now.

                • 5. Re: Problem with publish datasource
                  Tiago Ferrucio

                  Hi Andrew

                   

                  I extract the datasource and deleted the fields with problem after I created the calculations in workbook.

                   

                  Thans very much!

                   

                  Tiago Ferrucio