Showing posts with label names. Show all posts
Showing posts with label names. Show all posts

Wednesday, March 28, 2012

One Dimension - Several Hierarchies - For each hierarchy an own UNKNOWNMEMBER name

Hi,

it is possible to set for each hierarchy, of them that belongs

to one dimension, different names for the Unknown Member?

Perhaps under calculation tab for each cube?

How wuold be here the right syntax?

Thank you in advanced,

Mastroyani

Unfortunately not, as far as I know. If you really need this you should probably handle the missing members in your ETL and assign them different names there. There are several dimension properties which I'd like to see made attribute properties; the AttributeAllMemberName property is another one:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=144234

Chris

|||Thank you!

Friday, March 9, 2012

OLE DB provider name

Hi,
I am trying to get a list of most possible provider names (OLE DB) for the
following database types: (for instance, Access - "Microsoft.Jet.OLEDB.4.0")
DB/2
Ingress
Informix
MySQL
Oracle
Postgres
SQL Server
Sybase
Virtuoso
Can anyone help?
Thanks in advance."Danila Vershinin" <cia@.pnz.ru> wrote in message
news:OYxD$re8FHA.3132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to get a list of most possible provider names (OLE DB)
for the
> following database types: (for instance, Access -
"Microsoft.Jet.OLEDB.4.0")
> DB/2
> Ingress
> Informix
> MySQL
> Oracle
> Postgres
> SQL Server
> Sybase
> Virtuoso
> Can anyone help?
> Thanks in advance.
>
Danila Vershinin,
http://www.connectionstrings.com/
http://www.carlprothman.net/Default.aspx?tabid=81
Sincerely,
Chris O.