Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Gauss
  • Order by date
  1. Gauss

    Need help with copying a table

    Or... insert into tableB select *, null,null from tableA Gauss
  2. Gauss

    Rolap Dimension based on a view

    Thx for your replies, MDXer! BOL: "While ROLAP dimensions can easily support real-time updates, ROLAP partitions must meet certain qualifications...". My cube's real-time-updating works well until I add a dimension based on a view. I think the strict criteria in BOL you mentioned...
  3. Gauss

    Rolap Dimension based on a view

    Hi MDXer! When i use a table (instead of a view) as dimension table for a rolap (real-time-update) dimension, i don't need to reprocess or update. When there occures a change in this dimension table, the dimension updates automatically and the change can be viewed at once by browsing the cube...
  4. Gauss

    Rolap Dimension based on a view

    Hi! I have a ROLAP cube that contains a real-time-update-dimension with a view as datasource(SQL 2000). But this dimension fails to refresh automatically when i change its members by altering the view. Is this a normal behaviour? Thanks in advance Gauss
  5. Gauss

    incremented count in a sql statement

    What about: Select last_name,date, IDENTITY(int, 1,1) AS Count into #t from table1 -- ("select... into..." is necessary) select * from #t Gauss
  6. Gauss

    copy table structure

    ... or: Select top 0 * into NewTableName From OldDatabaseName.dbo.OldTableName Gauss
  7. Gauss

    Binding Chart to Pivottable

    Try this: Private Sub ChartRefresh() Dim newchart Dim c Dim n As Integer ChartSpace1.EnableEvents = False Set c = ChartSpace1.Constants ChartSpace1.Clear Set ChartSpace1.DataSource = PivotTable1 Set newchart = ChartSpace1.Charts.Add newchart.Type = c.chChartTypeColumnClustered...
  8. Gauss

    Binding Chart to Pivottable

    We upgraded to OfficeXP. With OWC10 binding Pivottable to Chart is very easy.
  9. Gauss

    No OLAP Number Format in Pivot-Chart

    Hi netDev007. It's OfficeXP (Office Web-Components 10). Regards, Gauss
  10. Gauss

    No OLAP Number Format in Pivot-Chart

    Hello! I have a pivottable with an OLAP-Source and a chartspace bound to the pivottable (OWC10/AS2000). By using the UseProviderFormatting-property I retain the number format provided by the OLAP source in the pivottable. But when i set the HasValue-property of the...
  11. Gauss

    Pivottable and invisible Calculated Members

    Hello! I'm using a pivottable (Office 2000 Web Components) on a VB-form. Problem: All calculated members with a parent dimension different from 'Measures' are invisible when I put the related dimension onto the row - or column-axis. But it is possible to choose these calculated members, if the...
  12. Gauss

    Retrieve Database Size

    Hi Tom! Here are some suggestions to get DB-Info by T-SQL: exec sp_helpdb [DB-Name] select * from sysfiles select database_name, max(backup_finish_date) from msdb.dbo.backupset group by database_name order by 1 Please let me know if it helps.
  13. Gauss

    How do I find out the version of SQL server that is running?

    Hello! The following might be useful (after select @@version): 6.50.201 SQL Server 6.5 RTM 6.50.213 SQL Server 6.5 with Service Pack 1 6.50.240 SQL Server 6.5 with Service Pack 2 6.50.258 SQL Server 6.5 with Service Pack 3 6.50.281 SQL Server 6.5 with Service Pack 4...
  14. Gauss

    Only selected columns from sp_columns

    Hello Steve! You can use INFORMATION_SCHEMA : SELECT Column_name FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = 'table1'
  15. Gauss

    Binding Chart to Pivottable

    Hello! I have a Pivottable on a form connected to an OLAP cube via VB. How can I bind a chartspace to my pivottable, that changes when user-actions change the Table (for example adding a measure to the data-field)? Does anyone know an "simple" way to synchronize table and chart? I'm...
  16. Gauss

    Undo Migrating Repository

    Hi everyone. After executing a repository migration (Access-DB to SQL-DB) is it possible to use the Access-DB as repository again - without reinstalling SQL2000 and Analysis Service? Thanks in advance!
  17. Gauss

    peer to peer network setup?

    A brief overview:<br><br>Parts you need - network cards, connection device (hub), cables, software drivers<br><br>Steps - <br>install network cards<br><br>If Widows does not autodetect the cards go to the &quot;Network&quot; control panel and add the Microsoft client for Microsoft networks, the...

Part and Inventory Search

Back
Top