Hi,
After I renamed my data source view in BIDS (SSAS ServicePack1), I now get an error when I try to build my SSAS project:
Error 1 Dimension 'Date' : The 'Source' property references unknown 'Data Source View' with ID='XXXX'. 0 0
I tried to change this directly in the XMLA for Date.dim file, but it still doesn't work.
Any pointer\workarounds anyone? I would hate to have to recreate by dims again, just for this.
Thanks,
JGP
Anyone from MSFT can comment on this?
Thanks,
JGP
Hi,
After I renamed my data source view in BIDS (SSAS ServicePack1), I now get an error when I try to build my SSAS project:
Error 1 Dimension 'Date' : The 'Source' property references unknown 'Data Source View' with ID='XXXX'. 0 0
I tried to change this directly in the XMLA for Date.dim file, but it still doesn't work.
Any pointer\workarounds anyone? I would hate to have to recreate by dims again, just for this.
Thanks,
JGP
Anyone from MSFT can comment on this?
Thanks,
JGP
Hi.
Possibly a simple question...
I generated a server time dimension and want overwrite the shown text. Instead of e.g. Calendar 2007 I want only show 2007. But I do not find a way to overwrite the member labels.
THX for any help,
Nils
Hi,
Create a named calculation with the name "CALYEAR" and in Expression
Substring(fieldname,10,4)
Note: fieldname is your column name
It will create a new named calculation with the name "CALYEAR"
Open the Server time Dimension and click on the field Calenderyear and select the Properties.
In properties Select NameColumn and Select the Source and change the ColumnID -> CALYEAR.
Deploy it and check it out
This will help you
Dinesh
Chris Webb submitted this request on the Connect site, please see details on this page. Someone from Microsoft has replied, saying they will consider it for the "next release" (as at Aug 2006).
Does anyone know if this has been included in the Katmai (2008) beta releases so far? Or is it likely to before RTM?
Thanks
Ken
No, this feature will not be in Analysis Services 2008. We are still tracking it for possible inclusion in the next major relase after SQL Server 2008.|||
Shame... it might seem like a minor change, but I've lost count of the number of times I've started off using role-playing dimensions and then had to go back and change to separate but practically identical dimensions just because of this...
Chris
sqlChris Webb submitted this request on the Connect site, please see details on this page. Someone from Microsoft has replied, saying they will consider it for the "next release" (as at Aug 2006).
Does anyone know if this has been included in the Katmai (2008) beta releases so far? Or is it likely to before RTM?
Thanks
Ken
No, this feature will not be in Analysis Services 2008. We are still tracking it for possible inclusion in the next major relase after SQL Server 2008.|||
Shame... it might seem like a minor change, but I've lost count of the number of times I've started off using role-playing dimensions and then had to go back and change to separate but practically identical dimensions just because of this...
Chris
Chris Webb submitted this request on the Connect site, please see details on this page. Someone from Microsoft has replied, saying they will consider it for the "next release" (as at Aug 2006).
Does anyone know if this has been included in the Katmai (2008) beta releases so far? Or is it likely to before RTM?
Thanks
Ken
No, this feature will not be in Analysis Services 2008. We are still tracking it for possible inclusion in the next major relase after SQL Server 2008.|||
Shame... it might seem like a minor change, but I've lost count of the number of times I've started off using role-playing dimensions and then had to go back and change to separate but practically identical dimensions just because of this...
Chris
