Forum Replies Created

Viewing 15 posts - 1 through 15 (of 595 total)

  • Reply To: SSAS Referenced Dimension

    ktflash wrote:

    What i dont understand is that you can create a Customer Dimension that also directly has the Geography information. So bascially add the Geography columns to the Customer Dimension...

    • This reply was modified 1 year ago by  PB_BI.
  • Reply To: xml output from sql query

    Bruin wrote:

    Correct in original script... It falls thru to:

    # Message stating no data to export. Write-Host "There is no data to export."

    Thanks.

     

    Did you look at the link I sent? Try...

  • Reply To: xml output from sql query

    So the issue is still that your evaluation is saying you have no rows? Or is is something else? If the former have a look at the answers on the...

  • Reply To: xml output from sql query

    Bruin wrote:

    I picked 2 fields in the table and it displayed them:

    System.Data.DataRow 11-371517-582-3-02 2VAK

     

    Well, it displayed one of them. It is telling you that one of the "fields" is a ...

  • Reply To: xml output from sql query

    Bruin wrote:

    any ideas why script not working?

    Thx.

     

    What is the output of the debug script I provided above?

  • Reply To: xml output from sql query

    What do you get if you have Write-Host $items after the invoke-sql ? Also, change the "SELECT *" to use the actual columns that you need.

    Another thing you could try...

  • Reply To: xml output from sql query

    Try $items.Rows.Count

  • Reply To: Transaction log and updates on large tables

    ajans_guernsey wrote:

    I’ve inherited a query that on first glance should be re-written. The main part of which is performing an update on a table (200m+ rows) in a while...

  • Viewing 15 posts - 1 through 15 (of 595 total)