by Venkatesh Dahal » Fri, 07 Apr 2000 04:00:00
Is there an alternative to doing so? Appreciate your inputs.
Thanks,
Venkatesh
by Olivier Matra » Sat, 08 Apr 2000 04:00:00
Calculated measures cannot be persisted in local cubes so far anyway...
Olivier.
Quote:> Can Member Properties be specified in Local Cubes, we have some calculated
> measures, which need the Member Properties at various levels along the
> dimension for calculations. If so, what's the BNF for doing so.
> Is there an alternative to doing so? Appreciate your inputs.
> Thanks,
> Venkatesh
by Venkatesh Dahal » Sat, 08 Apr 2000 04:00:00
> Calculated measures cannot be persisted in local cubes so far anyway...
> Olivier.
> > Can Member Properties be specified in Local Cubes, we have some
calculated
> > measures, which need the Member Properties at various levels along the
> > dimension for calculations. If so, what's the BNF for doing so.
> > Is there an alternative to doing so? Appreciate your inputs.
> > Thanks,
> > Venkatesh
1. Problem with member properties in local cube
Hi All,
I have a problem with member properties in local cube.
I'm executing following commands to create local cube from mdb database:
Dim conn As New ADODB.Connection
conn.Provider = "MSOLAP"
conn.Properties("SOURCE_DSN") = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=PRAIST.mdb"
conn.Properties("CREATECUBE") = "CREATE CUBE Mycube (
DIMENSION [Inst],
LEVEL [All Names] TYPE ALL,
LEVEL [Name], PROPERTY [Acr],
MEASURE [Count] Function Count
)"
conn.Properties("INSERTINTO") = "INSERT INTO Mycube (
[Inst].[Name],
[Inst].[Name].[Acr],
Measures.[Count])
SELECT Institution.Name,Institution.Acronym,Institution.ID
FROM Institution"
conn.Properties("LOCATION") = "Test.cub"
conn.Open
The local cube was created, but the member property [Acr] doesn't appear.
Where is the problem?
Thanks for any suggestions
Ivo.
2. JDBC thin and OCI8 drivers for NT
3. Member properties in local cube for Analysis Services?
4. Maths
5. Member Properties in Local Cubes
7. Member properties in local cubes
8. How to create .dll in vb 4.0
9. Custom member properties in a local cube
10. Creating a member property for a local cube.
11. Local Cube - Member Property
12. Blank members appear in local cube created from virtual cube
13. Local cube from local cube