Recent content by Gauss

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

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...

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...

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

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

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

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...

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

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

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...

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...

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.

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...

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

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...